检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
If you do not select Delete, DELETE statements in the incremental data of the source database will not be synchronized, which may cause a data inconsistency. As a result, there may be a data conflict or the task may fail.
privileges" : null, "password" : null, "roles" : [ "fastunit.read", "admin.readAnyDatabase" ], "selected" : null, "is_transfer" : true } ], "roles_list" : [ { "role" : "admin.roletest4", "comment" : "", "privileges" : "GRANT SELECT, INSERT, UPDATE, DELETE
Attempting to delete, rename, or change the passwords or permissions for temporary accounts will cause task errors.
DELETE: indicates the operation command for deleting a task. FREE_RESOURCE: indicates the operation command for releasing resources. JUMP_RETRY: indicates the operation command for skipping a resumable task.
If you do not select Delete, DELETE statements in the incremental data of the source database will not be synchronized, which may cause a data inconsistency. As a result, there may be a data conflict or the task may fail.
If you do not select Delete, DELETE statements in the incremental data of the source database will not be synchronized, which may cause a data inconsistency. As a result, there may be a data conflict or the task may fail.
If you do not select Delete, DELETE statements in the incremental data of the source database will not be synchronized, which may cause a data inconsistency. As a result, there may be a data conflict or the task may fail.
Grant the SELECT, UPDATE, INSERT, and DELETE permissions on all tables in the schema to the user.
If you do not select Delete, DELETE statements in the incremental data of the source database will not be synchronized, which may cause a data inconsistency. As a result, there may be a data conflict or the task may fail.
Destination database user The DDM destination database user must have the following permissions: CREATE, DROP, ALTER, INDEX, INSERT, DELETE, UPDATE, and SELECT. In addition, grant the SELECT permission on all tables.
Destination database user The DDM destination database user must have the following permissions: CREATE, DROP, ALTER, INDEX, INSERT, DELETE, UPDATE, and SELECT. In addition, grant the SELECT permission on all tables.
During synchronization, do not modify or delete the usernames, passwords, permissions, or ports of the source and destination databases.
Destination database user The user must have the following minimum permissions: SELECT, CREATE, ALTER, DROP, DELETE, INSERT, UPDATE, INDEX, EVENT, CREATE VIEW, CREATE ROUTINE, TRIGGER, REFERENCES, and WITH GRANT OPTION.
Destination database user The user must have the following minimum permissions: SELECT, CREATE, ALTER, DROP, DELETE, INSERT, UPDATE, INDEX, EVENT, CREATE VIEW, CREATE ROUTINE, TRIGGER, REFERENCES, and WITH GRANT OPTION.
All of the SQL statements (create, delete, update, and query operations) executed in the required period on the source database will be downloaded by a recording tool from the binlog, and then cached and injected into the destination database where you can trigger a replay and review
The SQL statement can be INSERT, DELETE/DROP, UPDATE, or SELECT. The CN uses the optimizer of the database to generate an execution plan and sends the plan to DNs. Each DN processes data based on the execution plan.
Use restrictions General During the migration, do not modify or delete the usernames, passwords, and permissions of the source and destination databases or change the ports of the source and destination databases.
Full or Incremental Phase Error: table *** record field size for insert/delete dml Full or Incremental Phase Error: service *** failed, cause by: Unable to connect to DBMS: *** Full or Incremental Phase Error: The binlog fetch connection may be interrupted Full or Incremental Phase
If the query result contains the replication slot name used by the DRS task but the replication slot is not used (active='f'), run the following statement to delete its logical replication slot: select * from pg_drop_replication_slot('slot_name'); In the preceding command, slot_name
Destination database user The user must have the following minimum permissions: SELECT, CREATE, ALTER, DROP, DELETE, INSERT, UPDATE, INDEX, EVENT, CREATE VIEW, CREATE ROUTINE, TRIGGER, REFERENCES, and WITH GRANT OPTION.
