Upstream Database Configuration File

This document introduces the configuration file of the upstream database, including a configuration file template and the description of each configuration parameter in this file.

Configuration file template

The following is a configuration file template of the upstream database:

source-id = "mysql-replica-01"

# Enables GTID.
enable-gtid = false

[from]
host = "127.0.0.1"
port = 3306
user = "root"
password = "ZqMLjZ2j5khNelDEfDoUhkD5aV5fIJOe0fiog9w=" # The user password of the upstream database. Note that the password must be encrypted using dmctl.

Configuration parameters

This section describes each configuration parameter in the configuration file.

Global configuration

Parameter Description
source-id Represents a MySQL instance ID.
enable-gtid Determines whether to pull binlog from the upstream using GTID. The default value is false. In general, you do not need to configure enable-gtid manually. However, if GTID is enabled in the upstream database, and the master/slave switch is required, you need to set enable-gtid to true.
host Specifies the host of the upstream database.
port Specifies the port of the upstream database.
user Specifies the username of the upstream database.
password Specifies the user password of the upstream database. Note that the password must be encrypted using dmctl.