MySQL

Hevo supports the following variations of MySQL as a Source:

Click each variant above to know the prerequisites and pre-configuration setups specific to it. Once you complete the setups, follow the steps mentioned below to configure it as a Source in your Hevo Pipeline and start ingesting data.


Select the Source Type

To select MySQL as the Source:

  1. Click PIPELINES in the Asset Palette.

  2. Click + CREATE in the Pipelines List View.

  3. In the Select Source Type page, select the MySQL variant.


Select the Pipeline Mode

Select how you want Hevo to read your data from the MySQL Source. This can be BinLog, Custom SQL, or Table.

Read Pipeline Modes.

For Pipeline mode as Table, refer to Object Settings below to configure the objects to be replicated.


Specify MySQL Connection Settings

In the Configure your MySQL Source page, specify the connection settings for your MySQL Source.

Read the documents in this section to know the detailed configuration steps for each MySQL variant.


Object Settings

Object settings must be configured if the Pipeline mode is Table. To do this:

  • In the SELECT OBJECTS YOU WANT TO REPLICATE page, select the objects to be replicated.

    Note: Each object represents a table in your database.

  • In the CONFIGURE SOURCE OBJECTS page, specify the query mode to be used for each selected object.


See Also



Revision History

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

Date Release Description of Change
Jul-12-2021 1.67 - Added the field Include new tables in the Pipeline under Source configuration settings.
- Moved the steps for configuring the Source from the Specify MySQL Connection Settings section to the respective MySQL variant document.
Mar-09-2021 1.58 Updated section Select the Pipeline Mode to include Change Tracking as a Pipeline mode.
Last updated on 07 Sep 2021