Overview of Database Environment Preparation

Enable the source database logs and set up necessary database privileges before executing a pipeline task, for FineDataLink to synchronize real-time data by monitoring changes in the source database log.  This article introduces the preparation required to use different databases.

Database Privilege Assignment

Grant database users the necessary privileges to perform corresponding operations on the database before executing a pipeline task.

For instance, to create a schema in the target database with the same name as that in the source database when configuring a synchronization task, you must have the privilege to create schemas. The privilege-granting commands of databases may vary. See the database syntax for details.

Other Preparation

Some data sources require additional preparation work, including but not limited to enabling the source-end binlog and the database-level redo log. 

The preparation work varies with databases. Refer to relevant documents to grant privileges.

Note:

You can check whether the database log has been enabled after restarting the environment of the database used in the pipeline task.