MySQL Forums
Forum List  »  Replication

Re: how to... reset replication when only one schema stuffed
Posted by: ian diddams
Date: February 26, 2022 07:08AM

> Replication has to start with an exact copy. If you know a way to guarantee
> that short of dump & restore, what is that method?

well thats the question.

out of a few dozen schemas all but one are fine ie are synced as expected.

so the standard approach is a huge job of dumping and importing everythiing.

IM asking if there is any way to update a broken single schema without doing everything, given everything else IS an exact copy presumably via replication already.

If the answer is "Wno" then fair enough - but it seems stupid to spend hours doing that when POSSIBLY there is a single schema update type solution avaiolable - jence asking.

> I think your best bet is to fix the problems that cause replication to fail
> on that db.

I agree. That isnt however in my remit and nobody "north" of kme seems overly bothered that others dont seem bothered to stop breaking the %^&*£(^ thing.

I just want an easy life, and am seeking an easier life IF its available.

Basically Im bored of it.

Options: ReplyQuote

Written By
Re: how to... reset replication when only one schema stuffed
February 26, 2022 07:08AM

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.