Two Masters One Slave... If anybody know about it, please help me.

[superNEM]

Hello all,

I have two master database server on two different machine and a slave on an another machine. Slave is now used for replication of one master database.

But I want to use slave for the both master database server. Can I use one slave for two master? If yes, how should I do that?

Thanks and regards!

 

[QatQat]

No. You can't.
2slaves for 1 master is possible. And it is more logic. Using two master servers you will have two separate datasets which is no good.


If the slave is in synchro with the first one then it replicates only data from the firts one.

To achieve your configuration you need to put two masters in synchrony.
From what I know MySQL does not accept peer replication which would keep two masters updated, but only master/slave setup. So you have to create 1 master and 2 slaves.


Bye

Qatqat


Bye

Qatqat

I have been happy throughout my life in thinking that samba was I kind of dance; now I live with Linux and all I do is working.