检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
To delete a group of a pay-per-use DDM instance, locate the group that you want to delete and click More > Delete Group in the Operation column. The corresponding floating IP address becomes invalid once the group is deleted. This may affect your services.
The value can be CREATE, DROP, ALTER, INDEX, INSERT, DELETE, UPDATE, or SELECT. Enumerated values: CREATE DROP ALTER INDEX INSERT DELETE UPDATE SELECT description No String Description of the DDM account, which cannot exceed 256 characters. It is left blank by default.
DML INSERT REPLACE DELETE UPDATE SELECT SELECT JOIN Syntax SELECT UNION Syntax SELECT Subquery Syntax Unsupported DML Statements Supported System Schema Queries Parent topic: SQL Syntax
Deleting a schema This API is used to delete a schema to release all its resources. Querying DB instances available for creating a schema This API is used to query DB instances that can be used for creating a schema.
For example, you can create IAM users for software developers and assign specific permissions to allow them to use DDM resources but disallow them to delete the resources or perform any high-risk operations. IAM is a free service. You pay only for the resources in your account.
Unsupported DML Statements Unsupported DML Statements Table 1 Syntax restrictions on DML DML Syntax Constraint DELETE statement PARTITION clauses are not supported. UPDATE statement Cross-shard subquery is not supported. SELECT statement ORDER BY statement.
Database Accounts and Permissions To create a schema, import schema information, or configure shards, you can use the administrator account of data nodes or create a database account with the following permissions: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES
Response example: { "errCode": "DBS.300101", "externalMessage": "Failed to delete the schema" } Parent topic: Appendix
The value can be CREATE, DROP, ALTER, INDEX, INSERT, DELETE, UPDATE, or SELECT. Enumerated values: CREATE DROP ALTER INDEX INSERT DELETE UPDATE SELECT description No String Description of the DDM account, which cannot exceed 256 characters. It is left blank by default.
Monitor idle DDM resources and delete idle instances in a timely manner.
Do not modify or delete the internal accounts (DDMRW*, DDMR*, and DDMREP*) created on data nodes. Otherwise, services will be affected. The internal account name is in the format: Fixed prefix (such as DDMRW, DDMR, or DDMREP) + Hash value of the data node ID.
Required permissions: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER,
If no, modify them and try again. 400 DBS.300115 Failed to delete the shard. To delete the schema, check whether there are RDS instances associated with it.
Prefix Match: Enter SQL statements that contain keywords such as DROP or DELETE and are not allowed by the current schema. Full-text Match: Enter full-text SQL statements that are not allowed by the current schema.
DELETE Requests a server to delete specified resources, for example, an object. For example, for the URI of the API used to obtain a user token, the request method is POST.
The following is an example of a deny policy: { "Version": "1.1", "Statement": [ { "Effect": "Deny", "Action": [ "ddm:instance:delete" ] } ] } The following is
When you delete a schema, the global sequence of the schema is also deleted. Parent topic: Global Sequence
Query Per Second (QPS) refers to the number of SQL statements, including INSERT, SELECT, UPDATE, and DELETE statements, executed per second.
Stopping Billing If you no longer need to use your DDM instance, you can unsubscribe from or delete it to stop the billing. For details, see Billing Termination. Managing Costs DDM costs include resource costs and O&M costs.
Submit a service ticket to the O&M personnel to coordinate resources, delete the node that fails to be added, and add a node again. A DDM instance cannot be scaled out. Failed to scale in a DDM instance reduceNodeFailed Major The underlying resources fail to be released.
