Site in a Linode, database in other Linode

Hey There!

We don't have a step by step tutorial, but I'd be happy to help as much as I can.

1. You will want to create the DB Linode and make sure to add a private IP to both your web server and your DB server. Also, ensure that your reboot your Linode after that change and ensure that Network Helper is enabled so it can automatically configure the private IPs.

2. Install MySQL on the new DB server

3. Configure MySQL to allow connections from your web server

   Locate and edit your MySQL configuration file:

   sudo vim /etc/mysql/my.cnf
   

   Locate "bind-address" within the configuration file and add your db server private IP:

   bind-address = $databaseip
   

   Force the change by restarting MySQL:

   sudo service mysql restart
   

From there, you can configure your application/web server to communicate through DB servers private IP. You may need to make additional changes, but that should help you get started with a basic setup.

I hope that helps!

@hmorris Wow, thank you very much for your reply, I will try to effect the settings in which you are recommending and see what will give.

I'll come back here with the result as soon as I get it!

Do you think you would gain performance by doing this? Avoid overloading?