I'm looking to do an infrastructure overhaul.Currently I have a ton of small databases scattered amongst our assets and I wish to consolidate them.
Is consolidating all databases to 1 tuned database a good idea? Will I get greater performance if I only have a single database VM on a cluster?
The tuning options I've been looking into are:
innodb_buffer_pool_size=8000M innodb_flush_method=O_DIRECT innodb_file_per_table log_slow_queries=/var/log/mysql.slow.log thread_cache_size=4 query_cache_limit=1M query_cache_size=128M max_connections = 400 join_buffer_size=256k read_buffer_size=256k read_rnd_buffer_size=256k innodb_flush_log_at_trx_commit=2
Thank you for your time.