title: Performance about distributed database on a single physical machine?
body: <p>Currently I'm working with time-series data(Tickers) and stored the pandas dataframe in <code>.h5</code> and <code>.parquet</code> format. My workload is basically querying the columns of data &amp; writing new columns of data.</p>
  <p>It starts to get out of control when the files increases and scatters around, so I'm considering using a database. I saw some NoSQL database like Cassandra and HBase.</p>
  <p>These database often emphasis that they are <code>distributed</code> or <code>elastic</code> database. <strong>But I only have one single physical machine(a 3990x 64-core threadripper)</strong>.</p>
  <p>So my question is basically two part:</p>
  <ol>
  <li><p>What is the performance if I run these <code>distributed</code> database on a single node? Will they still outperform a traditional database like mySQL regarding my workload?</p>
  </li>
  <li><p>Can I use virtualization to build a cluster? Say, using ESXI to virtualize multiple nodes? Will they outperform a single node setup?</p>
  </li>
  </ol>