Search documentation...

K

MySQL

Power internal tools, in-app experiences, and more

Setup

To create mysql destination, fill host, port and other information that hightouch needs in order to connect to your MySQL database.

Create sync

Once you created your model, you can start creating a sync to sync data.

Select the table you want to sync data:

Select the ID mapping between your source data and column in MySQL:

Note: the ID you choose on MySQL mapping(right side) must be a PRIMARY KEY or UNIQUE column in order for hightouch to associate data from source to destination properly.

Select fields from source and destination column that you want to sync to MySQL:

Using "LOAD DATA"

You will have the option to use the LOAD DATA statement in the upsert query during your sync. This statement loads data from a text file into your database, which can be 20x faster than the default query we are using, INSERT INTO. However, Hightouch will replace the row in the database if it already exists when using LOAD DATA. This means that if any database fields are not mapped in Hightouch, they will be nulled since MySQL will replace that found row with just the mapped record from Hightouch. Checkout the MySQL documentation on LOAD DATA.

Hightouch will create the file of the queried rows to upsert during the sync. However, in order for Hightouch to successfully sync with LOAD DATA, you need to enable the local_infile system variable.

Please make sure you review the security considerations for enabling local_infile. Learn more here

    Need help?

    Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.

    • Connection issues with your data warehouse?
    • Confusing API responses from destination systems?
    • Unsupported destination objects or modes?
    • Help with complex SQL queries?

    Feature Requests?

    If you see something that's missing from our app, let us know and we'll work with you to build it!

    We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.

On this page

SetupCreate syncUsing "LOAD DATA"

Was this page helpful?