configuring remote database on nginx/mysql

Posted on March 9, 2016

Hello, I’ve been reading this awesome article and thinking to implement for my next project.

but before that, i have few questions that needed to be clear first,

Q1. im going to connect database server & web server through private networking, so how can i connect remotely to my database server? can i connect via remote databse software as im not that familiar on working with ssh tunnel. and for that if i open a port for my database server, does it compromise security too much?

Q1. if above is not possible, i would like to install phpmyadmin on database server, and for that i need to have nginx & php installed on database server. will it make and performance drop? between 2 servers?

i have also asked same questions on that above link but nobody replied. hope someone will reply me here.

Thanks in advance.

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

swifty

March 9, 2016

Hey there,

You can certainly setup MySQL on its own Droplet and setup another Droplet to access it over private networking. Please keep in mind that in order to use private networking between two Droplets, you will need to have both Droplets in the same region. For more information on setting up remote access, have a look at the following article:

https://www.digitalocean.com/community/tutorials/how-to-set-up-a-remote-database-to-optimize-site-performance-with-mysql

Regards, Mike C Platform Support Specialist DigitalOcean Support