Skip to main content

MySQL Amazon RDS Setup

Here is everything you need to do before creating a MySQL resource and using Amazon RDS.

Security Groups#

To allow access to your MySQL database from Meroxa IPs, follow these steps:

  1. Navigate to Amazon RDS.
  2. Select the Database you would like to add to Meroxa.
  3. In the "Connectivity & security" section, select your Security Group:

  1. In the Security Group forconfiguration, select "Edit inbound rules":

  1. Add a new Rule:
  • Set "Protocol" to TCP
  • Set "Port" to the port of your database. It is 5432 by default.
  • Set the "Source" to the Meroxa IPs:

Network ACLs#

You only need to update this if your database is within a VPC.

To allow access to your MySQL database from Meroxa IPs, follow these steps:

  1. Navigate to Amazon RDS.
  2. Select the Database you would like to create a replica of.
  3. In the "Connectivity & security" section, select your VPC:

  1. In the VPC Settings, select your VPC's "Main Network ACL":

  1. Update the Inbound and Outbound Rule of the Network ACL
  • 5a. If your inbound and outbound rules contain, ALL - 0.0.0.0/0 - ALLOW, you can move to #6.
  • 5b. If your inbound and outbound rules does not contain, ALL - 0.0.0.0/0 - ALLOW, update the Source to allow Meroxa IPs both inbound and outbound.

Enable Binary Log#

note

Backups must be enabled for Binary Loging to be enabled in RDS.

Within your DB parameter groups, you must have the following key/values set:

  • binlog_format - ROW
  • binlog_row_image - FULL

To enable Binary Log to your RDS instance, follow these steps:

  1. Note: These instructions do require a reboot of the RDS instance.
  2. Navigate to Amazon RDS.
  3. Select "Parameter groups", and "Create parameter group".

  1. Create a new parameter group for MySQL.

  2. Set the following:

    • binlog_format - ROW
    • binlog_row_image - FULL
  3. Save the new parameter group.

  4. Navigate to Amazon RDS

  5. Select your Database and select "Modify".

  6. Modify the "DB parameter group" to your newly created group.

  7. After reboot, your MySQL instance has Binary Log enabled.

  8. You are now ready to add your MySQL resource to Meroxa.