Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re: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
AnalyticsMigration & ModernizationDatabase
Tags
Aurora MySQLAmazon Relational Database ServiceMigration & ModernizationAmazon Aurora
Language
English
asked 3 years ago401 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.

AWS
answered 2 years 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.

Relevant content