Restore Aurora DB using BIn-log position

0

A customer is considering migrating their DB to Aurora, one of their requirements is to be able to restore the DB to an earlier state based on Bin-log position, meaning to restore the DB to a prior state based on what function were ran last.

so basically very similar to "backtrack" but based on functions that ran and not point in time.

AWS
질문됨 6년 전718회 조회
1개 답변
0
수락된 답변

Ok, it's an interesting concept but not without risk, there's questions about consistency if they start cherry-picking what changes out of the binlogs to apply.

To clarify Aurora capabilities:

  1. you cannot access the actual binlog files
  2. you can attach as a replication slave and request binlog records from a given position. The slave can be another Aurora or MySQL instance/cluster replaying the logs, DMS, binlog proxy (eg. MaxScale) or some other type of binlog parser
  3. Aurora does not support filtered replication

Since we're talking about DR strategy, they should ship the binlogs off the Aurora cluster anyway for this particular use case, so #2 above comes into play. Once they have them externally to the Aurora cluster on a proxy or something they can process/analyze them as needed, but it would be a manual process.

They would need to test it out. I don't know of any customers that do that today, so it's hard to say whether they will encounter other gotcha's or not.

AWS
전문가
답변함 6년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠