I have an application running in one server eg: My Server's Ip is 192.168.10.10, and I have the MySQL database server in the same machine. The application connects database server as
However, I have rented new server now and the IP is 192.168.10.11, it also has its own MySQL database server.
My quest is, I want this new server to be the slave of old server. I don't want to copy the Application to New Server, however I want the application in 192.168.10.10 (old server) to access the database of New slave server without exploiting security risks. The reason I want this is to send the
read queries to new server, and
write queries would be served by same old server.
Please guide me how to achieve this.