homepage Welcome to WebmasterWorld Guest from 54.167.41.199
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
mysql dual master multi-slave setup
soned




msg:4587012
 4:11 am on Jun 24, 2013 (gmt 0)

hello fellow mysql admins!

I have a question you guys may the answer to.

I am familiar with single master to multi slave setup. I am also familiar with dual master setup.

However, I want to ask you:

Is it possible to have a dual master with each master having their own slaves?


from my initial testing, I got a dual master setup and one of the master (M1) has slaves.

what I noticed is that if I update records in M1, the slaves and M2 are updated. But if I edited from M2, only M1 is updated. M1 slaves are not updated.

I am on mysql 5.1.x

Any way to fix this?

thanks

 

soned




msg:4587092
 11:24 am on Jun 24, 2013 (gmt 0)

nevermind. I found it. 1 word: log-slave-updates

whoisgregg




msg:4587909
 5:08 pm on Jun 26, 2013 (gmt 0)

Glad you got it sorted and thanks for posting back with your solution, soned! :)

soned




msg:4588040
 5:00 am on Jun 27, 2013 (gmt 0)

based on testing log-slave-updates, however, there is a problem with the way they log.

In my setup, I only enabled it on M1. M2 does not have it because:

that flag will write to binlog all the master and slave changes. since M1 and M2 are both master and slave... both of them will keep logging each other in an endless cycle.

unless someone can share a way to not write to binlog those queries you already writted to the slave binlog

or maybe i did something wrong?

soned




msg:4588505
 3:10 pm on Jun 28, 2013 (gmt 0)

oops this was just my assumption. right now M2 does not have slaves so I can't tell of it will be a problem, i just noticed that if log-slave-updates is On in M2, the M2 binlog is adding data from its slave writes

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved