configuring remote database on nginx/mysql
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.
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.×