By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Aurora Mysql incremental backup export

0

I observe that Aurora Mysql cluster data and cluster snapshot data can be exported to S3 in Apache Parquet format as described in https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/export-cluster-data.html and https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-export-snapshot.html. However, I am wondering whether there is a way to export incremental backup data in a similar fashion. My objective is to export an Aurora Mysql cluster to a local/on-prem server and keep it refreshed daily using incremental backup. Please let me know your comments/thoughts. Thanks!

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Migration & ModernizationAmazon Relational Database ServiceAmazon AuroraAurora MySQL
Language
English
rePost-User-5453660
asked 2 years ago180 views
1 Answer
0

The best way would be to use MySQL binary logging with the Aurora MySQL cluster as your source and your local/on-prem server as a target. We describe how to set up binlog replication and GTID-based replication in our documentation.

profile pictureAWS
Victor_W
answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content