multiple replication in mysql

packets · 08-05-2008, 04:01 AM

I'll be replicating some of our mysql server to one central mysql server. Its ok to replicate server A master to server B slave. However, is it possible let's say I have server A, server Z and server C replicate all of their database to one server lets says server B in realtime? Most I know is peer-to-peer replcation. Don't know if its possible for multiple master.

mysqldump and mysqlhotcopy takes time so I'm looking for alternative backup and replicating might be the alternative

chrism01 · 08-05-2008, 09:16 AM

I doubt it, but you could ask at the Mysql Replication forum: http://forums.mysql.com/list.php?26

Let us know the answer.