Splitting up app (php) and database (mysql) server; best practices and guidelines?

Hi all,

I am currently researching the different options available for splitting up app (php) and database (mysql) server away from one single server. Installing the servers and software is not the issue, but my main concern is the communication between the two. How can one assure that this is done secure?

The most easy way would be to just enable remote mysql access for the appservers ip, but that is probably not that secure. I also read about setting up sshtunnels between the boxes, but that sounds pretty iffy too. I know for example that @Francisco offers shared remote mysql, how is this done and can somebody please help and advise me?

Thanks for your time all! Daniel

http://ift.tt/1dvHQ0Z