Configure a Cloud SQL for MySQL database

The following sections cover how to configure a Cloud SQL for MySQL database to work with Datastream.

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 (Preview):
    ParameterValue
    net_read_timeout3600
    net_write_timeout3600
    wait_timeout86400
    binlog_row_imageFULL
    max_allowed_packet1G (recommended value)

    • For binlog-based replication:

      FlagValue
      net_read_timeout3600
      net_write_timeout3600
      wait_timeout86400

  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