Skip to main content
This step-by-step guide shows you how to configure Azure Flexible Server for MySQL to replicate data into ClickHouse Cloud using the MySQL ClickPipe. Only one-time ingestion is supported for this service. For common questions around MySQL CDC, see the MySQL FAQs page.
Continuous ingestion via CDC isn’t supported for this service. Azure Flexible Server for MySQL doesn’t allow configuring the binlog_row_metadata system variable to FULL, which is required for full-featured MySQL CDC in ClickPipes.Please submit a feature request in the Azure feedback forum, upvote this question, or contact Azure support to request this capability.

​
Configure a database user

Connect to your Azure Flexible Server for MySQL instance as an admin user and execute the following commands:
  1. Create a dedicated user for ClickPipes:
  2. Grant schema permissions. The following example shows permissions for the mysql database. Repeat these commands for each database and host you want to replicate:
  3. Apply the permission changes:

​
Configure network access

ClickPipes doesn’t support Azure Private Link yet. To reach an instance that doesn’t allow public access, use an SSH tunnel. For more information, see ClickPipes networking.
Next, you must allow connections to your Azure Flexible Server for MySQL instance from ClickPipes.
  1. In the Azure Portal, navigate to All resources. Select your Azure Flexible Server for MySQL instance to open the Overview page.
  2. Under Settings, select Networking. Ensure Public access is enabled.
  3. In the Firewall rules section, enter the list of ClickPipes static IP addresses for the region your service is deployed in.
  4. Click Save to save the network security configuration changes.

​
What’s next?

You can now create your ClickPipe and start ingesting data from your Azure Flexible Server for MySQL instance into ClickHouse Cloud. Make sure to note down the connection details you used while setting up your instance, as you will need them during the ClickPipe creation process.
Last modified on July 29, 2026