Skip to main content

Replication

MySQL Replication Tutorial - YouTube

MySQL Replication course from zero to hero | MySQL DBA | Udemy

Replicating - Amazon Relational Database Service

Replicating - Amazon Relational Database Service

show slave status;

stop slave;

-- Slave_IO_Running: Yes
-- Slave_SQL_Running: Yes
-- Seconds_Behind_Master: 0

change master to
    MASTER_HOST='<>'
    MASTER_USER='<>'
    MASTER_PASSWORD='<>'
    MASTER_LOG_FILE='<>'
    MASTER_LOG_POS='<>'
    FOR CHANNEL '<channel_name>';

Reverse Replication​

Configure reverse replication using AWS DMS to migrate an Oracle database to Amazon RDS for Oracle | AWS Database Blog

How Binary Logs (and Filesystems) Affect MySQL Performance

mysql - How to disable binlog_format in AWS RDS? - Database Administrators Stack Exchange

Configuring MySQL binary logging - Amazon Relational Database Service

  • You can turn off binary logging by setting the backup retention period of a DB instance to zero, but this disables daily automated backups. Disabling automated backups turns off or disables the log_bin session variable. This disables binary logging on the RDS for MySQL DB instance, which in turn resets the binlog_format session variable to the default value of ROW in the database. We recommend that you don't disable backups.