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

Selectable Label on Xamarin.Forms

Proof Engineering: FIX Gateways

THM Linux Fundamentals PT 1

How to perform Morphological Operations like Erosion, Dilation, and Gradient in Python using OpenCV

How to Quickly Implement Nginx-based Website Monitoring

Save to .pdf your jupyter notebook

Switchover in MySQL Replication(Master-Slave) Setup

Blazor WebAssembly I18n from Start to Finish

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

AWS S3 Same Region Replication (SRR)

AWS S3 — Same Region Replication diagram

Apache Beam ParDo Transformations

Cassandra Monitoring Setup Using Open Source Tools

VPC — Virtual Private Cloud