检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Example: Parameters for Connecting to the Database in Different Scenarios In the following example, host:port represents a node, where host indicates the name or IP address of the server where the database resides, and port indicates the port number of the server where the database
If the standby node cannot be found, an exception is thrown. preferSlave: attempts to connect to a standby DN (if available) in the URL connection string.
Global Transaction Manager (GTM): manages the status of transactions. Cluster Management Server (CMS): manages the instance status. Data node (DN): stores and queries table data.
INSERT INTO myschema.mytable values (200); SELECT * FROM myschema.mytable; Figure 9 Inserting and verifying data Follow-up Operations After logging in to the instance, you can create alarm rules, set automated backup policies, create databases, and migrate data.
CREATE TABLESPACE CREATE TABLE SUBPARTITION CREATE TRIGGER CREATE TYPE CREATE USER CREATE USER MAPPING CREATE VIEW CREATE WEAK PASSWORD DICTIONARY CURSOR DEALLOCATE DECLARE DELETE DO DROP AGGREGATE DROP AUDIT POLICY DROP CAST DROP CLIENT MASTER KEY DROP COLUMN ENCRYPTION KEY DROP
SCHEMA DROP SECURITY LABEL DROP SEQUENCE DROP SERVER DROP SLICEGROUP DROP SYNONYM DROP TABLE DROP TABLESPACE DROP TRIGGER DROP TYPE DROP USER DROP USER MAPPING DROP VIEW DROP WEAK PASSWORD DICTIONARY Parent topic: SQL Syntax
Selecting a Storage Model [Recommendation] Selecting a storage model is the first step in defining a table. The storage model mainly depends on the customer's service type. For details, see Table 1.
C CALL CHECKPOINT CLEAN CONNECTION CLOSE CLUSTER COMMENT COMMIT | END COMMIT PREPARED COPY CREATE AGGREGATE CREATE AUDIT POLICY CREATE CAST CREATE CLIENT MASTER KEY CREATE COLUMN ENCRYPTION KEY CREATE CONVERSION CREATE DATABASE CREATE DATABASE LINK CREATE DIRECTORY CREATE EVENT CREATE
If the standby node cannot be found, an exception is thrown. preferSlave: attempts to connect to a standby DN (if available) in the URL connection string.
Value range: enumerated values on (true, yes, 1): The primary node waits for the standby node to flush logs to disks before committing a transaction. off (false, no, 0): The primary node commits a transaction without waiting for the primary node to flush logs to disks.
Node group name (when enable_nodegroup_debug is set to on): A specific node group is used as the compute node group.
Value range: enumerated values on (true, yes, 1): The primary node waits for the standby node to flush logs to disks before committing a transaction. off (false, no, 0): The primary node commits a transaction without waiting for the primary node to flush logs to disks.
); 200 (32-core CPU/256-GB memory) DN: 8000 (96-core CPU/768-GB memory); 5000 (72-core CPU/576-GB memory); 4000 (64-core CPU/512-GB memory); 1000 (32-core CPU/256-GB memory) Impact of incorrect configuration: If the value of max_connections exceeds the maximum dynamic value, the node
The public_cloud.conf file contains the following NIC information: mgr.net (management NIC), data.net (data NIC), and virtual.net (virtual NIC). local_bind_address Parameter description: Specifies the host IP address bound to the current node for connecting to other nodes in the database
Table 11 nodes Parameter Type Description id String Node ID. name String Node name. role String Node type. master: primary node slave: standby node secondary: log node readreplica: read replica. status String Node status.
(The logs do not need to be flushed to disks.) remote_receive: The primary node waits for the standby node to receive logs before committing a transaction.
There are six value options, namely, any, master, slave, preferSlave, read-write, and read-only. The default value is any. any: attempts to connect to any DN in the URL connection string. master: attempts to connect to a primary node in the URL connection string.
Node group name (when enable_nodegroup_debug is set to on): A specific node group is used as the compute node group.
[10,200] [10,200] [64 GB,128 GB) [10,1000] [10,2500] [128 GB,256 GB) [10,2000] [10,6000] [256 GB,480 GB) [10,4000] [10,12000] ≥ 480 GB [10,8000] [10,24000] Default value: Independent deployment: CN: 8000 (60-core CPU/480 GB memory); 4000 (32-core CPU/256 GB memory); 2000 (16-core
SELECT xmlconcat(xmlcomment('hello'), xmlelement(NAME qux, 'xml'), xmlcomment('world')); xmlconcat ---------------------------------------- <!
