replicate_rewrite_db not saved
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
Subject
Views
Written By
Posted
replicate_rewrite_db not saved
532
March 06, 2020 04:35AM
252
April 23, 2020 08:09AM
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.