Phase 1 - AWS Environment Setup

Phase 1 - AWS Environment Setup AWS Environment: A new VPC was created, followed by an EC2 instance and an RDS MySQL instance. A custom DB parameter group was configured for the RDS instance, enabling gtid_mode=ON, enforce_gtid_consistency=ON, and binlog_format=ROW to support replication. [00:00] Creating the AWS VPC: Starting the AWS environment setup by creating a new Virtual Private Cloud (VPC) named "MySQL project" and configuring its subnets. [01:37] Launching the EC2 Instance: Creating an EC2 instance named "MySQL AWS", generating a new key pair ("project gg") for secure access, and setting up the network with a new Security Group ("EC2 SG"). [03:40] Configuring the MySQL RDS Instance: Initiating the setup for a MySQL RDS database, creating the master username and password, allocating storage, and assigning the instance to the previously created VPC and a new subnet group. [05:28] Required DB Parameter Group: Pausing the RDS creation process to highlight a crucial prerequisite: creating and verifying a custom DB parameter group needed for Golden Gate replication (ensuring binlog_format is set to row, and GTID parameters are turned on). [06:42] Finalizing the Database Creation: Returning to the RDS setup screen to attach the custom DB parameter group to the instance and finalizing the database creation. #oracle #oraclegoldengate #goldengate #ogg #oci #oraclecloudinfrastructure #aws #mysql #mysqlheatwave #heatwave #rds #ec2 #vpc #vcn #vpn #sitetositevpn #vgw #drg #cgw #cpe #nsg #securitygroups #databaseadministrator #dba #databaseadministration #databaseadmin #replication #realtimesync #realtimereplication #cdc #initialload #extract #replicat #trailfile #gtid #binlog #databasemovement #datamigration #cloudmigration #crosscloud #multicloud #zerodowntime