Amazon Aurora MySQL

Amazon Aurora is a drop-in replacement for MySQL that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora is fully managed by Amazon Relational Database Service (RDS), which automates time-consuming administration tasks like hardware provisioning, database setup, patching, and backups.

You can ingest data from your Amazon Aurora MySQL database using Hevo Pipelines and replicate it to a Destination of your choice.


Source Considerations

  • Amazon Aurora MySQL does not support BinLog replication on read replicas. To enable BinLog ingestion mode, select a master database instance.

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 Description of Change
Apr-25-2022 NA - Added section, Source Considerations.
- Added a prerequisite for connecting to a master database if BinLog replication is required.
Apr-21-2022 1.86 Updated section, Specify Amazon Aurora 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 Aurora MySQL Connection Settings section.
Aug-09-2021 NA Added a note in Step 3 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 section, Specify Amazon Aurora MySQL Connection Settings.
Last updated on 15 Sep 2022

Tell us what went wrong