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 Flagssection.

5. Click Add a database flag.

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

   • For GTID-basedreplication:

     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-basedreplication:

     Flag	Value
     net_read_timeout	3600
     net_write_timeout	3600
     wait_timeout	86400

7. Click Saveto 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 .