RDS Data Synchronization to a Local Database

Key Steps to Synchronizing Data from RDS to a Local Database

  • reset slave;####Used to reset the synchronization relationship of the local MySQL database. An error may occur during this step.
  • mysql> reset slave;
  • ERROR 1794 (HY000): Slave is not configured or failed to initialize properly. You must at least set server-id to allow either a master or a slave. Added error messages may be found in the MySQL error log.
  • The error is due to the RDS backup file including the master/slave synchronization relationship of RDS. The relationship must get removed as follows:
  • truncate table slave_relay_log_info;
  • truncate table mysql.slave_master_info;
  • truncate table mysql.slave_worker_info;
  • Restart MySQL.
  • SET @@GLOBAL.GTID_PURGED
  • =’818795a2–8aa8–11e5–95b1:1–289,8da7b8ab-8aa8–11e5–95b1:1–75′;
  • Open the compressed backup file, and you will find the xtrabackup_slave_info file. The first line indicates the GTID that the RDS used when the backup finished, and the command in the line must get executed in the local MySQLdatabase.

Related Blog Posts

Using XtraBackup for Physical Backup and Restoration

Master-Slave Data Synchronization for MySQL

Related Market Products

MySQL5.6 (Windows2008)

MySQL5.5 (CentOS7.4)

Related Documentation

Migrate RDS for MySQL data to a local MySQL database

Migrate data from on-premises MySQL to RDS for MySQL

Related Products

ApsaraDB RDS for MySQL

Data Transmission Service

Related Course

Migration of Cloud Database from Third-party Platforms to Alibaba Cloud

--

--

--

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Essentials for Load Testing with Loadium

Beginner’s Guide to Building a Rails API

What traits are looked for when moving an engineer into a software leadership role?

Flutter. GestureDetector in-depth

Flutter. GestureDetector in-depth

Rari’s Multi-sig and Security Standards

The other side of Programming

CS373 Spring 2022: Luca Santos: Final Entry

Java Stdin and Stdout II — HackerRank

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

More from Medium

Upgrade Aurora PostgreSQL with Minimal Downtime using AWS DMS

Real Time Kafka/Kinesis Event Stream Data Processing with AWS Lambda

AWS Redshift — Automated Table Design

Working with AWS SQS FIFO Queues