I'm running into scaling issues with a Rails app running on top of MySQL. I'm using memcached and have lots of indexes.
I'm also starting to increase values for certain my.cnf settings like tmp_table_size
and innodb_buffer_pool_size
.
But then that brings me to my question. Should I move the MySQL database to a second, dedicated database server (thus increasing the amount of memory MySQL can use for buffer pools and such) OR should I increase the RAM on the current server, which hosts both Rails and MySQL?
I'm assuming I an increase the RAM available to MySQL much more if I move MySQL to its own server. But I'm worried about the latency of MySQL queries sent over the network between the two servers instead of through mysql.sock
.
Any advice?