Mysql Replication On Windows Server
I am trying to do Master to Master Replication in Windows Server 2008. I am successfully able to replicate all the database of Master 1 to Master 2.
Mysql 5.7 Replication Setup
Mysql Replication On Windows Server Windows 10
But I am unable to replicate the changes made on Master 2 to Master 1. Later on I found that, I can telnet to Master 1 from Master 2 with port 3306 but I am not able on telnet from Master 1 to Master 2.When I check netstat on both Master. I found the following result. 'Telnet' just means you can establish a TCP connection. Don't focus that much on it.The more important information is in your netstat output. As you can see, the MySQL process on Master2 is only listening on 127.0.0.1, not on the 'Master 2' interface. Cyberlink powerdvd ultra 18.
You will need to configure MySQL to listen to that interface.On Linux systems, you would edit /etc/my.cnf and change the bind-address parameter to something other than 127.0.0.1 and restart MySQL. I'm unfamiliar with how to do this on Windows, but there should be a similar way to change this parameter (maybe through an admin GUI?).