Setting Up Replication
This example will guide you through setting up replication of a database.
To replicate a database, the secondary cluster user must have
CREATE DATABASE privileges and the primary cluster user (the one specified in
REPLICATE DATABASE) must have the
ALL PRIVILEGES permission on the primary cluster’s master aggregator.
host:port combinations represent the master aggregators of the primary and secondary clusters:
Note that the primary and secondary clusters need not have identical topologies.
To begin replicating the database
primary-MA, run the following command on
REPLICATE DATABASE db_name FROM master_user:'master_user_password'@primary-MA:3306;
You always initiate replication from the secondary cluster.
Multiple secondary clusters can replicate from a single primary cluster.
REPLICATE DATABASE on the master aggregator of each of the replica clusters.
Data is always replicated across clusters asynchronously.
Last modified: April 3, 2023