MySQL Forums
Forum List  »  Replication

Ask about Table Replication
Posted by: Carlos Botejara
Date: January 06, 2020 07:29PM

I have 2 MySQL servers, configured as Master-Slave, replicating through GTID.
Replication works fine.
Now, each server is in a different place, and I use a user authentication software (RADIUS) in each place.
Users are loaded into the MASTER SERVER, and it is replicated in the Slave without problems.
The software performs a task, every 5 or 10 minutes of accountig, and this is where the problem arises.
I need the SLAVE to update the MASTER Accounting table.
The MASTER updates the Accounting table in the Slave, but with the data of the users who authenticate in it, but I also need the data of the users who authenticate on the SLAVE server in the MASTER.
How can I synchronize only the Accounting table bidirectionally?

Options: ReplyQuote

Written By
Ask about Table Replication
January 06, 2020 07:29PM
January 07, 2020 10:12AM

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.