Relication from multiple databases
Anyone know if it's possible to do replication from more than one database? Example: System A: Database 1 System B: Database 2 System C: Replication of SYSA:DB1, Replication SYSB:DB2 Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Relication from multiple databases
No, unfortunately you cannot have multiple masters on a single replication slave. You can however have multiple daemons running on system (C) via mysqld_multi. Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 13 Jan 2006, Jeff wrote: Anyone know if it's possible to do replication from more than one database? Example: System A: Database 1 System B: Database 2 System C: Replication of SYSA:DB1, Replication SYSB:DB2 Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Relication from multiple databases
Hello. MySQL allows to have only one master for replication. But if it is possible in your production environment, you can replicate from A to B (database names can be rewritten with replicate-rewrite-db), and replicate the whole stuff to C. I agree, this is not an ideal workaround,but hope this will help. Jeff wrote: Anyone know if it's possible to do replication from more than one database? Example: System A: Database 1 System B: Database 2 System C: Replication of SYSA:DB1, Replication SYSB:DB2 Thanks, Jeff -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]