title: Which is better Database design explode or impode? (MariaDB or MySQL)
body: <p>I'm developer preparing new version solution of current solution in my company. </p>
  
  <p>Currently, application create database per our clients. For example
  db1,db2,db3.....,db100,db101...
  And server has 8 thousand of database.</p>
  
  <p>This has benefit of performance of CRUD and backup or rollback database per client. Problem is some noise code on my application source.</p>
  
  <p>I cannot define database config file statically because database created and removed dynamic. All of my code write query using client's number such as below</p>
  
  <pre><code>"select * from db"+clientNumber+".table"
  </code></pre>
  
  <p>or create new database connection for every request.</p>
  
  <p>In our new version, I want to manage one database that combined all current database. If I do, some table has tens of million data row. Forasmuch I've never experienced manage tens of million data row table, I cannot judge this is good practice. And how backup and rollback program will developed?</p>