On This Page
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
Click PIPELINES in the Asset Palette.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select the MySQL variant.
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 must be configured if the Ingestion mode is Table.
To do this:
Once your respective Source connection settings are specified in Step 2 above, select the objects to be replicated in the Select the Objects you want to replicate page, and then click CONTINUE.
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.
Handling the Unsigned Data Type
While converting the data types of the ingested data prior to replication to the Destination, some values may be truncated if they exceed the allowed limit, or the Event might fail if the value mismatches with the schema. This can happen in the MySQL database with the unsigned int type since it can hold more positive values than the signed int. For example, the 8-bit unsigned int holds 256 values, from 0 to 255, while the 8-bit signed int also holds 256 values but they range from -127 to 127. Thus, the positive range of the unsigned int (0-255) will be greater than the positive range of the signed int (0-127).
Hence, to avoid data loss, Hevo automatically updates the unsigned int to a larger signed int type. For example, an 8-bit unsigned int is promoted to a 16-bit signed int as it has more space to store the value.
Refer to the following table for the list of key updates made to this page:
|Date||Release||Description of Change|
|Apr-21-2022||1.86||- Updated section, Object Settings.
- Removed section, Select the Pipeline Mode.
|Dec-06-2021||1.77||Added the section, Handling the Unsigned Data Type.|
|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.|