Azure MySQL Database Setup Guide

Note: You can connect Fivetran to a read replica of your Azure MySQL database to ensure that we don't add any strain to your master database. Many production environments include a read replica by default; if yours doesn't, you can create one.

Follow these instructions to replicate your Azure MySQL database to your destination via Fivetran.

Prerequisites

To connect your MySQL database to Fivetran, you need:

MySQL version 5.1.5 or above for non-RDS databases (5.5.40 is the earliest version tested). MySQL version 5.6.13 or above for RDS databases.
IP (for example, 1.2.3.4) or host (your.server.com)
Port (usually 3306)

For the prerequisites connecting via an SSH tunnel, see Fivetran's Connection Options page.

Replica ID

The replica ID is a unique ID within the MySQL replica set. It must be an integer different from all other master and replica server IDs within the same group. By default, the replica ID is a random integer greater than 1000.

Choose your connection option

First, decide whether to connect Fivetran to your Azure MySQL database directly or through an SSH tunnel. How you configure security groups will differ based on your connection method.

Connect directly

Fivetran connects directly to your database instance.

Connect via SSH

Fivetran connects to a separate server in your network that provides an SSH tunnel to your database. You must connect through SSH if your database is contained within an inaccessible subnet. If you have an SSH connection, follow these instructions before you proceed to the next step.

Allow Fivetran to access your database

You must configure your firewall to grant Fivetran access to your database.

Open the SQL database firewall settings in the Azure console

In the Azure console, select your Azure MySQL resource.
Open the Connection security tab.

Add a new firewall rule

If you are connecting directly, create a new rule using Fivetran's IP as both the Start IP and End IP. If you are connecting through SSH, use your tunnel server's IP.
Click Save.

Create a Fivetran user

Next, create a Fivetran user for your Azure MySQL database. If you are connecting Fivetran to a read replica, you must create the user on your master database because read replicas are read-only. Your read replica will inherit the user from your master database.

WARNING: This user must be reserved for Fivetran use only and must be unique to your connector. For more information, see our MySQL documentation.

Open a connection to your Azure MySQL database using your favorite SQL tool (for example MySQL Workbench or the "mysql" command in your operating system's terminal window).

Open a connection to your Azure MySQL database using your favorite SQL tool (for example, MySQL Workbench or the mysql command in your operating system's terminal window).
Create a Fivetran user and grant replication permissions by running the following SQL commands. Replace 'password' with a password of your choice.

CREATE USER fivetran@'%' IDENTIFIED WITH mysql_native_password BY 'password';
GRANT SELECT, REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO

fivetran@'%';

If there are errors when running these commands, you may lack sufficient privileges and should contact your database administrator.

Verify binary log format is set to ROW

Azure MySQL's binary log format is set to ROW by default. Verify that your binary log format is ROW. If not, set the binary log format to ROW in your Azure portal. Fivetran needs ROW format binary logs to perform incremental updates.

Select schema and tables

Select which schemas and tables you'd like to sync to your destination.

Choose a schema prefix

Fivetran maps the schemas we discover in your source database to your destination and prepends the destination schema names with a prefix of your choice. For example, if your original database contains schemas foo and bar and if you choose the prefix pre, then your destination schemas will be pre_foo and pre_bar.

Documentation