MySQL Setup

Mike Jones
Mike Jones
  • Updated

The MySQL Synapse enables data synchronization between MySQL schema and Syncari entities. After the Synapse is authenticated, a user can activate the MySQL Synapse, which enables Syncari to replicate the schema of MySQL and make it available within the Unified Data Model. Using Sync Studio, a user can map MySQL tables to Syncari entities, and MySQL fields to Syncari fields.

If your MySQL security requires you to whitelist an IP you can find that here.


MySQL Information

You will need the following information from your MySQL administrator:

  • Host Address
  • Database Name
  • User
  • Password

Recommended process for creating a new database for use with Syncari

If you plan on connecting the synapse to a newly created database, our recommended process is to do the following:

Create a new dedicated Syncari sync user

CREATE USER 'newuser'@'host' IDENTIFIED BY 'password';

Create a new database

CREATE DATABASE databasename;

Grant permissions to the newly created user on the new database

GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'host';


Synapse Setup

Step 1: Start by logging in to your Syncari subscription

  1. Navigate to Synapses
  2. Find MySQL in the Synapse Library
  3. Drag the MySQL Synapse to the canvas



Step 2: Configure your Synapse parameters

  1. Enter [Synapse Name]
    This will be the label name for the Synapse in Syncari
  2. Enter [Host]
  3. Enter [Database Name]
  4. Click "Next"

    [OPTIONAL] Instantiate with Syncari entities - Enables Syncari to automatically create entities in MySQL

    The "Instantiate with Syncari entities" option enables all the existing entities in Syncari to be created as tables in MySQL. This feature is useful if you want the schema from the Syncari Unified Data Model to be replicated in MySQL. 

    Talk to one of our Onboarding and Support Team members if you would like any clarification or a recommendation.



Step 3: Define your authentication parameters and authenticate:

  1. Enter [User Name]
  2. Enter [Password]
  3. Click "Save and Authenticate"
  4. Click "Next"
    [OPTIONAL] Use SSL Connection - Select this option if the connection to your server requires SSL. 



Step 4: Activate your Synapse

  1. Click "Make Synapse Active"
  2. Click "Close"


Congratulations! You have completed the setup of MySQL.

If you receive any errors message after clicking Authenticate, confirm each of the parameters in the previous steps are configured properly. If the error persists, contact one of our Onboarding and Support team members.


What's Next?

Share this

Was this article helpful?

0 out of 0 found this helpful