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
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