Replicated mysql servers with RT

RT Users
1

Hi,
Does anyone have any major gotchas or recommended tweaks when using RT3
with a replicated mysql server?

Thanks
John

2

ext John Green (j.green@ukerna.ac.uk) wrote:

Hi,
Does anyone have any major gotchas or recommended tweaks when using RT3
with a replicated mysql server?

Can mysql do “multi-master” replication? What if you change status on a
ticket on server A and then server B replicates to server A? I think
that mysql contains simple replication, and that it can not handle
advanced replication scenarios.

mike

3

At 04:25 PM 5/22/2003 +0300, Mike Jackson wrote:

Can mysql do “multi-master” replication?

Yes.

What if you change status on a
ticket on server A and then server B replicates to server A? I think
that mysql contains simple replication, and that it can not handle
advanced replication scenarios.

The replication thread reads a log file on the other server. B won’t
overwrite A unless B was updated. Now, if two people update the same
ticket at the same time on A and B, there might be problems. I would
definitely do a little testing.

– Jeff