MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Replication Setup          MySQLTalk.org Forum Index -> MySQL Replication Discussion View previous topic :: View next topic   Author Message Krishna Chandra Prajapati Guest Posted: Fri Oct 17, 2008 12:08 pm    Post subject: Replication Setup Hi List, Below is a sample structure of replication. master slave/master slave A ----------------------------> B ------------------------------------> C db1 db1 db1 db2 db2 db3 db3 1. In the above setup server B is both master and slave. 2. On server B i have used log_slave_updates and replicate_do_db = db1 Question Do i need to use binlog_do_db = db1 db2 db3 on server B to replicate the data to server C or automatically all the data will be replicated to server C. On server C do i need to use replicate_do_db = db1 db2 db3 in order to replicate or automatically replicate. Thanks, Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: prajapatikc (AT) gmail (DOT) com Back to top Rick James Guest Posted: Sat Oct 18, 2008 5:03 am    Post subject: RE: Replication Setup Don't need any do/ignore commands. But you do need log_slave_updates and binlog turned on. B is a "relay". It is a single point of failure from which it is messy to recover. It is not easy CHANGE MASTER on C because it is not obvious where in the replication stream things are. Alas, this problem also exists in dual-master since the backup master is effectively a "relay". Quote: -----Original Message----- From: Krishna Chandra Prajapati [mailto:prajapatikc (AT) gmail (DOT) com] Sent: Thursday, October 16, 2008 11:56 PM To: MySQL replication Subject: Replication Setup Hi List, Below is a sample structure of replication. master slave/master slave A ----------------------------> B ------------------------------------> C db1 db1 db1 db2 db2 db3 db3 1. In the above setup server B is both master and slave. 2. On server B i have used log_slave_updates and replicate_do_db = db1 Question Do i need to use binlog_do_db = db1 db2 db3 on server B to replicate the data to server C or automatically all the data will be replicated to server C. On server C do i need to use replicate_do_db = db1 db2 db3 in order to replicate or automatically replicate. Thanks, Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: prajapatikc (AT) gmail (DOT) com Back to top Moon's Father Guest Posted: Tue Oct 21, 2008 5:19 am    Post subject: Re: Replication Setup You must explicitly point binlog_do_db on server B. On Sat, Oct 18, 2008 at 8:03 AM, Rick James <rjames@yahoo-inc.com> wrote: Quote: Don't need any do/ignore commands. But you do need log_slave_updates and binlog turned on. B is a "relay". It is a single point of failure from which it is messy to recover. It is not easy CHANGE MASTER on C because it is not obvious where in the replication stream things are. Alas, this problem also exists in dual-master since the backup master is effectively a "relay". -----Original Message----- From: Krishna Chandra Prajapati [mailto:prajapatikc (AT) gmail (DOT) com] Sent: Thursday, October 16, 2008 11:56 PM To: MySQL replication Subject: Replication Setup Hi List, Below is a sample structure of replication. master slave/master slave A ----------------------------> B ------------------------------------> C db1 db1 db1 db2 db2 db3 db3 1. In the above setup server B is both master and slave. 2. On server B i have used log_slave_updates and replicate_do_db = db1 Question Do i need to use binlog_do_db = db1 db2 db3 on server B to replicate the data to server C or automatically all the data will be replicated to server C. On server C do i need to use replicate_do_db = db1 db2 db3 in order to replicate or automatically replicate. Thanks, Krishna Chandra Prajapati MySQL DBA, Mob: 9912924044 Email-id: prajapatikc (AT) gmail (DOT) com -- MySQL Replication Mailing List For list archives: http://lists.mysql.com/replication To unsubscribe: http://lists.mysql.com/replication?unsub=yueliangdao0608 (AT) gmail (DOT) com -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> MySQL Replication Discussion All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.