Looking for input / opinion on project.
I am currently working on a large Drupal deployment with many sites. The majority of the sites will get very low amounts of traffic.
On my test Percona cluster using innodb with one file per table empty cloned site database using 23MB ends up being 234MB on the filesystem. So file storage efficiency with this setup is non-workable.
The current options I am looking at
Put everything on a single giant tablespace file and use Percona Cluster to load balance.
Separate low load databases from the high load ones into separate servers.
a. Use Percona Cluster of for high load
b. basic master slave replication using ARIA or MyISAM engine.
Is option (1) feasible? What kinda of issues will I hit with this volume on databases and tables in a single tablespace file?
Any other ideas on how to tackle this volume on databases?
Thanks for any input