MogDB as a Source Database

Supported Version

Database version: 505.2.0 or later version

Note: GaussDB is the source database and does not support incremental synchronization. Please set migrationStage to 结构同步,全量迁移 as the advanced parameter of the channel.

Database Configuration

Modify the HBA Configuration of the Source Database

In the data directory, find the gs_hba.conf configuration file, add the following content to add the replication permission.

Note: mdb_user indicates the user for using the replication function. It needs to be modified based on actual requirement.

# Replace <data_directory> with the actual data directory. 
cat >> <data_directory>/gs_hba.conf <"EOF"

# Add for MDB replication
host  all          mdb_user   0.0.0.0/0  sha256
host  replication  mdb_user   0.0.0.0/0  sha256
EOF

Set User Permission

Create the mdb_user user for logging in to and replicate source MogDB data. The username and password need to be modified based on the actual requirement.

• The login permission is used for logging in to the database.
• The replication permission is used for synchronizing incremental data.
• The sysadmin permission is used for initializing objects and synchronizing full data.

create user mdb_user with login replication sysadmin PASSWORD 'Enmo@123';

Character Set Mapping