MySQL
This page describes how to sync data to your MySQL database.
Getting Started
This guide will walk you through connecting to MySQL as a destination.
If you are trying to use MySQL as a data source (to query data from MySQL and sync to elsewhere), that process is documented separately here: MySQL Data Source
- Visit the Destinations page and click + New Destination.
- Select MySQL from the menu.
- Enter the requested database credentials:
| Credential | Description |
|---|---|
| Hostname | Host name or IP address of database |
| Port | Port of database (3306 by default for MySQL) |
| Database Name | Name of database within MySQL to connect to |
| Username | Username Activations will use to connect |
| Password | Password Activations will use to connect |
| Number of Client Connections | Value between 1 and 8 (default is 1). This is the maximum number of concurrent connections Activations will use to connect to database. The default should be fine in most cases, but increasing this value can increase throughput on very large syncs. |
| Use SSH Tunnel | Default: Off - Toggle on to indicate that Activations should connect via an SSH Tunnel. For more information, see regions-and-ip-addresses.md |
| SSH Hostname | Hostname of the Activations accessible SSH Tunnel bastion. |
| SSH Port | Port of SSH Tunnel bastion. |
| SSH Username | Username Activations will use to connect to bastion. |
🔑 Permissions
To use MySQL as a destination, Activations requires permission to write to the desired destination tables, as well as read metadata about the table and database structures.
-- Note that creating a user may be redundant if you're already configured -- MySQL as a source. -- Create census user the ability to sign in with a password CREATE USER CENSUS IDENTIFIED BY '<strong, unique password>'; -- GRANT access to which ever schemas you'd like to give access to -- Note: this can also be granted to specific tables as well GRANT INSERT, UPDATE, SELECT ON <your schema>.* TO CENSUS; GRANT CREATE TEMPORARY TABLES ON *.* TO CENSUS
Supported Objects and Behaviors
| Object Name | Supported? | Sync Keys | Behaviors |
| Table | ✅ | Primary keys or columns with uniqueness constraints | Update or Create, Update Only |
Contact Support if you want Activations to support more sync behaviors for MySQL.
Advanced Network Configuration
Activations can successfully connect to MySQL instances that are using advanced networking controls including region constraints, IP address allow lists, or SSH Tunneling. For more information, see our Network Access Controls documentation.