MariaDB MySQL

Last updated on Mar 05, 2024

MariaDB is is a community-developed, commercially supported fork of the MySQL RDBMS, with the same database structure and indexes as MySQL.

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


Source Considerations

  • MySQL does not generate log entries for cascading deletes. So, Hevo cannot capture these deletes for log-based Pipelines.

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
Mar-05-2024 2.21 Added the Data Replication section.
Nov-03-2023 NA Added section, Object and Query Mode Settings.
Oct-27-2023 NA - Added subsection, Create a database user.
- Updated subsection, Grant privileges to the user with the latest steps.
Jul-25-2023 NA Updated section, Enable BinLog replication for more clarity.
Jun-26-2023 NA Added section, Source Considerations.
Apr-21-2023 NA Updated section, Specify MariaDB Connection Settings to add a note to inform users that all loaded Events are billable for Custom SQL mode-based Pipelines.
Mar-09-2023 2.09 Updated section, Specify MariaDB Connection Settings to mention about SEE MORE in the Select an Ingestion Mode section.
Dec-19-2022 2.04 Updated section, Specify MariaDB Connection Settings to add information that you must specify all fields to create a Pipeline.
Dec-07-2022 2.03 Updated section, Specify MariaDB Connection Settings to mention about including skipped objects post-Pipeline creation.
Dec-07-2022 2.03 Updated section, Specify MariaDB Connection Settings to mention about the connectivity checker.
Oct-13-2022 1.99 Updated section, Specify MariaDB Connection Settings to reflect the latest UI changes.
Jun-15-2022 NA Updated section, Specify MariaDB Connection Settings to remove information about connecting using SSL.
Apr-21-2022 1.86 Updated section, Specify MariaDB 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 NA Added section, Specify MariaDB Connection Settings.

Tell us what went wrong