I'm running a couple of projects which consume a lot of MySQL power (10'000 qps in peaktimes)...now I'm wondering what would be the best setup in order to keep it fast and smooth even if the user numbers grow.
Currently I'm using 1 server with nginx, php-fpm and mysql (dual xeon, 24 GB ram, SSD's) and connecting to MySQL through a local socket.
Would I experience a "performance drop" if i had a remote MySQL server of the same specification in order to split up webserver / db load?