I need some advice about our new database deployment plan.
We have 6GB of total mysql data(all innoDB) and innoDB_buffer_pool is set to be 16GB Ans we have 2 database servers.(plus 1 server for the nginx and php). Mysql Version is 5.6.20
- Server #1 - 1 Qual Core CPU , 48GB ram
- Server #2 - 2 Quad core CPUs, 96GB ram
We currently have 1 master for server #1, and 1 slave for server #2 and using mysqlnd_ms plugin to do real/write splitting for better performance.
But since we do have plenty of ram spaces we are seeking some ideas to boost our database performance up.
Our question is if we have plenty of ram space like this, would it be beneficial if we have multiple mysql replications each server and use mysqlnd_ms plugin to distribute traffics?
- for Server #1 - 1 replication slave and 1 master.
- for Server #2 - 4 replication slaves
- Plus load balance using mysqlnd_ms plugin.
We just assume it could bring some performace advantage, but this is unser production so we can't tweak these servers freely.
If this idea is meaningless, could you provide some ideas?