C2MySQL

CockroachDB to MySQL/MariaDB

Replicator can replicate a CockroachDB changefeed into a MySQL or MariaDB database. The discussion in C2C applies, with the following notes:

• A separate CockroachDB instance must be used for staging, since Replicator relies on CockroachDB's transaction model for correctness when staging and applying mutations in transactionally-consistent modes.
• The replicator start flags would include two database connection strings:
  • --stagingConn 'postgres://staging.db:26257/'
  • --targetConn 'mysql://target.db:3306/target_db'

Note that the MySQL connection string follows the Postgres format, using mysql as the schema identifier.