MySQL Forums
Forum List  »  Replication

replicate_rewrite_db not saved
Posted by: Jan de Bokx
Date: March 06, 2020 04:35AM

Hello all,

We use replication in a 1 slave, many masters setup.
The masters are replicating 1 table to the slave.

Because the name for masters and slave are not the same, we use:

change replication filter replicate_rewrite_db = ((dbMaster, dbSlave)) for channel 'masterSlave<number>';
change replication filter replicate_do_db = (dbSlave) for channel 'masterSlave<number>';

So we create a channel for every master.
But when de slave is rebooted, these settings are gone in the 'show slave status' command.

So now we made a script running at startup with above commands for every master.
But now at designtime we do not know how many masters are used.
So we must adapt the startupscript is the number of masters is changed!

Also when in the startupscript an inactive master is called, the script stops and the replication is not started!

Is there a better solution for this problem?

Kind regards,

Jan

Options: ReplyQuote


Subject
Views
Written By
Posted
replicate_rewrite_db not saved
220
March 06, 2020 04:35AM
100
April 23, 2020 08:09AM


Sorry, only registered users may post in this forum.

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.