how to... reset replication when only one schema stuffed
OS: centos 7
Mysql: 5.7.36
Slave-Master replication set up on two servers, a master and a slave.
We currently replicate "everything" - 39 schemas in total.
Quite often we notice that when replication breaks (for whatever reason) whilst we can usually fix it via the stop slave, skip 1, start slave style command sometimes for reasons aligned with devs changing collation character sets (zzzz) or similar this doesn't work and we have to reset replication from scratch - which takes several hours for a full dump on master and then import on live etc etc etc.
However we do notice that when this oddity occurs its only one schema that is actually affected ie has errors.
So instead of dumping all databases and copying them and importing them and resetting slaving configurations based on ,master status vat the time of the dump and so on...
is there a way to dump and import just the ONE schema and resetting whatever the master status info should be ?
Or is it really just as simple as a dump and import of the one schema and replication will just carry on regardless?
cheers
ian
Subject
Views
Written By
Posted
how to... reset replication when only one schema stuffed
630
February 25, 2022 09:16AM
290
February 25, 2022 10:35AM
341
February 26, 2022 07:08AM
325
February 26, 2022 11:23AM
328
February 28, 2022 02:24AM
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.