4

Performance: mysql socket vs. mysql remote

view full story
linux-howto

http://serverfault.com – I'm running a couple of projects which consume alot 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? (HowTos)