Re: Obtaining binlog coordinates after crash recovery
Posted by:
Rob Wagner
Date: February 03, 2021 12:00PM
I saw that page. The trouble with that page is there isn't a way to know the *coordinates* in step 1. In that example, it's using a wallclock time. But on a busy server, wallclock time does not tell you precisely where to start your PIT recovery from. You really need to use --start-position, not --start-datetime, and there doesn't seem to be a way to determine --start-position from version 8.0+.
(yes, I know you can do flush tables with read lock followed by show master status, but that isn't viable on busy databases.)
Subject
Views
Written By
Posted
908
February 03, 2021 07:54AM
313
February 03, 2021 11:41AM
Re: Obtaining binlog coordinates after crash recovery
375
February 03, 2021 12:00PM
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.