Hi This is no problem
To do this, 1 - Duplicate database A, creating second database B, ensuring that both have separate serve IDs. 2 - Configure both A+B to replicate each other, but enable log-update on database A. This will allow database A to act as a master to both databases. 3 - Create third database C, and set it to replicate from database A. You should end up A+B replicating each other, with C as a read only copy of them. I hope that this helps Simon ----- Original Message ----- From: "Osmin Castillo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 12:35 AM Subject: replication: 2 masters and 1 slave > Hello guys, I have this question: > > I need to replicate 2 databases (each one resides in a different > server) to a single slave server. Reading the documentation I have > running the master/slave replication, but i need to replicate the > other database too, the problem is: I need replicate the other > database and that database exists in the other server, so how I > configure the other master server/datatabase in the slave? > > Is that posible? > > Anybody has running this 2 master/ 1 slave configuration? > > Any ideas? > > thx > > Osmin > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
