MySQL Data Destination

Follow
Avatar
Ruby Feinstein
Updated

Set up a MySQL data destination to export data from Singular automatically to a MySQL server.

Note: Data destinations are an enterprise feature (learn more).

 

Setup Instructions

1. Create a Database and User in MySQL

Create a new database with the following command:

CREATE DATABASE singular;

Create a new user with the following command:

CREATE USER 'singular'@'%' IDENTIFIED BY '<password>';

Grant the user the following permissions:

GRANT ALL PRIVILEGES ON singular.* TO 'singular'@'%';

Note: This allows Singular to create new tables in the provided database and schema. It does not allow Singular to read or change other schemas or tables in the database.

2. Whitelist Singular Server IPs

If you are using a firewall and only allow certain IPs to connect to your MySQL instance, you need to add Singular’s servers to the whitelisted IPs in your policy These are the IPs:

  • 54.183.135.179/32
  • 54.183.113.72/32
  • 13.52.189.144/32

3. Add a MySQL Data Destination

To add a MySQL data destination in Singular:

  1. In your Singular account, go to Settings > Data Destinations and click Add a new destination.

  2. Type in "MySQL".

  3. In the window that opens, fill in the relevant details:

    mceclip0.png

    Field Description
    Username The username and password you created in Step 1. 
    Password
    Hostname The hostname of your MySQL instance.
    Database Name The database that you granted Singular permissions to.
    Table Name Enter a name for the table that Singular will create and write to. Default: "marketing_data".