检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Handling suggestion: Delete the read replicas from the destination database. After the migration is complete, create read replicas. Parent topic: Destination DB Instance Statuses
Deleting a Task In the task list on the Data Subscription Management page, locate the target task and click Delete in the Operation column. Click Yes to submit the deletion task.
You can also stop or delete an unused migration task. Parent topic: Destination DB Instance Statuses
Handling suggestion: Delete the foreign key, disable the trigger, or change the value of session_replication_role to replica. Parent topic: Database Parameters
Solution Contact destination database O&M engineers to delete the corresponding table from the destination database. In the task list, locate the target task and click Resume in the Operation column to resume the task.
If you manually add, modify, or delete a record, the DRS data comparison result will be inconsistent. If you scale up storage of a RDS database, it is an internal operation of RDS and does not affect DRS tasks. Parent topic: Product Consulting
Solution Run the following SQL statement to delete or rename the foreign key constraints with the same name in the destination database: select * from information_schema.REFERENTIAL_CONSTRAINTS where CONSTRAINT_NAME = "foreign_key_name"; In the task list, locate the target task and
When the system variable innodb_force_recovery is set to be greater than 0 in the destination database, the INSERT, UPDATE, and DELETE operations are disabled in the destination database.
In this case, you can only delete the backup database and perform full and incremental backup restoration again. SQL Server does not have the last backup file in a strict sense. If you select No by mistake, you can perform an incremental backup (even if no data is changed).
Handling suggestions: Delete the destination database views that have the same names as those in the source database. Alternatively, do not migrate the views with the same names. Parent topic: Conflicts
Statement for granting the DML permission on all tables in the schema: GRANT SELECT, UPDATE, INSERT, DELETE, INDEX, ALTER ON ALL TABLES IN SCHEMA <schema> TO <user> Statement for granting the DML permission on a specified table in the schema: GRANT SELECT, UPDATE, INSERT, DELETE,
Return to the object selection page, delete the tables where a generated column is a primary key or unique key from the synchronization object, and perform the pre-check again. Parent topic: Database Parameters
Solution Contact the O&M engineers to delete the tables that do not have primary keys from the destination database. In the task list, locate the target task and click Resume in the Operation column to resume the task.
Table 1 Advanced features Feature Description Dynamically adding or deleting subscription objects During data subscription, you add or delete subscription objects as required. Viewing subscription data View the incremental data on the management console.
Resource rightsizing View DRS task monitoring metrics on the Cloud Eye console, restore failed tasks, and delete idle tasks in a timely manner. Purchase a task with the small specifications for workloads requiring low performance stability to reduce costs.
Handling suggestion: Do not synchronize indexes or delete some indexes so that the number of indexes in a single table in the source database does not exceed 64.
after the migration) Reference statements: GRANT CONNECT ON DATABASE database_name TO ptd; GRANT USAGE ON SCHEMA schema_name TO ptd; GRANT SELECT ON TABLE table_name TO ptd; GRANT SELECT ON SEQUENCE sequence_name TO ptd; GRANT SELECT ON pg_catalog.pg_authid TO ptd; GRANT UPDATE, DELETE
DRS converts the update operation to delete and insert operations by default. During the insert operation, the log does not contain data of other columns. As a result, an error is reported. Solution Change the supplemental log level of the source database to ALL.
Attempting to delete, rename, or change the passwords or permissions for these accounts will cause task errors.
Disable or delete foreign keys. Disabling foreign keys: alter table table_name disable constraint constraint_name; Deleting foreign keys: alter table table_name drop constraint constraint_name; Parent topic: Destination DB Instance Statuses
