yes. but that depends if you're planning to sync the same table on both A,Z,C which i'm not sure how you're currently handling the index. However, you might want to consider the ff options:
option 1: Replication chain where A -> Z -> C -> B. caveat: server Z and C are burdened with the unnecessary load/traffic option 2: Create a script that would sync the slave servers with A, Z,C one at a time. where A ->B , Z -> B, C -> B. caveat: sync are not in "real-time" option 3: Run multiple MySQL server instances on the slave host[1] where A ->B , Z -> B, C -> B. caveat: database files from A,Z,C are isolated on B. option 4: use MySQL 5.1 [2] caveat: downtime due to migration. [1] http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html [2] http://ftp.arnes.si/mysql/doc/refman/5.1/en/replication-auto-increment.html > 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. > > [....] >
_________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
