MySQL Forums
Forum List  »  Replication

Re: Slave not updating(no error, log position same as master)
Posted by: Rick James
Date: December 21, 2015 07:12PM

A Master needs a binlog for sending stuff to a Slave's relaylog.

A Master will not have a relaylog unless it is also a Slave.

A Slave _may_ have a binlog if either
* That Slave is Master to some more down-stream Slaves, and/or
* You want the binlog for certain forms of backup.

Note that two servers, each being both a Master and a Slave to each other is often called "dual-master" or "circular replication".

On another topic...
Since binlogs and relaylogs on various machines are cycled independently, their "Pos" values are rarely the same.

Options: ReplyQuote




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.