Hi Hartmut! i will read this docs, i have some replications and multi source replications, but i don't have a setup like this :) i will test it! thanks :D !
2013/9/24 Hartmut Holzgraefe <[email protected]>: > On 09/24/2013 08:41 AM, Roberto Spadim wrote: > >> this could happen, or replication know when it do a "loop" at replication? >> i'm not sure if i'm right, but since A is master of B, and B act as a >> slave for first update, i think it will not replicate to A, i'm right? > > > that's why each participant in a replication setup needs to have a > unique server_id so that it can identify replication events that > originated from itself and ignore them. > > Also a mysql server that acts as both replication master (writing its > own binlogs) and slave (receiving binlog events from another master) > will only forward replication events received from its master to its > own binlog if log_slave_updates is enabled which is off by default. > > See also: > > https://dev.mysql.com/doc/refman/5.5/en/replication-options-binary-log.html#sysvar_log_slave_updates > > http://dev.mysql.com/doc/refman/5.5/en/replication-options.html#option_mysqld_server-id > > -- > Hartmut Holzgraefe, Principal Support Engineer (EMEA) > SkySQL | http://www.skysql.com/ > > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp -- Roberto Spadim SPAEmpresarial _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
