Re: Newby resetting replication query
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
Subject
Views
Written By
Posted
1457
June 13, 2019 08:45AM
281
June 13, 2019 01:04PM
317
June 17, 2019 01:25AM
270
June 17, 2019 08:13AM
316
June 17, 2019 08:35AM
311
June 18, 2019 09:55AM
Re: Newby resetting replication query
430
June 19, 2019 01:24AM
292
June 19, 2019 06: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.