MySQL Forums
Forum List  »  Data Recovery

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.)

Options: ReplyQuote

Written By
Re: Obtaining binlog coordinates after crash recovery
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.