I am a PHP Programmer and working on community website. I am using Apache NodeJS Php and Mysql on server: 24GB RAM Intel i7 950 8Cores 8Threads 3.06GHz, 120GB SSD HDD 12GB SWAP (dedicated server) OS: Debian Wheezy. My question is should i have to separate Mysql from PHP and Node JS on 2 (two) different severs, because i am worry when more than 20 000 people will login and start browsing the website make requests to DataBase etc... Also i am using Codeigniter 2.0.13, Socket.IO for Private CHat, Chat Rooms and Notifications ->everything is inserting the data in MySQL.
I have one more server with same parameters so shoud i separate MySQL from Php ,NodeJS.
Thanks Guys