MySQL Forums
Forum List  »  Replication

Re: how to setup master, primary slave master and slaves
Posted by: Rick James
Date: September 15, 2010 06:03AM

SHOW PROCESSLIST;
You should see one replication thread per slave on each master (R is a master).
You should see two replication threads on each slave (R is a slave).
If not; that will be a clue.

What is the "user" being used for replication? Double check it by looking in the file master.info (on slaves).

SHOW GRANTS FOR "repl_user"; -- this must exist on masters (M & R)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to setup master, primary slave master and slaves
1038
September 15, 2010 06:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.