MySQL
Write data to a MySQL table using INSERT ON DUPLICATE KEY UPDATE for upsert. Use SignalSmith to materialize model results or enriched data into MySQL.
Prerequisites
- A MySQL database (version 5.7+)
- A database user with INSERT, UPDATE, DELETE, and CREATE TABLE privileges
- Network connectivity between SignalSmith and the MySQL server
Authentication
MySQL uses Username & Password authentication.
- Enter the database Username and Password in SignalSmith
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
| Host | Text | Yes | MySQL server hostname or IP address |
| Port | Number | No | Server port. Default: 3306 |
| Database | Text | Yes | Database name |
| Enable TLS | Toggle | No | Enable TLS encryption. Default: Off |
Target Settings
| Field | Type | Required | Description |
|---|---|---|---|
| Table | Text | Yes | Target table name |
Supported Operations
Sync Modes: Upsert, Insert, Update, Mirror
Audience Sync Modes: Add, Remove, Mirror, Upsert
Features
- Field Mapping: Yes
- Schema Introspection: Yes — SignalSmith reads column metadata from MySQL’s information_schema
Troubleshooting
Connection refused
Verify the host, port, and that the MySQL server allows remote connections. Check the bind-address setting in the MySQL configuration.
Access denied
Verify the username and password. Ensure the user has the required privileges on the target database.
Table does not exist
SignalSmith creates the target table automatically on the first sync. Ensure the user has CREATE TABLE privileges.
TLS connection issues
If the server requires TLS, enable the Enable TLS toggle. Some cloud-hosted MySQL instances require TLS for all connections.