Get started with a free trial today
Already have an account? Sign in
All versions for Stitch's MariaDB 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 |
The five most recent updates made to the MariaDB integration. Refer to theMySQL 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 | Improvement | MySQL (v1) integrations: Fix composite Primary Key sorting for Full Table Replication |
| Sep 1, 2019 | Removed | MySQL (v15-10-2015) sunset |
| Mar 18, 2019 | Improvement | MySQL (v1) integrations: Allow non-auto-incrementing Primary Keys for Full Table |
| View all entries in the MySQL Integration Changelog | ||
In this section:
| MariaDB version 2 (latest) | MariaDB version 1 | ||
| STITCH | |||
| Release status | Released on November 8, 2021 | Deprecated on November 8, 2021 | |
| Supported by | |||
| Stitch plan | Standard | Standard | |
| Supported versions | n/a | n/a | |
| API availability | Available | Not available | |
| Singer GitHub repository | |||
| CONNECTION METHODS | |||
| SSH connections | Supported | Supported | |
| SSL connections | Supported | Supported | |
| 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 | Unsupported | |
| Select all | Supported, with prerequisites | Supported, with prerequisites | |
| TRANSPARENCY | |||
| Extraction Logs | Supported | Supported | |
| Loading Reports | Supported | Supported | |
In the table below are the data types MariaDB integrations support and the Stitch data type it will map to, depending on the version of the integration being used:
Refer to theData 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.
| MariaDB version 2 (latest) | MariaDB 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 |
| Related | Troubleshooting |
Did this article help? If you have questions or feedback, feel free tosubmit a pull request with your suggestions,open an issue on GitHub, orreach out to us.