MySQL Forums
Forum List  »  Replication

Re: MySQL 5.6.26 is mysql.slave_relay_log_info replicated in chain/circular topology?
Posted by: Rick James
Date: February 21, 2016 11:07PM

There is only one kind of connection - Master to Slave. All other topologies are just combinations of that one.

For example, a 3-Master "circular replication" (which is a terrible topology to try to maintain) of M1, M2, and M3 has
M1 as a master replicating to M2 acting as a slave, and
M2 as a master replicating to M3 acting as a slave, and
M3 as a master replicating to M1 acting as a slave.

M -> R -> S -- Master to Relay to Slave -- The Relay is acting both as a Slave and as a Master.

M1 <-> M2 -- "Dual Master"

S1 <- M1 <-> M2 -> S2 -- Dual Master, each with a Slave. (This is perhaps the best HA topology for 'traditional' replication.)

A Master writes to its binlog and simultaneously writes across the network to its Slave(s).

A Slave receives data from its one Master and writes to its "relay log" (think of it as a incoming buffer; ignore the words 'relay' and 'log'). It then performs what is in that log.

All the binlogs and relay logs everywhere in the topology are acting independently -- at least in the sense of position, flushing, cycling log files, etc.

As for the Monitor "changing" things -- is it actually changing it on the system, or simply presenting the info in a more easily digestible for to the user?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.6.26 is mysql.slave_relay_log_info replicated in chain/circular topology?
782
February 21, 2016 11:07PM


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.