Hello I was wondering how can i setup this scenario as many users recommend it in high traffic forums. 1)Let's say server one for my forum files (php) i will need a server using Centos and cpanel and nothing else i think or... 2)Second server must have centos (32 or 64bit does matter?) and mysql only in it. 3)So i will be able to upload my db to the second server using ssh as in the past? 4)How can i connect both servers so my forum start working? 5)Someone told me using Whm but which tool and how? Thank you
at the place in vbconfig instead of localhost you put the ip address of the server the mysql is on Then just do this http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
More details please? I will need on both server cpanel? Any document or video tutorial for that? Thank you
Hi there, I have set this up before. A couple of notes. 1. Make sure that both servers have two network cards. One card on each server will be used to talk to each other, and the second card on each server will be used for network access. 2. Once cPanel is installed on the first machine, copy the entire /scripts folder to the second machine. The second machine will not need cPanel installed on it. 3. Go to WHM on the first machine, and use the "Setup Remote MySQL server" option. This will install mysql and anything else it needs. 4. Make sure your configuration files use the IP address of the second server for the host, instead of 'localhost'. This of course, should be something like 192.168.100.2, and the two machines should be tied directly together, and this should not be the external IP address of the second machine. That should get you rolling of the right path.