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.