Generic MySQL

Last updated on Dec 19, 2022

MySQL is the most popular Open Source Relational SQL Database Management System used by small and large businesses. It has a customizable software and works well even with large data sets.

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

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
Dec-19-2022 2.04 Updated section, Specify MySQL Connection Settings to add information that you must specify all fields to create a Pipeline.
Dec-07-2022 2.03 Updated section, Specify MySQL Connection Settings to mention about including skipped objects post-Pipeline creation.
Dec-07-2022 2.03 Updated section, Specify MySQL Connection Settings to mention about the connectivity checker.
Oct-13-2022 1.99 Updated section, Specify MySQL Connection Settings to reflect the latest UI changes.
Apr-21-2022 1.86 Updated section, Specify MySQL Connection Settings.
Aug-09-2021 NA Added a note in Step 3 of section, Enable BinLog replication.
Jul-26-2021 1.68 Added a note for the Database Host field.
Jul-12-2021 1.67 Added sections:
- Specify MySQL Connection Settings and
- Connecting to a Local Database.

Tell us what went wrong