MariaDB target

TwinCommit applies changes to MariaDB with multi-row INSERT ... ON DUPLICATE KEY UPDATE and keyed deletes. The data and the checkpoint commit together in one InnoDB transaction.

Supported: MariaDB 10.6, 10.11 and 11.4 LTS · Galera clusters · Amazon RDS for MariaDB · SkySQL.

Configuration

target:
  type: mariadb
  host: mariadb-galera.internal
  port: 3306
  user: twincommit
  password: ${MARIADB_TARGET_PASSWORD}
  database: replica

How apply works

The apply is the same as the MySQL target. On Galera, TwinCommit writes to one node, so its transactions certify like any other client’s. Set wsrep_retry_autocommit and let TwinCommit retry certification conflicts automatically.

Grants

CREATE USER 'twincommit'@'%' IDENTIFIED BY '********';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX ON replica.* TO 'twincommit'@'%';