Replica Configuration
To use outbound replication from HeatWave Service, the replica and its network connection to the DB system source need this configuration.
- Your VCN and local network must be configured to permit replication traffic between the DB system source and the replica. You can use VPN Connect, FastConnect, or OpenVPN Access Server for the connection.
- The replica must be the same version as, or a higher version of MySQL than, the DB system source.
- The replica must use GTIDs, with the system variable
GTID_MODE
set toON
. This is not the default in MySQL server, but it is the default in HeatWave Service. Binary log file position based replication is not supported by HeatWave Service, only GTID-based replication. See MySQL Reference Manual - gtid_mode. - The replica must use the system variable
enforce-gtid-consistency
. See enforce_gtid_consistency. - The replica must use the system variable
partial-revokes=ON
. See partial_revokes. - The DB system source and the replica must run with the same
lower_case_table_names
system variable value. See Initialization Variables. - The
server_id
system variable value must be defined on the replica and be unique in your replication topology. Theserver_uuid
system variable value must also be unique. See server_id and server_uuid. - The replica must contain the same timezone definitions as the DB system source. The default timezone of HeatWave Service is UTC. See Populating the Timezone Tables.
- Outbound replication from a DB system source to an external replica, or
to another DB system as the replica, requires you to create a dump of the DB system
source using MySQL Shell's
dumpInstance
utility and import that dump on the replica, including users, before starting replication. See Overview of Exporting and Importing. - Users on the DB system source must be present on the replica. Partial
revokes requires that the roles and users creating grants are present on the
replica. The users on the source are exported as part of the MySQL Shell dump and
must be imported to the replica.
Note
The user account used to load the MySQL Shell dump on the replica must have the necessary privileges to load users and data.
The replica must be able to apply the transactions from the DB system source
before the source's binary log is purged. The default value of
binlog_expire_logs_seconds
is 3600 seconds (1 hour). If your
replica will need more time than this to apply the transactions, create a new HeatWave Service configuration with the required
expiration value, and create a new source DB system using the new configuration.
The replication user must be present on the DB system source server with the required privileges. See Creating a Replication User On a Source Server for the steps to set up the replication user.