:Overview

Configurations required for preparing a database

• An account to which the required permissions are granted

  Before you configure a data synchronization solution or node, you must create an account that can be used to access a database and grant the account the permissions required to perform specific operations on the database based on your configurations for data synchronization. For example, if a schema that has the same name as the schema in the source database must be created in the destination database during data synchronization, you must grant the account that is used to access the destination database the permissions to create schemas in advance. Statements that are used to grant operation permissions vary based on the database type. You can refer to the documentation for the statement syntax for each type of database to grant the required permissions in advance. This prevents error messages such as Access denied and permission denied from being reported when you configure or run a data synchronization solution or node. You can refer to the answers to the following questions to resolve the permission issue that may occur when you synchronize data from Hologres and MySQL in real time: Real-time synchronization and Real-time synchronization.

• Other settings

  For specific types of databases, you must also make other preparations such as enabling the binary logging feature or enabling the generation of database-level redo log files.

Configurations required for preparing databases that are used for data synchronization vary based on the database type. You can refer to the related topic to make the preparations.