# Amazon Aurora MySQL RDS

## Identify your version

Information note **Need some help identifying your Amazon Aurora MySQL RDS version?** Refer to the [Identifying an integration version guide](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version).

* (LATEST)

  [![Amazon Aurora MySQL RDS](https://help.qlik.com/en-US/stitch/images/integrations/icons/aurora-rds.svg)](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql/v2) **version 2** [Setup](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql/v2#setup) | [Replication](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql/v2#extract-data)
* [![Amazon Aurora MySQL RDS](https://help.qlik.com/en-US/stitch/images/integrations/icons/aurora-rds.svg)](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql/v1) **version 1** [Setup](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql/v1#setup) | [Replication](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql/v1#extract-data)

## Amazon Aurora MySQL RDS updates

* [Amazon Aurora MySQL RDS version history](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql#version-history)

* [Amazon Aurora MySQL RDS changelog](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql#integration-changelog)

### Amazon Aurora MySQL RDS version history

All versions for Stitch's Amazon Aurora MySQL RDS integration, including release and deprecation dates.

| **Version** | **Status** | **Release** | **Deprecation** | **End of life (Sunset)** |
| --- | --- | --- | --- | --- |
| **[version 2](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql/v2)**<br>(latest) | Released | November 8, 2021 |  |  |
| **[version 1](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql/v1)** | Deprecated | October 24, 2017 | November 8, 2021 |  |

### Amazon Aurora MySQL RDS changelog

Information note **Some entires shown here may not be applicable to Amazon Aurora MySQL RDS**. As the Amazon Aurora MySQL RDS integration is a variant of Stitch’s MySQL integration, some entries shown below may not be completely applicable to Amazon Aurora MySQL RDS. Refer to the full entries for details.

The five most recent updates made to the Amazon Aurora MySQL RDS integration. Refer to the [MySQL Integration Changelog](https://help.qlik.com/en-US/stitch/integrations/databases/mysql/changelog) for this integration's full history.

| **Date** | **Type** | **Entry title** |
| --- | --- | --- |
| **Apr 19, 2021** | Beta | [MySQL integration: New version (v2) now in beta](https://help.qlik.com/en-US/stitch/integrations/databases/mysql/changelog#2021-04-19-mysql-integration-new-version-v2-now-in-beta) |
| **Mar 24, 2021** | New feature | [New feature: Integration changelogs](https://help.qlik.com/en-US/stitch/integrations/databases/mysql/changelog#2021-03-24-new-feature-integration-changelogs) |
| **Sep 18, 2019** | Improvement | [MySQL (v1) integrations: Fix composite Primary Key sorting for Full Table Replication](https://help.qlik.com/en-US/stitch/integrations/databases/mysql/changelog#2019-09-18-mysql-v1-integrations-fix-composite-primary-key-sorting-for-full-table-replication) |
| **Sep 1, 2019** | Removed | [MySQL (v15-10-2015) sunset](https://help.qlik.com/en-US/stitch/integrations/databases/mysql/changelog#2019-09-01-mysql-v15-10-2015-sunset) |
| **Mar 18, 2019** | Improvement | [MySQL (v1) integrations: Allow non-auto-incrementing Primary Keys for Full Table](https://help.qlik.com/en-US/stitch/integrations/databases/mysql/changelog#2019-03-18-mysql-v1-integrations-allow-non-auto-incrementing-primary-keys-for-full-table) |
| [View all entries in the MySQL Integration Changelog](https://help.qlik.com/en-US/stitch/integrations/databases/mysql/changelog) |  |  |

## Amazon Aurora MySQL RDS version features

In this section:

* [Supported features](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql#supported-features)

### Amazon Aurora MySQL RDS version comparison

|  | **Amazon Aurora MySQL RDS<br><br>[version 2](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql/v2)**<br>(latest) | **Amazon Aurora MySQL RDS<br><br>[version 1](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql/v1)** |
| --- | --- | --- |
| **STITCH** |  |  |
| **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Released on November 8, 2021 | Deprecated on November 8, 2021 |
| **Supported by<br><br><br><br><br><br><br>the Info iconIndicates if the integration is supported by Stitch or the Singer community.** | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) |
| **Stitch plan<br><br><br><br><br><br><br>the Info iconThe type of Stitch plan required to use the integration.** | Standard | Standard |
| **Supported versions<br><br><br><br><br><br><br>the Info iconIndicates if the integration is supported by Stitch or the Singer community.** | n/a | n/a |
| **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)<br><br><br><br><br><br><br>the Info iconIndicates if the integration is available as a source in Stitch Connect.** | the Success icon<br><br>This version of the integration is available via the API.<br><br><br>Available | the Remove icon<br><br>This version of the integration isn't available via the API.<br><br><br>Not available |
| **Singer GitHub repository** | [](https://help.qlik.com/en-US/stitch/integrations/databases/amazon-aurora-mysql) | [singer-io/tap-mysql](https://github.com/singer-io/tap-mysql) |
| **CONNECTION METHODS** |  |  |
| **SSH connections<br><br><br><br><br><br><br>the Info iconIndicates if SSH tunnels are supported for connecting this database to Stitch.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **SSL connections<br><br><br><br><br><br><br>the Info iconIndicates if SSL connections are supported for connecting this database to Stitch.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **REPLICATION SETTINGS** |  |  |
| **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)<br><br><br><br><br><br><br>the Info iconA type of replication scheduling where an integration's Replication Frequency is anchored to a time you select.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)<br><br><br><br><br><br><br>the Info iconA type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **Table-level reset<br><br><br><br><br><br><br>the Info iconIndicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)<br><br><br><br><br><br><br>the Info iconIndicates if Replication Methods can be defined by you for tables in the integration.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **REPLICATION METHODS** |  |  |
| **[Log-based Replication](https://help.qlik.com/en-US/stitch/replication/replication-methods/log-based-incremental)<br><br><br><br><br><br><br>the Info iconLog-based Incremental Replication is a replication method in which Stitch identifies modifications to records - including inserts, updates, and deletes - using a database's binary log files.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **[Key-based Replication](https://help.qlik.com/en-US/stitch/replication/replication-methods/key-based-incremental)<br><br><br><br><br><br><br>the Info iconKey-based Incremental Replication is a replication method in which Stitch identifies new and updated data using a column called a Replication Key.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **[Full Table Replication](https://help.qlik.com/en-US/stitch/replication/replication-methods/full-table)<br><br><br><br><br><br><br>the Info iconFull Table Replication is a replication method in which all rows in a table - including new, updated, and existing - are replicated during every replication job.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **DATA SELECTION** |  |  |
| **Table selection<br><br><br><br><br><br><br>the Info iconThe ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **Column selection<br><br><br><br><br><br><br>the Info iconThe ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **[View replication](https://help.qlik.com/en-US/stitch/replication/replicating-database-views)<br><br><br><br><br><br><br>the Info iconIndicates if Stitch supports replicating views from this database integration.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **Select all<br><br><br><br><br><br><br>the Info iconIndicates if the integration supports selecting all available tables and columns.** | the Warning 2 icon<br><br>Log-based Incremental Replication must be enabled and set as the default Replication Method to use the Select All feature.<br><br><br>Supported, with prerequisites | the Warning 2 icon<br><br>Log-based Incremental Replication must be enabled and set as the default Replication Method to use the Select All feature.<br><br><br>Supported, with prerequisites |
| **TRANSPARENCY** |  |  |
| **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)<br><br><br><br><br><br><br>the Info iconLogs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |
| **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)<br><br><br><br><br><br><br>the Info iconReports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur.** | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported | the Success icon<br><br>This feature is supported for this version of the integration.<br><br><br>Supported |

## Data types

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

* the Success icon

  This data type is supported for this version of the integration.

  indicates that the data type is supported. Following the icon is the Stitch data type it will map to.
* the Info icon

  This data type is supported for this version of the integration, but there's additional info you should know.

  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.
* the Info icon

  This data type isn't applicable to the integration.

  indicates that the data type isn't applicable to the integration. This is usually because the integration doesn't use that particular data type.
* the Remove icon

  This data type is unsupported for this version of the integration.

  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](https://help.qlik.com/en-US/stitch/replication/supported-data-types) 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.

|  | **Amazon Aurora MySQL RDS<br><br>[version 2](https://help.qlik.com/en-US/stitch/)**<br>(latest) | **Amazon Aurora MySQL RDS<br><br>[version 1](https://help.qlik.com/en-US/stitch/)** |
| --- | --- | --- |
| [INTEGER](https://dev.mysql.com/doc/refman/8.0/en/integer-types.html) | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>BIGINT | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>INTEGER |
| **BINARY** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **BIT** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **BIT(1)** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>BOOLEAN | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>BOOLEAN |
| **BIT&gt;1** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **BLOB** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **CHAR** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING |
| **DATE** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DATE | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DATETIME |
| **DATETIME** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>TIMESTAMP | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DATETIME |
| **DECIMAL** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DECIMAL | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DECIMAL |
| **DOUBLE** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DOUBLE | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>FLOAT |
| **ENUM** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING |
| **FLOAT** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>FLOAT | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>FLOAT |
| **GEOMETRY** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **GEOMETRYCOLLECTION** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **INT** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>INTEGER | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>INTEGER |
| **INTEGER** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>INTEGER | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>INTEGER |
| **JSON** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>OBJECT | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING |
| **LINESTRING** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **LONGBLOB** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **LONGNVARCHAR** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **LONGTEXT** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING |
| **LONGVARBINARY** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **LONGVARCHAR** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING |
| **MEDIUMBLOB** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **MEDIUMINT** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>INTEGER | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>INTEGER |
| **MEDIUMTEXT** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING |
| **MULTILINESTRING** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **MULTIPOINT** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **MULTIPOLYGON** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **NCHAR** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING |
| **NUMERIC** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DECIMAL | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DECIMAL |
| **NVARCHAR** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING |
| **OTHER** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **POINT** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **POLYGON** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **REAL** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DOUBLE | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DOUBLE |
| **SET** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **SMALLINT** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>INTEGER | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>INTEGER |
| **TEXT** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING |
| **TIME** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DATETIME | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DATETIME |
| **TIMESTAMP** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>TIMESTAMP<br><br><br>, formatted as DATE-TIME | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>DATETIME |
| **TINYBLOB** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **TINYINT** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **TINYINT(1)** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>BOOLEAN | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>BOOLEAN |
| **TINYINT&gt;1** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>INTEGER | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>INTEGER |
| **TINYTEXT** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING | the Remove icon<br><br>This data type is unsupported for this version of the integration. |
| **VARCHAR** | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING | the Success icon<br><br>This data type is supported for this version of the integration.<br><br><br>STRING |
| **YEAR** | the Remove icon<br><br>This data type is unsupported for this version of the integration. | the Remove icon<br><br>This data type is unsupported for this version of the integration. |