|
-
mySQL Master Slave
Yes, it is possible to make replication slave for two mysql masters. We can do it by running two mysql instances with different port.
Here
Slave -> single server
Master -> 2 server(remote)
Here is the way to configure the same
Let me explain with example
Remote server1 -> A (master 1)
Remote server2 -> B (master 2)
Local -> C (slave)
Master 1 running in port 3306 and Master 2 also running in the same port (3306)
Create two mysql instances say, mysql_3306, mysql_3307 for slave which is running in port 3306 and 3307 respectively.
Hope you know about configuring the mysql replication.
mysql_3306 instance must be connected with [A] master1
mysql_3307 instance must be connected with [B] master2.
By this way, you can configure the replication for master-master-slave replication
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|