MySQL Forums
Forum List  »  Replication

Master - slave connection
Posted by: Walter Vrey
Date: December 04, 2009 09:30AM


This is my first master - slave setup - so new to this..

I have a 1 x master - 4 x slave setup
All are connected and in sync with the master db.

I run all select statements on the slaves and update - insert and delete on the master db.

If I do not run queries on the slave db's then it keep up with the master, but as soon as I start querying the slaves, and update records to the master , do they fall behind and do not update any more.

The "show slave status" command show they are still connected, but the log_pos is behind the master. It looks like the master do not send the slaves the latest updates.

I am using INNODB

Any suggestions please?

Options: ReplyQuote

Written By
Master - slave connection
December 04, 2009 09:30AM
December 05, 2009 11:13PM

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.