Configure a Cloud SQL for MySQL database for CDC

This page describes how to configure change data capture (CDC) to stream data from a Cloud SQL for MySQL database to a supported destination, such as BigQuery or Cloud Storage.

Enable binary logging

1. To enable binary logging for Cloud SQL for MySQL, see Enabling point-in-time recovery.

Configure database flags

1. In Google Cloud console, go to the Cloud SQL Instances page.

   Go to Cloud SQL Instances

2. Select the project that contains the Cloud SQL instance for which you want to set the database flags.

3. Open the instance and click Edit.

4. Go to the Flags section.

5. Click Add a database flag.

6. Choose the following flags from the drop-down menu, and set their values:

   • For GTID-based replication:

     Parameter	Value
     net_read_timeout	3600
     net_write_timeout	3600
     wait_timeout	86400
     binlog_row_image	FULL
     max_allowed_packet	1073741824 (recommended value)

   • For binlog-based replication:

     Flag	Value
     net_read_timeout	3600
     net_write_timeout	3600
     wait_timeout	86400

7. Click Save to save your changes.

Create a Datastream user

1. To create a Datastream user, enter the following MySQL commands:

   CREATE USER 'datastream'@'%' IDENTIFIED BY 'YOUR_PASSWORD';
   GRANT REPLICATION SLAVE, SELECT, REPLICATION CLIENT ON *.* TO 'datastream'@'%';
   FLUSH PRIVILEGES;

What's next

• Learn more about how Datastream works with MySQL sources.