Prerequisites

Before using Microsoft Azure Database for MySQL as an endpoint in a Qlik Replicate task, make sure that the prerequisites outlined below have been met.

Driver setup

Installing the driver on Windows

Install MySQL ODBC Unicode Driver 64-bit version 8.0.32 on the Replicate machine.

Installing the driver on Linux

1. Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.

2. Install MySQL ODBC Unicode Driver 64-bit version 8.0.32 on the Replicate machine.

3. Change the working directory to <Replicate-Install-Dir>/bin.

4. Copy the driver location to the site_arep_login.sh file:

   echo "export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/usr/lib64" >> site_arep_login.sh

   This will add the driver to "LD_LIBRARY_PATH" and update the driver location in the site_arep_login.sh file.

5. Optionally, confirm that the driver location was copied:

   cat site_arep_login.sh

6. Make sure that the /etc/odbcinst.ini file contains an entry for MySQL, as in the following example:

   [MySQL ODBC 8.0 Unicode Driver]

   Driver = /usr/lib64/libmyodbc8w.so

   UsageCount = 1

7. Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures.

General prerequisites

Make sure that the following prerequisites have been met:

• A Microsoft Azure Database for MySQL account with the required Security requirements.

• A Microsoft Azure Database for MySQL database with the tables that you want to replicate should be accessible in your network.

  The following Microsoft Azure Database for MySQL editions are supported:

  • Microsoft Azure Database for MySQL Community Edition
  • Microsoft Azure Database for MySQL Standard Edition
  • Microsoft Azure Database for MySQL Enterprise Edition
  • Microsoft Azure Database for MySQL Cluster Carrier Grade Edition
• In order to work with Microsoft Azure Database for MySQL 8 as a target endpoint, you need to:
  • Set the parameter secure_file_priv = NULL in the Microsoft Azure Database for MySQL database.
  • If you are using LOB columns, set the parameter sort_buffer_size = 128M in the Microsoft Azure Database for MySQL database.

Replicating 4-byte UTF8 emojis

To support replication of 4-byte UTF8 emojis, the target schema character set must be set to utf8mb4.