MySQL Forums :: Replication :: Master - slave connection


Advanced Search

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

Hi,

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?
Regards
Walter

Options: ReplyQuote


Subject Views Written By Posted
Master - slave connection 2728 Walter Vrey 12/04/2009 09:30AM
Re: Master - slave connection 1434 Rick James 12/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.