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:

   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;