Is it possible for slave to connect to 2 different masters and have
synchronized database from both?
Planning to have one backup mysql backup server that's has to
synchronize/backup
2 master server.
Followed the manual and got master / slave up and running without
problem.
Can I use something
Erik Olsen wrote:
Is it possible for slave to connect to 2 different masters and have
synchronized database from both?
So you would have updates on 2 masters M1 and M2 which would be
replicated to the read-only slave S1 ?
The point of MySQL's replication is that after an replication-event
there
Yes. The idea was to backup 2 masters, 1 that is ours and 1 that is a
costumer. The slave's job is just going to have a synchronised db of
both servers db. The plan was to have it on a different place in case of
fire.
But I must find another solution then.
Erik Olsen wrote:
Is it possible
May be I am misunderstanding your goals but it seems that you want to
have a backup server for two independant masters (with different
databases). Something like:
M1 -- S -- M2
DB1DB1 DB2
DB2
If this is the case, you can run two mysqld instances on S, each one
