Striim Migration Service for Google Cloud Documentation

MySQL / MariaDB to Google Cloud MySQL Migration Guide

For an overview and conceptual discussion of SMSGC, see Striim Migration Service User Guide.

Note

Except where there are separate instructions for MariaDB and MySQL, all references to MySQL sources apply to MariaDB sources as well.

This document provides detailed instructions for migrating data from one of the following MySQL or MariaDB sources to one of the following MySQL targets using SMSGC. SMSGC supports MySQL versions 5.5 and later and compatible versions of MariaDB.

  • sources

    • MariaDB on-premise

    • MySQL on-premise

    • Amazon RDS for Aurora version 2.2.0 or later

    • Amazon RDS for MariaDB

    • Amazon RDS for MySQL

    • Azure Database for MySQL

  • targets

    • Google Cloud SQL for MySQL

    • MySQL running in a Google Compute Engine virtual machine

This document assumes the following:

  • You have the access and privileges required to enable the binary log and create a user in the source MySQL server.

  • You have the privileges required to create a user on the target Google Cloud SQL for MySQL instance.

To create the SMSGC application, you will perform the following tasks, as detailed in this document. It is important that you perform the steps in the order in which they are described here.

  1. In the source MySQL instance, create a role for SMSGC.

  2. In the target MySQL instance, create a role for SMSGC.

  3. Copy the tables and data from the source to the target using the native tools of MySQL and Google Cloud SQL for MySQL. Alternatively, create tables in the target and create an initial load application to populate them as discussed in Create and test the initial load application.

  4. Create a streaming integration application by exporting TQL code for the initial load application, making a few revisions, and importing it.

  5. Test the streaming integration application and troubleshoot any problems encountered.

  6. Start the streaming integration application.

We strongly recommend you read both the Striim Migration Service User Guide and this entire document before starting to follow any of the detailed instructions below.