maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

Hi Colin, hi guys! =)
other doubt, but not a "cluster" doubt, now a replication doubt...

check if this is possible, or i'm getting crazy =)

two mariadb servers (last version ~10.0.5): A and B
A have the same tables of B
B have the same tables of A
they are both empty

when i write at A it replicate to B
when i write at B it replicate to A

if i have a solution at client site (application) that allow write to
A only using a primary key starting with "A" and writes at B a primary
key starting with "B", in other words..

writing at A: using WHERE pk_field="A"
writing at B: using WHERE pk_field="B"

could this replicate A to B, and B to A?
for example, does this get in a "infinite loop", like:

A: UPDATE table SET f=1 WHERE pk_field="a"
A replicate to ->B: UPDATE table SET f=1 WHERE pk_field="a"
B replicate to ->A: UPDATE table SET f=1 WHERE pk_field="a"
A replicate to ->B: UPDATE table SET f=1 WHERE pk_field="a"
endless loop replicating from A->B, B->A, A->B, B->A, etc...

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?

thanks!