I want to setup mysql replication between two servers one of them is my localhost and the other is online server.
I have all availability to make any one of them the master.
But according to that my localhost server doesn't have a static IP, i need to know which server of the two (master & slave) is the one which requests the other for doing updates.
Does the master sends the binlog updates, or the slave is the one which requests for new updates periodically ? so i will make it the localhost.
thank you in advance.
Mysql – In thesql master-slave Replication which server requests the other
MySQLreplication
Related Question
- MySQL replication as both master and slave (replication loop?)
- MySQL Replication Master push to Slave
- Mysql – Can a slave with a dynamic ip update the master
- MySQL – Replication Slave of Slave Not Receiving Updates
- MySQL slave server getting stopped after each replication request from Master
- MySQL Replication – How to Fix Slave Lagging Behind Master
- MySQL – Adding New Slave to Master-Master Replication
Best Answer
according to this reference: Get MySQL Replication up and running in 5 minutes, Slave must access master to initialize.
So, you can setup slave in localhost and master in remote host with accessible IP and port.
This is a client server communication: