MySQL Connector
MySQL Database is a fully-managed database service to deploy cloud-native applications using the world’s most popular open source database.
Features & Capabilities
- Backfill: Full historical sync of your entire data
- Data Extraction Modes: snapshot, incremental
- Data Load Modes: replace, append and merge
- Tables and Columns selection: The ability to select individual schemas, tables and columns for replication in the Datacoral's UI.
- Data-layout: changing the data type of your columns
- Customizations: Update the configurations easily using the UI
- Scheduling: Highly flexible scheduling system
Read more about our Features and Capabilities in the next tab.
MySQL Service Providers
- Generic MySQL
- Amazon Aurora MySQL
- Amazon RDS MySQL
- Azure MySQL addressable from your AWS VPC
- Google Cloud MySQL addressable from your AWS VPC
Supported Versions | 5.5, 5.6, 5.7, 8.0 and above |
---|
Data-type mapping
Currently Datacoral supports the following casting/data-types conversions.
Casting | Original data-type |
---|---|
string | char, varchar, binary, varbinary, blob, text, enum, set, tinyblob, tinytext, mediumblob, mediumtext, longblob, longtext, bit |
boolean | tinyint |
integer | integer, int, smallint, mediumint, bigint |
float | decimal, numeric, float, double |
timestamp | date, datetime, timestamp, time, year |
json | json |
We currently support increasing the size of a string data-type.
Next Steps
- Create a MySQL Connector in UI or CLI
- Schedule a Demo
Additional Information
Got a question?
Please contact Datacoral's Support Team, we'd be more than happy to answer any of your questions.