Amazon RDS MySQL

Amazon Relational Database Service (RDS) allows you to deploy scalable MySQL servers in minutes with cost-efficient and resizable hardware capacity.

You can ingest data from your Amazon RDS MySQL database using Hevo Pipelines and replicate it to a Destination of your choice. Hevo recommends connecting to a read-replica of your master MySQL database, however, this is not mandatory. A read-replica reflects the changes to your master database in near real-time, and can reduce the load on the master database by serving all “read” requests. The Role attribute of the instance identifies its type.


Limitations

  • Hevo only fetches tables from the MySQL database. It does not fetch other entities such as functions, stored procedures, views, and triggers.

    To fetch views, you can create individual Pipelines in Custom SQL mode. However, some limitations may arise based on the type of data synchronization, the query mode, or the number of Events. Contact Hevo Support for more details.


See Also


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release No. Description of Change
Oct-13-2022 1.99 Updated section, Specify Amazon RDS MySQL Connection Settings to reflect the latest UI changes.
Aug-24-2022 NA Updated sections, Create a Read Replica (Optional) and Set up MySQL Binary Logs for Replication to reflect the latest UI changes.
Apr-21-2022 1.86 Updated section, Specify Amazon RDS MySQL Connection Settings.
Feb-07-2022 1.81 Updated section, Whitelist Hevo’s IP Address to remove details about Outbound rules as they are not required.
Jan-03-2022 1.79 Updated the description of the Include New Tables in the Pipeline advance setting in the Specify Amazon RDS MySQL Connection Settings section.
Aug-23-2021 1.70 Added the section, Enable Automatic Backups.
Aug-09-2021 NA Added a note in Step 2 of section, Create a Database User and Grant Privileges section.
Jul-26-2021 1.68 Added a note for the Database Host field.
Jul-12-2021 NA Added the section, Specify Amazon RDS MySQL Connection Settings.
Last updated on 10 Nov 2022

Tell us what went wrong