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 Versions5.5, 5.6, 5.7, 8.0 and above

Data-type mapping

Currently Datacoral supports the following casting/data-types conversions.

CastingOriginal data-type
stringchar, varchar, binary, varbinary, blob, text, enum, set, tinyblob, tinytext, mediumblob, mediumtext, longblob, longtext, bit
booleantinyint
integerinteger, int, smallint, mediumint, bigint
floatdecimal, numeric, float, double
timestampdate, datetime, timestamp, time, year
jsonjson

We currently support increasing the size of a string data-type.

Next Steps

Additional Information

Got a question?

Please contact Datacoral's Support Team, we'd be more than happy to answer any of your questions.