Search documentation...

K
ChangelogBook a demoSign up

MariaDB

Power internal tools, in-app experiences, and more

View MariaDB's documentation.

Overview

This destination combines the analytical power of your data warehouse with the low-latency performance of a transactional database.

Supported syncing

Sync TypeDescriptionSupported Sync Modes
TableSync data from any source to a MariaDB tableUpsert

For more information about sync modes, refer to the sync modes docs.

Connect to MariaDB

Go to the Destinations overview page and click the Add destination button. Select MariaDB and click Continue.

Enter the following required fields into Hightouch:

  • Host: The hostname or IP address of your MariaDB.
  • Port: The port number of your MariaDB. The default is 3306, but yours may be different.
  • Database: The name of the database in your MariaDB.
  • User: This can be your personal MariaDB login or a dedicated user for Hightouch.
  • Password: The password for the user specified above.

You can optionally create or select a previously configured tunnel or upload a .pem CA certificate.

SSH tunneling

Hightouch can connect directly to MariaDB over the public internet or via an SSH tunnel. Since data is encrypted in transit via TLS, a direct connection is suitable for most use cases. You may need to set up a tunnel if your MariaDB instance is on a private network or virtual private cloud (VPC).

Hightouch supports both standard and reverse SSH tunnels. To learn more about SSH tunneling, refer to Hightouch's tunneling documentation.

Sync configuration

Once you've set up your MariaDB destination and have a model to pull data from, you can set up your sync configuration to begin syncing data. Go to the Syncs overview page and click the Add sync button to begin. Then, select the relevant model and the MariaDB destination you want to sync to.

Select table

Select the existing table in MariaDB you want to sync to.

Record matching

You can match rows from your model to rows in MariaDB on any column as long as it is a primary key or unique key.

Field mapping

Select which model columns you want to sync to your MariaDB table columns. Hightouch automatically pulls the columns from your table to make them available for you to map.

When syncing to binary destination fields, Hightouch assumes the model column values to be base64 strings. If they aren't, you can use template mapping to cast them if needed.

Base 64 template mapping

Upsert query optimization

You can choose to use the LOAD DATA statement in the upsert query during your sync. This option loads data from a text file into your database, which can be up to twenty times faster than the default INSERT INTO query Hightouch uses.

If you enable the LOAD DATA option, Hightouch replaces databases rows with the mapped model row, if it exists. This means that if any MariaDB fields aren't mapped in Hightouch they receive NULL values.

For Hightouch to successfully sync with the LOAD DATA option, you need to enable the local_infile system variable.

Review the security considerations before enabling local_infile.

Delete behavior

When rows no longer shows up from your model's query results, you can configure the sync to Do nothing or Delete those rows from the MariaDB.

BehaviorDescription
Do nothingKeep the synced rows in the table in MariaDB
DeleteDelete the synced rows from the table in MariaDB

Tips and troubleshooting

Common errors

To date, our customers haven't experienced any errors while using this destination. If you run into any issues, please don't hesitate to . We're here to help.

Live debugger

Hightouch provides complete visibility into the API calls made during each of your sync runs. We recommend reading our article on debugging tips and tricks to learn more.

Sync alerts

Hightouch can alert you of sync issues via Slack, PagerDuty, SMS, or email. For details, please visit our article on alerting.

Ready to get started?

Jump right in or a book a demo. Your first destination is always free.

Book a demoSign upBook a demo

Need help?

Our team is relentlessly focused on your success. Don't hesitate to reach out!

Feature requests?

We'd love to hear your suggestions for integrations and other features.

Last updated: Nov 17, 2023

On this page

OverviewSupported syncingConnect to MariaDBSSH tunnelingSync configurationSelect tableRecord matchingField mappingUpsert query optimizationDelete behaviorTips and troubleshootingCommon errorsLive debuggerSync alerts

Was this page helpful?