Configuring Replication with RDS (MySQL/MariaDB)

To synchronize data between your MySQL server and the RDS Instance, you can set up MySQL Replication. In this configuration, your MySQL server will act as the Master, and the RDS Instance will act as the Slave Read-Only. After successful configuration, any changes on your MySQL server will be synchronized to the RDS Instance via MySQL Asynchronous Replication.

Steps to configure Replication:

---

1. Create Replication User on Your MySQL Server

On your MySQL server, create a user to handle the replication:

mysql> create user 'rep'@'%' identified by 'abcd1234';
mysql> grant replication slave on *.* to 'rep'@'%';
mysql> flush privileges;

• rep is the replication user.

• abcd1234 is the password for the user.

---

2. Check the Binary Log Status on Your DB Server

MySQL requires binary logs for replication. To check if binary logs are enabled, run the following query:

mysql> show variables like "log_bin";

• If the result is OFF, you need to enable the binary log. To do so, add the following lines to the configuration file my.cnf (typically located at /etc/mysql/my.cnf):

[mysqld]
log-bin=bin.log
log-bin-index=bin-log.index
max_binlog_size=100M
binlog_format=row

Then, restart the MySQL/MariaDB service:

systemctl restart mysql

Check again with:

mysql> show variables like "log_bin";