MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: how to setup master, primary slave master and slaves
Posted by: Rick James
Date: September 14, 2010 07:51AM

Let's see SHOW MASTER STATUS and SHOW SLAVE STATUS everywhere. (Use \G if using commandline tool.) Also, see if there is anything relevant in mysqld.err.

Perhaps replication is temporarily stuck. (SLAVE START might fix it.)

Perhaps there is an error (eg Duplicate key) implying that the servers are not in sync. This would probably lead to having to reclone S* from R.

See maatkit.org for a tool to compare master/relay and relay/slave. (I think it will only work when replication is functioning.)

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
how to setup master, primary slave master and slaves
3877
Victor Matladi
September 10, 2010 03:36AM
Re: how to setup master, primary slave master and slaves
1501
Rick James
September 12, 2010 12:45PM
Re: how to setup master, primary slave master and slaves
988
Victor Matladi
September 13, 2010 01:22AM
Re: how to setup master, primary slave master and slaves
1337
Rick James
September 13, 2010 10:44AM
Re: how to setup master, primary slave master and slaves
1363
Victor Matladi
September 14, 2010 02:15AM
Re: how to setup master, primary slave master and slaves
1056
Rick James
September 14, 2010 07:51AM
Re: how to setup master, primary slave master and slaves
1182
Victor Matladi
September 14, 2010 08:47AM
Re: how to setup master, primary slave master and slaves
1019
Rick James
September 14, 2010 08:16PM
Re: how to setup master, primary slave master and slaves
1014
Victor Matladi
September 15, 2010 12:53AM
Re: how to setup master, primary slave master and slaves
1045
Rick James
September 15, 2010 06:03AM
Re: how to setup master, primary slave master and slaves
851
Victor Matladi
September 15, 2010 07:48AM
Re: how to setup master, primary slave master and slaves
987
Rick James
September 15, 2010 08:40AM
Re: how to setup master, primary slave master and slaves
1094
Victor Matladi
September 15, 2010 08:56AM
Re: how to setup master, primary slave master and slaves
957
Rick James
September 15, 2010 09:25PM
Re: how to setup master, primary slave master and slaves
978
Victor Matladi
September 16, 2010 02:15AM
Re: how to setup master, primary slave master and slaves
1017
Lance Badger
September 16, 2010 02:45PM
Re: how to setup master, primary slave master and slaves
1213
Rick James
September 16, 2010 09:07PM
Re: how to setup master, primary slave master and slaves
956
Victor Matladi
September 18, 2010 08:27PM
Re: how to setup master, primary slave master and slaves
1148
Rick James
September 18, 2010 09:53PM
Re: how to setup master, primary slave master and slaves
1066
Victor Matladi
September 22, 2010 06:15AM
Re: how to setup master, primary slave master and slaves
943
Rick James
September 22, 2010 07:38PM
Re: how to setup master, primary slave master and slaves
892
Victor Matladi
September 27, 2010 07:38AM


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.