MySQL replication positioning changes -

i using concept of mysql master master replication synchronizing data between 2 servers.

now problem exists me upon editing data in table, changes reflected @ other end. master_log_pos changes on every change whenever update or change in data done @ either end.

can me this?

thanks in advance

the question seems unclear me because behavior describing normal. when data on master changes, master should write changes binlog, whether change initiated locally or came in on replicatiom stream... log file positon advance on both machines, if log_slave_updates global variable turned on @ each master.

you turn off, shouldn't, because neither server's binlog have complete copy of changes, regardless of source, severely complicating or eliminating possibility of using either server's binlog point in time recovery.

if thinking there's loop, you're partially correct, because there is. when "a" sends event "b," "b" execute event, write binlog, , send event out , conmected slaves. when "a" receives own event "b," realizes initiator of event, , discards it. originating server breaks loop.

this way can work, since every master sends same binlog events all connected slaves. if "all" slaves doesn't make sense, recall in master/master, can subtend 1 or more read-only replica slaves each master. if both masters didn't send incoming replication events out again slaves, subtended slaves wouldn't possible.