Linkedin

  • Home >
  • Set up data replication between Amazon RDS for MySQL and MySQL on Amazon EC2 using GTID

Set up data replication between Amazon RDS for MySQL and MySQL on Amazon EC2 using GTID

Project Overview

Project Detail

This pattern describes how to set up data replication on the Amazon Web Services (AWS) Cloud between an Amazon Relational Database Service (Amazon RDS) for MySQL DB instance and a MySQL database on an Amazon Elastic Compute Cloud (Amazon EC2) instance by using MySQL native global transaction identifier (GTID) replication.

With GTIDs, transactions are identified and tracked when they are committed on the originating server and applied by replicas. You don’t need to refer to log files when starting a new replica during failover.

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/set-up-data-replication-between-amazon-rds-for-mysql-and-mysql-on-amazon-ec2-using-gtid.html?did=pg_card&trk=pg_card

To know more about this project connect with us

Set up data replication between Amazon RDS for MySQL and MySQL on Amazon EC2 using GTID