Hello, We have another question relating to changes to our current tech infrastructure. As of right now, we have a single, dedicated server which is running Django on apache, mysql percona and various batch jobs running throughout the day which is managed by cron. The database is taking the bulk of the cpu and is likely to grow in load very soon. We are thinking of getting another dedicated server just for the mysql database to give it full capacity of the processor. Given the these dedicated servers will be within the webfaction intranet, we would like to know if it's possible for the web server on one host to connect to the database server on the other host without any encryption or ssh tunneling. Is it possible to set this up? Thanks. Alok
This question is marked "community wiki".
|
Yes, this can be done by adding a dedicated IP address to your server running percona. On a dedicated IP address, we can open a port for your mysql server, and then you can configure mysql to only accept remote connections from the IP address of your other server. In this way, you should be able to achieve server-to-server direct communication without needing an SSH tunnel. In order to add a dedicated IP address and/or open ports in an IP address, simply open a support ticket. answered 14 Feb '12, 03:32 ryans ♦♦ |