Data migration from on-premises MySQL to RDS for MySQL

97 Views Asked by Ashly Taylor At 06 November 2018 at 17:28

Data Transmission Service can migrate data from on-premises MySQL databases to Alibaba Cloud RDS for MySQL databases without server outage.

To perform incremental data replication, the binlog must be enabled for the source database.

How can I enable binlog in RDS for MySQL on Alibaba Cloud.

I appreciate any assistance with this.

There are 2 best solutions below

wojcieh On 06 November 2018 at 19:09

As per Alibaba Cloud Data Transmission Service https://www.alibabacloud.com/help/doc-detail/26621.htm?spm=a2c63.p38356.a3.3.33ae47adUihT06 binary log must be enabled on the source MySQL database.

You can follow this procedure to enable MySQL binary log https://oguya.ch/posts/2016-01-07-enable-mysql-binlog/

Ranjith Udayakumar On 22 November 2018 at 17:07

You can enable binary log in RDS for MySQL on Alibaba Cloud by just adding log_bin parameter under [mysqld] section in your my.cnf config file.

log_bin = mysql-bin