Identify your version


Google CloudSQL MySQL updates

Google CloudSQL MySQL version history

All versions for Stitch's Google CloudSQL MySQL integration, including release and deprecation dates.

Version Status Release Deprecation End of life (Sunset)
version 2 (latest) Released November 8, 2021
version 1 Deprecated October 24, 2017 November 8, 2021

Google CloudSQL MySQL changelog

The five most recent updates made to the Google CloudSQL MySQL integration. Refer to the MySQL Integration Changelog for this integration's full history.

Date Type Entry title
Apr 19, 2021 Beta MySQL integration: New version (v2) now in beta
Mar 24, 2021 New feature New feature: Integration changelogs
Sep 18, 2019 Updated feature MySQL (v1) integrations: Fix composite Primary Key sorting for Full Table Replication
Sep 1, 2019 Sunset MySQL (v15-10-2015) sunset
Mar 18, 2019 Updated feature MySQL (v1) integrations: Allow non-auto-incrementing Primary Keys for Full Table
View all entries in the MySQL Integration Changelog

Google CloudSQL MySQL version features

In this section:

Google CloudSQL MySQL version comparison

Google CloudSQL MySQL
version 2
(latest)
Google CloudSQL MySQL
version 1
STITCH
Release status

Released on November 8, 2021

Deprecated on November 8, 2021

Supported by

Stitch

Stitch

Stitch plan

Standard

Standard

Supported versions

n/a

n/a

API availability

Available

Not available

Singer GitHub repository

singer-io/tap-mysql

CONNECTION METHODS
SSH connections

Unsupported

Unsupported

SSL connections

Unsupported

Unsupported

REPLICATION SETTINGS
Anchor Scheduling

Supported

Supported

Advanced Scheduling

Supported

Supported

Table-level reset

Supported

Supported

Configurable Replication Methods

Supported

Supported

REPLICATION METHODS
Log-based Replication

Supported

Supported

Key-based Replication

Supported

Supported

Full Table Replication

Supported

Supported

DATA SELECTION
Table selection

Supported

Supported

Column selection

Supported

Supported

View replication

Supported

Supported

Select all

Supported, with prerequisites

Supported, with prerequisites

TRANSPARENCY
Extraction Logs

Supported

Supported

Loading Reports

Supported

Supported


Data types

In the table below are the data types Google CloudSQL MySQL integrations support and the Stitch data type it will map to, depending on the version of the integration being used:

  • indicates that the data type is supported. Following the icon is the Stitch data type it will map to.
  • indicates that the data type is supported, but there is additional information you should know. Hover over the icon to view a tooltip with the information.
  • indicates that the data type isn't applicable to the integration. This is usually because the integration doesn't use that particular data type.
  • indicates that the data type isn't supported. In Stitch, columns with unsupported data types will have Unavailable in the Type column of the Tables to Replicate tab.

Refer to the Data typing guide for more info about how Stitch identifies and types data when it's loaded into your destination.

Note: This table doesn't display info for versions that have been sunset.

Google CloudSQL MySQL
version 2
(latest)
Google CloudSQL MySQL
version 1
INTEGER BIGINT INTEGER
BINARY
BIT
BIT(1) BOOLEAN BOOLEAN
BIT>1
BLOB
CHAR STRING STRING
DATE DATE DATETIME
DATETIME TIMESTAMP DATETIME
DECIMAL DECIMAL DECIMAL
DOUBLE DOUBLE FLOAT
ENUM STRING STRING
FLOAT FLOAT FLOAT
GEOMETRY
GEOMETRYCOLLECTION
INT INTEGER INTEGER
INTEGER INTEGER INTEGER
JSON OBJECT STRING
LINESTRING
LONGBLOB
LONGNVARCHAR
LONGTEXT STRING STRING
LONGVARBINARY
LONGVARCHAR STRING STRING
MEDIUMBLOB
MEDIUMINT INTEGER INTEGER
MEDIUMTEXT STRING STRING
MULTILINESTRING
MULTIPOINT
MULTIPOLYGON
NCHAR STRING STRING
NUMERIC DECIMAL DECIMAL
NVARCHAR STRING STRING
OTHER
POINT
POLYGON
REAL DOUBLE DOUBLE
SET
SMALLINT INTEGER INTEGER
TEXT STRING STRING
TIME DATETIME DATETIME
TIMESTAMP TIMESTAMP , formatted as DATE-TIME DATETIME
TINYBLOB
TINYINT
TINYINT(1) BOOLEAN BOOLEAN
TINYINT>1 INTEGER INTEGER
TINYTEXT STRING
VARCHAR STRING STRING
YEAR

Questions? Feedback?

Did this article help? If you have questions or feedback, feel free to submit a pull request with your suggestions, open an issue on GitHub, or reach out to us.