MySQL Forums
Forum List  »  Replication

Re: Newby resetting replication query
Posted by: ian diddams
Date: June 19, 2019 01:24AM

Peter Brawley Wrote:
-------------------------------------------------------

> You write as if we all know what "DR" is. I've not
> a clue.

In my very first post in this thread, to which you replied, I explained the following

"I have a LIVE DB in a database "bugtracker". that mariadb instance also has these databases

information_schema mysql performance_schema test

I have a DR DB in a database "bugtracker". that mariadb instance also has these databases

information_schema mysql performance_schema

Replication is set up for bugtracker. "


So - to reiterate.

Live and DR DBs "bugtracker", DR in replication.

Break replication.

Use DR as temp live, and bugtracker is used/changed/added to etc.

Then to return to live+DR +repl:

dump bugtracker DB on DR.
Import dump to live bugtracker

At this juncture both live and DR have the same bugtracker.

Why would I now need to dump live to import on DR? Live has what DR has surely?

Ian

Options: ReplyQuote


Subject
Views
Written By
Posted
1363
June 13, 2019 08:45AM
Re: Newby resetting replication query
370
June 19, 2019 01: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.