- About MogDB
- Quick Start
- MogDB Playground
- Container-based MogDB Installation
- Installation on a Single Node
- MogDB Access
- Use CLI to Access MogDB
- Use GUI to Access MogDB
- Use Middleware to Access MogDB
- Use Programming Language to Access MogDB
- Using Sample Dataset Mogila
- Characteristic Description
- Overview
- High Performance
- High Availability (HA)
- Primary/Standby
- Logical Replication
- Online Node Replacement
- Logical Backup
- Physical Backup
- Automatic Job Retry upon Failure
- Ultimate RTO
- Cascaded Standby Server
- Delayed Replay
- Adding or Deleting a Standby Server
- Delaying Entering the Maximum Availability Mode
- Parallel Logical Decoding
- DCF
- CM
- Global SysCache
- Using a Standby Node to Build a Standby Node
- Maintainability
- Database Security
- Access Control Model
- Separation of Control and Access Permissions
- Database Encryption Authentication
- Data Encryption and Storage
- Database Audit
- Network Communication Security
- Resource Label
- Unified Audit
- Dynamic Data Anonymization
- Row-Level Access Control
- Password Strength Verification
- Equality Query in a Fully-encrypted Database
- Ledger Database Mechanism
- Transparent Data Encryption
- Enterprise-Level Features
- Support for Functions and Stored Procedures
- SQL Hints
- Full-Text Indexing
- Copy Interface for Error Tolerance
- Partitioning
- Support for Advanced Analysis Functions
- Materialized View
- HyperLogLog
- Creating an Index Online
- Autonomous Transaction
- Global Temporary Table
- Pseudocolumn ROWNUM
- Stored Procedure Debugging
- JDBC Client Load Balancing and Read/Write Isolation
- In-place Update Storage Engine
- Publication-Subscription
- Foreign Key Lock Enhancement
- Data Compression in OLTP Scenarios
- Transaction Async Submit
- Index Creation Parallel Control
- Dynamic Partition Pruning
- COPY Import Optimization
- SQL Running Status Observation
- BRIN Index
- BLOOM Index
- Application Development Interfaces
- AI Capabilities
- Middleware
- Installation Guide
- Installation Preparation
- Container Installation
- PTK-based Installation
- OM-based Installation
- Manual Installation
- Recommended Parameter Settings
- Administrator Guide
- Localization
- Routine Maintenance
- Starting and Stopping MogDB
- Using the gsql Client for Connection
- Routine Maintenance
- Checking OS Parameters
- Checking MogDB Health Status
- Checking Database Performance
- Checking and Deleting Logs
- Checking Time Consistency
- Checking The Number of Application Connections
- Routinely Maintaining Tables
- Routinely Recreating an Index
- Data Security Maintenance Suggestions
- Slow SQL Diagnosis
- Log Reference
- Primary and Standby Management
- MOT Engine
- Introducing MOT
- Using MOT
- Concepts of MOT
- Appendix
- Column-store Tables Management
- Backup and Restoration
- Importing and Exporting Data
- Importing Data
- Exporting Data
- Upgrade Guide
- AI Features Guide
- AI Features Overview
- AI4DB: Autonomous Database O&M
- DBMind Mode
- Components that Support DBMind
- AI Sub-functions of the DBMind
- X-Tuner: Parameter Tuning and Diagnosis
- Index-advisor: Index Recommendation
- AI4DB: Root Cause Analysis for Slow SQL Statements
- AI4DB: Trend Prediction
- SQLdiag: Slow SQL Discovery
- DB4AI: Database-driven AI
- AI in DB
- Intelligence Explain: SQL Statement Query Time Prediction
- Security Guide
- Developer Guide
- Application Development Guide
- Development Specifications
- Development Based on JDBC
- Overview
- JDBC Package, Driver Class, and Environment Class
- Development Process
- Loading the Driver
- Connecting to a Database
- Connecting to the Database (Using SSL)
- Running SQL Statements
- Processing Data in a Result Set
- Closing a Connection
- Managing Logs
- Example: Common Operations
- Example: Retrying SQL Queries for Applications
- Example: Importing and Exporting Data Through Local Files
- Example 2: Migrating Data from a MY Database to MogDB
- Example: Logic Replication Code
- Example: Parameters for Connecting to the Database in Different Scenarios
- JDBC API Reference
- java.sql.Connection
- java.sql.CallableStatement
- java.sql.DatabaseMetaData
- java.sql.Driver
- java.sql.PreparedStatement
- java.sql.ResultSet
- java.sql.ResultSetMetaData
- java.sql.Statement
- javax.sql.ConnectionPoolDataSource
- javax.sql.DataSource
- javax.sql.PooledConnection
- javax.naming.Context
- javax.naming.spi.InitialContextFactory
- CopyManager
- Development Based on ODBC
- Development Based on libpq
- Dependent Header Files of libpq
- Development Process
- Example
- Link Parameters
- libpq API Reference
- Database Connection Control Functions
- Database Statement Execution Functions
- Functions for Asynchronous Command Processing
- Functions for Canceling Queries in Progress
- Psycopg-Based Development
- Commissioning
- Stored Procedure
- User Defined Functions
- PL/pgSQL-SQL Procedural Language
- Scheduled Jobs
- Autonomous Transaction
- Logical Replication
- Foreign Data Wrapper
- Materialized View
- Materialized View Overview
- Full Materialized View
- Incremental Materialized View
- Partition Management
- Partition Pruning
- Recommendations For Choosing A Partitioning Strategy
- Application Development Guide
- Performance Tuning Guide
- System Optimization
- SQL Optimization
- WDR Snapshot
- Using the Vectorized Executor for Tuning
- TPC-C Performance Tunning Guide
- Reference Guide
- System Catalogs and System Views
- Overview of System Catalogs and System Views
- System Catalogs
- GS_ASP
- GS_AUDITING_POLICY
- GS_AUDITING_POLICY_ACCESS
- GS_AUDITING_POLICY_FILTERS
- GS_AUDITING_POLICY_PRIVILEGES
- GS_CLIENT_GLOBAL_KEYS
- GS_CLIENT_GLOBAL_KEYS_ARGS
- GS_COLUMN_KEYS
- GS_COLUMN_KEYS_ARGS
- GS_DB_PRIVILEGE
- GS_ENCRYPTED_COLUMNS
- GS_ENCRYPTED_PROC
- GS_GLOBAL_CHAIN
- GS_GLOBAL_CONFIG
- GS_MASKING_POLICY
- GS_MASKING_POLICY_ACTIONS
- GS_MASKING_POLICY_FILTERS
- GS_MATVIEW
- GS_MATVIEW_DEPENDENCY
- GS_MODEL_WAREHOUSE
- GS_OPT_MODEL
- GS_PACKAGE
- GS_POLICY_LABEL
- GS_RECYCLEBIN
- GS_TXN_SNAPSHOT
- GS_UID
- GS_WLM_EC_OPERATOR_INFO
- GS_WLM_INSTANCE_HISTORY
- GS_WLM_OPERATOR_INFO
- GS_WLM_PLAN_ENCODING_TABLE
- GS_WLM_PLAN_OPERATOR_INFO
- GS_WLM_SESSION_QUERY_INFO_ALL
- GS_WLM_USER_RESOURCE_HISTORY
- PG_AGGREGATE
- PG_AM
- PG_AMOP
- PG_AMPROC
- PG_APP_WORKLOADGROUP_MAPPING
- PG_ATTRDEF
- PG_ATTRIBUTE
- PG_AUTH_HISTORY
- PG_AUTH_MEMBERS
- PG_AUTHID
- PG_CAST
- PG_CLASS
- PG_COLLATION
- PG_CONSTRAINT
- PG_CONVERSION
- PG_DATABASE
- PG_DB_ROLE_SETTING
- PG_DEFAULT_ACL
- PG_DEPEND
- PG_DESCRIPTION
- PG_DIRECTORY
- PG_ENUM
- PG_EXTENSION
- PG_EXTENSION_DATA_SOURCE
- PG_FOREIGN_DATA_WRAPPER
- PG_FOREIGN_SERVER
- PG_FOREIGN_TABLE
- PG_HASHBUCKET
- PG_INDEX
- PG_INHERITS
- PG_JOB
- PG_JOB_PROC
- PG_LANGUAGE
- PG_LARGEOBJECT
- PG_LARGEOBJECT_METADATA
- PG_NAMESPACE
- PG_OBJECT
- PG_OPCLASS
- PG_OPERATOR
- PG_OPFAMILY
- PG_PARTITION
- PG_PLTEMPLATE
- PG_PROC
- PG_PUBLICATION
- PG_PUBLICATION_REL
- PG_RANGE
- PG_REPLICATION_ORIGIN
- PG_RESOURCE_POOL
- PG_REWRITE
- PG_RLSPOLICY
- PG_SECLABEL
- PG_SHDEPEND
- PG_SHDESCRIPTION
- PG_SHSECLABEL
- PG_STATISTIC
- PG_STATISTIC_EXT
- PG_SUBSCRIPTION
- PG_SYNONYM
- PG_TABLESPACE
- PG_TRIGGER
- PG_TS_CONFIG
- PG_TS_CONFIG_MAP
- PG_TS_DICT
- PG_TS_PARSER
- PG_TS_TEMPLATE
- PG_TYPE
- PG_USER_MAPPING
- PG_USER_STATUS
- PG_WORKLOAD_GROUP
- PGXC_CLASS
- PGXC_GROUP
- PGXC_NODE
- PGXC_SLICE
- PLAN_TABLE_DATA
- STATEMENT_HISTORY
- System Views
- DV_SESSION_LONGOPS
- DV_SESSIONS
- GET_GLOBAL_PREPARED_XACTS(Discarded)
- GS_AUDITING
- GS_AUDITING_ACCESS
- GS_AUDITING_PRIVILEGE
- GS_ASYNC_SUBMIT_SESSIONS_STATUS
- GS_CLUSTER_RESOURCE_INFO
- GS_DB_PRIVILEGES
- GS_FILE_STAT
- GS_GSC_MEMORY_DETAIL
- GS_INSTANCE_TIME
- GS_LABELS
- GS_LSC_MEMORY_DETAIL
- GS_MASKING
- GS_MATVIEWS
- GS_OS_RUN_INFO
- GS_REDO_STAT
- GS_SESSION_CPU_STATISTICS
- GS_SESSION_MEMORY
- GS_SESSION_MEMORY_CONTEXT
- GS_SESSION_MEMORY_DETAIL
- GS_SESSION_MEMORY_STATISTICS
- GS_SESSION_STAT
- GS_SESSION_TIME
- GS_SQL_COUNT
- GS_STAT_SESSION_CU
- GS_THREAD_MEMORY_CONTEXT
- GS_TOTAL_MEMORY_DETAIL
- GS_WLM_CGROUP_INFO
- GS_WLM_EC_OPERATOR_STATISTICS
- GS_WLM_OPERATOR_HISTORY
- GS_WLM_OPERATOR_STATISTICS
- GS_WLM_PLAN_OPERATOR_HISTORY
- GS_WLM_REBUILD_USER_RESOURCE_POOL
- GS_WLM_RESOURCE_POOL
- GS_WLM_SESSION_HISTORY
- GS_WLM_SESSION_INFO
- GS_WLM_SESSION_INFO_ALL
- GS_WLM_SESSION_STATISTICS
- GS_WLM_USER_INFO
- GS_WRITE_TERM_LOG
- MPP_TABLES
- PG_AVAILABLE_EXTENSION_VERSIONS
- PG_AVAILABLE_EXTENSIONS
- PG_COMM_DELAY
- PG_COMM_RECV_STREAM
- PG_COMM_SEND_STREAM
- PG_COMM_STATUS
- PG_CONTROL_GROUP_CONFIG
- PG_CURSORS
- PG_EXT_STATS
- PG_GET_INVALID_BACKENDS
- PG_GET_SENDERS_CATCHUP_TIME
- PG_GROUP
- PG_GTT_ATTACHED_PIDS
- PG_GTT_RELSTATS
- PG_GTT_STATS
- PG_INDEXES
- PG_LOCKS
- PG_NODE_ENV
- PG_OS_THREADS
- PG_PREPARED_STATEMENTS
- PG_PREPARED_XACTS
- PG_PUBLICATION_TABLES
- PG_REPLICATION_ORIGIN_STATUS
- PG_REPLICATION_SLOTS
- PG_RLSPOLICIES
- PG_ROLES
- PG_RULES
- PG_RUNNING_XACTS
- PG_SECLABELS
- PG_SESSION_IOSTAT
- PG_SESSION_WLMSTAT
- PG_SETTINGS
- PG_SHADOW
- PG_STAT_ACTIVITY
- PG_STAT_ACTIVITY_NG
- PG_STAT_ALL_INDEXES
- PG_STAT_ALL_TABLES
- PG_STAT_BAD_BLOCK
- PG_STAT_BGWRITER
- PG_STAT_DATABASE
- PG_STAT_DATABASE_CONFLICTS
- PG_STAT_REPLICATION
- PG_STAT_SUBSCRIPTION
- PG_STAT_SYS_INDEXES
- PG_STAT_SYS_TABLES
- PG_STAT_USER_FUNCTIONS
- PG_STAT_USER_INDEXES
- PG_STAT_USER_TABLES
- PG_STAT_XACT_ALL_TABLES
- PG_STAT_XACT_SYS_TABLES
- PG_STAT_XACT_USER_FUNCTIONS
- PG_STAT_XACT_USER_TABLES
- PG_STATIO_ALL_INDEXES
- PG_STATIO_ALL_SEQUENCES
- PG_STATIO_ALL_TABLES
- PG_STATIO_SYS_INDEXES
- PG_STATIO_SYS_SEQUENCES
- PG_STATIO_SYS_TABLES
- PG_STATIO_USER_INDEXES
- PG_STATIO_USER_SEQUENCES
- PG_STATIO_USER_TABLES
- PG_STATS
- PG_TABLES
- PG_TDE_INFO
- PG_THREAD_WAIT_STATUS
- PG_TIMEZONE_ABBREVS
- PG_TIMEZONE_NAMES
- PG_TOTAL_MEMORY_DETAIL
- PG_TOTAL_USER_RESOURCE_INFO
- PG_TOTAL_USER_RESOURCE_INFO_OID
- PG_USER
- PG_USER_MAPPINGS
- PG_VARIABLE_INFO
- PG_VIEWS
- PG_WLM_STATISTICS
- PGXC_PREPARED_XACTS
- PLAN_TABLE
- Functions and Operators
- Logical Operators
- Comparison Operators
- Character Processing Functions and Operators
- Binary String Functions and Operators
- Bit String Functions and Operators
- Mode Matching Operators
- Mathematical Functions and Operators
- Date and Time Processing Functions and Operators
- Type Conversion Functions
- Geometric Functions and Operators
- Network Address Functions and Operators
- Text Search Functions and Operators
- JSON/JSONB Functions and Operators
- HLL Functions and Operators
- SEQUENCE Functions
- Array Functions and Operators
- Range Functions and Operators
- Aggregate Functions
- Window Functions(Analysis Functions)
- Security Functions
- Ledger Database Functions
- Encrypted Equality Functions
- Set Returning Functions
- Conditional Expression Functions
- System Information Functions
- System Administration Functions
- Configuration Settings Functions
- Universal File Access Functions
- Server Signal Functions
- Backup and Restoration Control Functions
- Snapshot Synchronization Functions
- Database Object Functions
- Advisory Lock Functions
- Logical Replication Functions
- Segment-Page Storage Functions
- Other Functions
- Undo System Functions
- Statistics Information Functions
- Trigger Functions
- Hash Function
- Prompt Message Function
- Global Temporary Table Functions
- Fault Injection System Function
- AI Feature Functions
- Dynamic Data Masking Functions
- Other System Functions
- Internal Functions
- Global SysCache Feature Functions
- Data Damage Detection and Repair Functions
- Obsolete Functions
- Supported Data Types
- Numeric Types
- Monetary Types
- Boolean Types
- Enumerated Types
- Character Types
- Binary Types
- Date/Time Types
- Geometric
- Network Address Types
- Bit String Types
- Text Search Types
- UUID
- JSON/JSONB Types
- HLL
- Array Types
- Range
- OID Types
- Pseudo-Types
- Data Types Supported by Column-store Tables
- XML Types
- Data Type Used by the Ledger Database
- SQL Syntax
- ABORT
- ALTER AGGREGATE
- ALTER AUDIT POLICY
- ALTER DATABASE
- ALTER DATA SOURCE
- ALTER DEFAULT PRIVILEGES
- ALTER DIRECTORY
- ALTER EXTENSION
- ALTER FOREIGN TABLE
- ALTER FUNCTION
- ALTER GLOBAL CONFIGURATION
- ALTER GROUP
- ALTER INDEX
- ALTER LANGUAGE
- ALTER LARGE OBJECT
- ALTER MASKING POLICY
- ALTER MATERIALIZED VIEW
- ALTER PACKAGE
- ALTER PROCEDURE
- ALTER PUBLICATION
- ALTER RESOURCE LABEL
- ALTER RESOURCE POOL
- ALTER ROLE
- ALTER ROW LEVEL SECURITY POLICY
- ALTER RULE
- ALTER SCHEMA
- ALTER SEQUENCE
- ALTER SERVER
- ALTER SESSION
- ALTER SUBSCRIPTION
- ALTER SYNONYM
- ALTER SYSTEM KILL SESSION
- ALTER SYSTEM SET
- ALTER TABLE
- ALTER TABLE PARTITION
- ALTER TABLE SUBPARTITION
- ALTER TABLESPACE
- ALTER TEXT SEARCH CONFIGURATION
- ALTER TEXT SEARCH DICTIONARY
- ALTER TRIGGER
- ALTER TYPE
- ALTER USER
- ALTER USER MAPPING
- ALTER VIEW
- ANALYZE | ANALYSE
- BEGIN
- CALL
- CHECKPOINT
- CLEAN CONNECTION
- CLOSE
- CLUSTER
- COMMENT
- COMMIT | END
- COMMIT PREPARED
- CONNECT BY
- COPY
- CREATE AGGREGATE
- CREATE AUDIT POLICY
- CREATE CAST
- CREATE CLIENT MASTER KEY
- CREATE COLUMN ENCRYPTION KEY
- CREATE DATABASE
- CREATE DATA SOURCE
- CREATE DIRECTORY
- CREATE EXTENSION
- CREATE FOREIGN TABLE
- CREATE FUNCTION
- CREATE GROUP
- CREATE INCREMENTAL MATERIALIZED VIEW
- CREATE INDEX
- CREATE LANGUAGE
- CREATE MASKING POLICY
- CREATE MATERIALIZED VIEW
- CREATE MODEL
- CREATE OPERATOR
- CREATE PACKAGE
- CREATE PROCEDURE
- CREATE PUBLICATION
- CREATE RESOURCE LABEL
- CREATE RESOURCE POOL
- CREATE ROLE
- CREATE ROW LEVEL SECURITY POLICY
- CREATE RULE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE SERVER
- CREATE SUBSCRIPTION
- CREATE SYNONYM
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLE PARTITION
- CREATE TABLE SUBPARTITION
- CREATE TABLESPACE
- CREATE TEXT SEARCH CONFIGURATION
- CREATE TEXT SEARCH DICTIONARY
- 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 DATABASE
- DROP DATA SOURCE
- DROP DIRECTORY
- DROP EXTENSION
- DROP FOREIGN TABLE
- DROP FUNCTION
- DROP GLOBAL CONFIGURATION
- DROP GROUP
- DROP INDEX
- DROP LANGUAGE
- DROP MASKING POLICY
- DROP MATERIALIZED VIEW
- DROP MODEL
- DROP OPERATOR
- DROP OWNED
- DROP PACKAGE
- DROP PROCEDURE
- DROP PUBLICATION
- DROP RESOURCE LABEL
- DROP RESOURCE POOL
- DROP ROLE
- DROP ROW LEVEL SECURITY POLICY
- DROP RULE
- DROP SCHEMA
- DROP SEQUENCE
- DROP SERVER
- DROP SUBSCRIPTION
- DROP SYNONYM
- DROP TABLE
- DROP TABLESPACE
- DROP TEXT SEARCH CONFIGURATION
- DROP TEXT SEARCH DICTIONARY
- DROP TRIGGER
- DROP TYPE
- DROP USER
- DROP USER MAPPING
- DROP VIEW
- DROP WEAK PASSWORD DICTIONARY
- EXECUTE
- EXECUTE DIRECT
- EXPLAIN
- EXPLAIN PLAN
- FETCH
- GRANT
- INSERT
- LOCK
- MERGE INTO
- MOVE
- PREDICT BY
- PREPARE
- PREPARE TRANSACTION
- PURGE
- REASSIGN OWNED
- REFRESH INCREMENTAL MATERIALIZED VIEW
- REFRESH MATERIALIZED VIEW
- REINDEX
- RELEASE SAVEPOINT
- RESET
- REVOKE
- ROLLBACK
- ROLLBACK PREPARED
- ROLLBACK TO SAVEPOINT
- SAVEPOINT
- SELECT
- SELECT INTO
- SET
- SET CONSTRAINTS
- SET ROLE
- SET SESSION AUTHORIZATION
- SET TRANSACTION
- SHOW
- SHUTDOWN
- SNAPSHOT
- START TRANSACTION
- TIMECAPSULE TABLE
- TRUNCATE
- UPDATE
- VACUUM
- VALUES
- SQL Reference
- MogDB SQL
- Keywords
- Constant and Macro
- Expressions
- Type Conversion
- Full Text Search
- Introduction
- Tables and Indexes
- Controlling Text Search
- Additional Features
- Parser
- Dictionaries
- Configuration Examples
- Testing and Debugging Text Search
- Limitations
- System Operation
- Controlling Transactions
- DDL Syntax Overview
- DML Syntax Overview
- DCL Syntax Overview
- Appendix
- GUC Parameters
- GUC Parameter Usage
- GUC Parameter List
- File Location
- Connection and Authentication
- Resource Consumption
- Write Ahead Log
- HA Replication
- Memory Table
- Query Planning
- Error Reporting and Logging
- Alarm Detection
- Statistics During the Database Running
- Load Management
- Automatic Vacuuming
- Default Settings of Client Connection
- Lock Management
- Version and Platform Compatibility
- Faut Tolerance
- Connection Pool Parameters
- MogDB Transaction
- Developer Options
- Auditing
- SQL Mode
- Upgrade Parameters
- Miscellaneous Parameters
- Wait Events
- Query
- System Performance Snapshot
- Security Configuration
- Global Temporary Table
- HyperLogLog
- Scheduled Task
- Thread Pool
- User-defined Functions
- Backup and Restoration
- DCF Parameters Settings
- Flashback
- Rollback Parameters
- Reserved Parameters
- AI Features
- Global SysCache Parameters
- Appendix
- Schema
- Information Schema
- DBE_PERF
- Overview
- OS
- Instance
- Memory
- File
- Object
- STAT_USER_TABLES
- SUMMARY_STAT_USER_TABLES
- GLOBAL_STAT_USER_TABLES
- STAT_USER_INDEXES
- SUMMARY_STAT_USER_INDEXES
- GLOBAL_STAT_USER_INDEXES
- STAT_SYS_TABLES
- SUMMARY_STAT_SYS_TABLES
- GLOBAL_STAT_SYS_TABLES
- STAT_SYS_INDEXES
- SUMMARY_STAT_SYS_INDEXES
- GLOBAL_STAT_SYS_INDEXES
- STAT_ALL_TABLES
- SUMMARY_STAT_ALL_TABLES
- GLOBAL_STAT_ALL_TABLES
- STAT_ALL_INDEXES
- SUMMARY_STAT_ALL_INDEXES
- GLOBAL_STAT_ALL_INDEXES
- STAT_DATABASE
- SUMMARY_STAT_DATABASE
- GLOBAL_STAT_DATABASE
- STAT_DATABASE_CONFLICTS
- SUMMARY_STAT_DATABASE_CONFLICTS
- GLOBAL_STAT_DATABASE_CONFLICTS
- STAT_XACT_ALL_TABLES
- SUMMARY_STAT_XACT_ALL_TABLES
- GLOBAL_STAT_XACT_ALL_TABLES
- STAT_XACT_SYS_TABLES
- SUMMARY_STAT_XACT_SYS_TABLES
- GLOBAL_STAT_XACT_SYS_TABLES
- STAT_XACT_USER_TABLES
- SUMMARY_STAT_XACT_USER_TABLES
- GLOBAL_STAT_XACT_USER_TABLES
- STAT_XACT_USER_FUNCTIONS
- SUMMARY_STAT_XACT_USER_FUNCTIONS
- GLOBAL_STAT_XACT_USER_FUNCTIONS
- STAT_BAD_BLOCK
- SUMMARY_STAT_BAD_BLOCK
- GLOBAL_STAT_BAD_BLOCK
- STAT_USER_FUNCTIONS
- SUMMARY_STAT_USER_FUNCTIONS
- GLOBAL_STAT_USER_FUNCTIONS
- Workload
- Session/Thread
- SESSION_STAT
- GLOBAL_SESSION_STAT
- SESSION_TIME
- GLOBAL_SESSION_TIME
- SESSION_MEMORY
- GLOBAL_SESSION_MEMORY
- SESSION_MEMORY_DETAIL
- GLOBAL_SESSION_MEMORY_DETAIL
- SESSION_STAT_ACTIVITY
- GLOBAL_SESSION_STAT_ACTIVITY
- THREAD_WAIT_STATUS
- GLOBAL_THREAD_WAIT_STATUS
- LOCAL_THREADPOOL_STATUS
- GLOBAL_THREADPOOL_STATUS
- SESSION_CPU_RUNTIME
- SESSION_MEMORY_RUNTIME
- STATEMENT_IOSTAT_COMPLEX_RUNTIME
- LOCAL_ACTIVE_SESSION
- Transaction
- Query
- STATEMENT
- SUMMARY_STATEMENT
- STATEMENT_COUNT
- GLOBAL_STATEMENT_COUNT
- SUMMARY_STATEMENT_COUNT
- GLOBAL_STATEMENT_COMPLEX_HISTORY
- GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE
- GLOBAL_STATEMENT_COMPLEX_RUNTIME
- STATEMENT_RESPONSETIME_PERCENTILE
- STATEMENT_USER_COMPLEX_HISTORY
- STATEMENT_COMPLEX_RUNTIME
- STATEMENT_COMPLEX_HISTORY_TABLE
- STATEMENT_COMPLEX_HISTORY
- STATEMENT_WLMSTAT_COMPLEX_RUNTIME
- STATEMENT_HISTORY
- Cache/IO
- STATIO_USER_TABLES
- SUMMARY_STATIO_USER_TABLES
- GLOBAL_STATIO_USER_TABLES
- STATIO_USER_INDEXES
- SUMMARY_STATIO_USER_INDEXES
- GLOBAL_STATIO_USER_INDEXES
- STATIO_USER_SEQUENCES
- SUMMARY_STATIO_USER_SEQUENCES
- GLOBAL_STATIO_USER_SEQUENCES
- STATIO_SYS_TABLES
- SUMMARY_STATIO_SYS_TABLES
- GLOBAL_STATIO_SYS_TABLES
- STATIO_SYS_INDEXES
- SUMMARY_STATIO_SYS_INDEXES
- GLOBAL_STATIO_SYS_INDEXES
- STATIO_SYS_SEQUENCES
- SUMMARY_STATIO_SYS_SEQUENCES
- GLOBAL_STATIO_SYS_SEQUENCES
- STATIO_ALL_TABLES
- SUMMARY_STATIO_ALL_TABLES
- GLOBAL_STATIO_ALL_TABLES
- STATIO_ALL_INDEXES
- SUMMARY_STATIO_ALL_INDEXES
- GLOBAL_STATIO_ALL_INDEXES
- STATIO_ALL_SEQUENCES
- SUMMARY_STATIO_ALL_SEQUENCES
- GLOBAL_STATIO_ALL_SEQUENCES
- GLOBAL_STAT_DB_CU
- GLOBAL_STAT_SESSION_CU
- Utility
- REPLICATION_STAT
- GLOBAL_REPLICATION_STAT
- REPLICATION_SLOTS
- GLOBAL_REPLICATION_SLOTS
- BGWRITER_STAT
- GLOBAL_BGWRITER_STAT
- GLOBAL_CKPT_STATUS
- GLOBAL_DOUBLE_WRITE_STATUS
- GLOBAL_PAGEWRITER_STATUS
- GLOBAL_RECORD_RESET_TIME
- GLOBAL_REDO_STATUS
- GLOBAL_RECOVERY_STATUS
- CLASS_VITAL_INFO
- USER_LOGIN
- SUMMARY_USER_LOGIN
- GLOBAL_GET_BGWRITER_STATUS
- GLOBAL_SINGLE_FLUSH_DW_STATUS
- GLOBAL_CANDIDATE_STATUS
- Lock
- Wait Events
- Configuration
- Operator
- Workload Manager
- Global Plancache
- RTO
- DBE_PLDEBUGGER Schema
- Overview
- DBE_PLDEBUGGER.turn_on
- DBE_PLDEBUGGER.turn_off
- DBE_PLDEBUGGER.local_debug_server_info
- DBE_PLDEBUGGER.attach
- DBE_PLDEBUGGER.info_locals
- DBE_PLDEBUGGER.next
- DBE_PLDEBUGGER.continue
- DBE_PLDEBUGGER.abort
- DBE_PLDEBUGGER.print_var
- DBE_PLDEBUGGER.info_code
- DBE_PLDEBUGGER.step
- DBE_PLDEBUGGER.add_breakpoint
- DBE_PLDEBUGGER.delete_breakpoint
- DBE_PLDEBUGGER.info_breakpoints
- DBE_PLDEBUGGER.backtrace
- DBE_PLDEBUGGER.disable_breakpoint
- DBE_PLDEBUGGER.enable_breakpoint
- DBE_PLDEBUGGER.finish
- DBE_PLDEBUGGER.set_var
- DB4AI Schema
- DBE_PLDEVELOPER
- Tool Reference
- Tool Overview
- Client Tool
- Server Tools
- Tools Used in the Internal System
- mogdb
- gs_backup
- gs_basebackup
- gs_ctl
- gs_initdb
- gs_install
- gs_install_plugin
- gs_install_plugin_local
- gs_preinstall
- gs_sshexkey
- gs_tar
- gs_uninstall
- gs_upgradectl
- gs_expansion
- gs_dropnode
- gs_probackup
- gstrace
- kdb5_util
- kadmin.local
- kinit
- klist
- krb5kdc
- kdestroy
- pg_config
- pg_controldata
- pg_recvlogical
- pg_resetxlog
- pg_archivecleanup
- pssh
- pscp
- transfer.py
- Unified Database Management Tool
- FAQ
- Functions of MogDB Executable Scripts
- System Catalogs and Views Supported by gs_collector
- Extension Reference
- Error Code Reference
- Description of SQL Error Codes
- Third-Party Library Error Codes
- GAUSS-00001 - GAUSS-00100
- GAUSS-00101 - GAUSS-00200
- GAUSS 00201 - GAUSS 00300
- GAUSS 00301 - GAUSS 00400
- GAUSS 00401 - GAUSS 00500
- GAUSS 00501 - GAUSS 00600
- GAUSS 00601 - GAUSS 00700
- GAUSS 00701 - GAUSS 00800
- GAUSS 00801 - GAUSS 00900
- GAUSS 00901 - GAUSS 01000
- GAUSS 01001 - GAUSS 01100
- GAUSS 01101 - GAUSS 01200
- GAUSS 01201 - GAUSS 01300
- GAUSS 01301 - GAUSS 01400
- GAUSS 01401 - GAUSS 01500
- GAUSS 01501 - GAUSS 01600
- GAUSS 01601 - GAUSS 01700
- GAUSS 01701 - GAUSS 01800
- GAUSS 01801 - GAUSS 01900
- GAUSS 01901 - GAUSS 02000
- GAUSS 02001 - GAUSS 02100
- GAUSS 02101 - GAUSS 02200
- GAUSS 02201 - GAUSS 02300
- GAUSS 02301 - GAUSS 02400
- GAUSS 02401 - GAUSS 02500
- GAUSS 02501 - GAUSS 02600
- GAUSS 02601 - GAUSS 02700
- GAUSS 02701 - GAUSS 02800
- GAUSS 02801 - GAUSS 02900
- GAUSS 02901 - GAUSS 03000
- GAUSS 03001 - GAUSS 03100
- GAUSS 03101 - GAUSS 03200
- GAUSS 03201 - GAUSS 03300
- GAUSS 03301 - GAUSS 03400
- GAUSS 03401 - GAUSS 03500
- GAUSS 03501 - GAUSS 03600
- GAUSS 03601 - GAUSS 03700
- GAUSS 03701 - GAUSS 03800
- GAUSS 03801 - GAUSS 03900
- GAUSS 03901 - GAUSS 04000
- GAUSS 04001 - GAUSS 04100
- GAUSS 04101 - GAUSS 04200
- GAUSS 04201 - GAUSS 04300
- GAUSS 04301 - GAUSS 04400
- GAUSS 04401 - GAUSS 04500
- GAUSS 04501 - GAUSS 04600
- GAUSS 04601 - GAUSS 04700
- GAUSS 04701 - GAUSS 04800
- GAUSS 04801 - GAUSS 04900
- GAUSS 04901 - GAUSS 05000
- GAUSS 05001 - GAUSS 05100
- GAUSS 05101 - GAUSS 05200
- GAUSS 05201 - GAUSS 05300
- GAUSS 05301 - GAUSS 05400
- GAUSS 05401 - GAUSS 05500
- GAUSS 05501 - GAUSS 05600
- GAUSS 05601 - GAUSS 05700
- GAUSS 05701 - GAUSS 05800
- GAUSS 05801 - GAUSS 05900
- GAUSS 05901 - GAUSS 06000
- GAUSS 06001 - GAUSS 06100
- GAUSS 06101 - GAUSS 06200
- GAUSS 06201 - GAUSS 06300
- GAUSS 06301 - GAUSS 06400
- GAUSS 06401 - GAUSS 06500
- GAUSS 06501 - GAUSS 06600
- GAUSS 06601 - GAUSS 06700
- GAUSS 06701 - GAUSS 06800
- GAUSS 06801 - GAUSS 06900
- GAUSS 06901 - GAUSS 07000
- GAUSS 07001 - GAUSS 07100
- GAUSS 07101 - GAUSS 07200
- GAUSS 07201 - GAUSS 07300
- GAUSS 07301 - GAUSS 07400
- GAUSS 07401 - GAUSS 07480
- GAUSS 50000 - GAUSS 50999
- GAUSS 51000 - GAUSS 51999
- GAUSS 52000 - GAUSS 52999
- GAUSS 53000 - GAUSS 53699
- Error Log Reference
- System Catalogs and System Views
- Common Faults and Identification
- Common Fault Locating Methods
- Common Fault Locating Cases
- Core Fault Locating
- Permission/Session/Data Type Fault Location
- Service/High Availability/Concurrency Fault Location
- Table/Partition Table Fault Location
- File System/Disk/Memory Fault Location
- After You Run the du Command to Query Data File Size In the XFS File System, the Query Result Is Greater than the Actual File Size
- File Is Damaged in the XFS File System
- Insufficient Memory
- "Error:No space left on device" Is Displayed
- When the TPC-C is running and a disk to be injected is full, the TPC-C stops responding
- Disk Space Usage Reaches the Threshold and the Database Becomes Read-only
- SQL Fault Location
- Index Fault Location
- Source Code Parsing
- FAQs
- Glossary
- Mogeaver
Unified Database Management Tool
The cluster manager (CM) is a database management module. It supports customized resource monitoring and provides capabilities such as monitoring of the primary/standby database status, network communication faults, file system faults, and automatic primary/standby switchover upon faults. It also provides various database management capabilities, such as starting and stopping nodes and instances, querying database instance status, performing primary/standby switchover, and managing logs.
Note that in a scenario where there are one primary node and one standby node, the CM supports only basic capabilities, such as installation, startup, stop, and detection.
Features
cm_agent
cm_agent is a database management component deployed on each database host. It is used to start, stop, and monitor database instance processes.
It has the following functions:
- It starts and stops the instance processes deployed on the local host when the database instance is started or stopped.
- It monitors the instance status on the local host and sends the status to the CM server.
- It runs the commands delivered by the CM server after arbitration.
Command description:
-
Common options:
-
-V, --version
Prints the cm_agent version information and exits.
-
-?, -h,--help
Displays help information about cm_agent command parameters and exits.
-
-
Locations where the log information is recorded:
-
0
Recorded in specified log files.
-
1
Recorded in the syslog file.
-
2
Recorded in specified log files.
-
3
Empty file, that is, no log information is recorded.
-
-
Startup modes:
-
normal
Startup in normal mode.
-
abnormal
Startup in abnormal mode.
-
cm_server
cm_server is a component used for managing database instances and arbitrating instances. It has the following functions:
- Receives the status of each database instance from cm_agent on each node.
- Allows you to query the overall status of the database instances.
- Monitors instance status changes and delivers arbitration commands.
Command description:
-
Common options:
-
-V, --version
Prints the cm_server version information and exits.
-
-?, -h,--help
Displays help information about cm_server command parameters and exits.
-
-
Locations where the log information is recorded:
-
0
Recorded in specified log files.
-
1
Recorded in the syslog file.
-
2
Recorded in specified log files.
-
3
Empty file, that is, no log information is recorded.
-
Introduction to the cm_ctl Tool
cm_ctl is a tool provided by MogDB to control database instance services. This tool is called by O&M personnel for automatic database instance service restoration. The cm_ctl tool provides the following functions:
- Starts database instance services, all the instances in an AZ, all instances on a single host, or a single instance process.
- Stops database instance services, all instances in an AZ, all instances on a single host, or instance processes on a single node.
- Restarts the logical database instance service.
- Queries the database instance status or the status of a single host.
- Switches over the primary and standby instances or resets the instance status.
- Rebuilds the standby node.
- Views the database instance configuration file.
- Sets the log level, the arbitration mode of cm_server when one primary and multiple standby database instances are deployed, and the switchover mode between AZs.
- Obtains the log level, the arbitration mode of cm_server when one primary and multiple standby database instances are deployed, and the switchover mode between AZs.
- Checks the status of an instance process.
Files related to the cm_ctl tool:
-
cluster_manual_start
This is a flag file for starting and stopping a database instance. This file is stored in $GAUSSHOME**/bin**, where GAUSSHOME is an environment variable. When the database instance is started, the cm_ctl tool deletes the file. When the database instance is stopped, the cm_ctl tool generates the file and writes the stop mode to the file.
-
instance_manual_start_X (X indicates the instance ID.)
This is a flag file for starting and stopping a single instance. This file is stored in $GAUSSHOME**/bin**, where GAUSSHOME is an environment variable. When the instance is started, the cm_ctl tool deletes the file. When the instance is stopped, the cm_ctl tool generates the file and writes the stop mode to the file.
cm_ctl constraints:
- In cluster mode, the cm_ctl tool instead of the gs_ctl tool is used to switch the database role.
Command Description
Table 1 Parameters for option
Table 2 Common parameters
Displays help information about cm_ctl command parameters and exits. |
Table 3 Parameters for switchover
Table 4 Parameters for build
Table 5 Parameters for check
Specifies the name of a process, which can be cm_agent, gaussdb, or cm_server. |
|
Table 6 Parameters for stop
Table 7 Parameters for query
Table 8 Parameters for set
Table 10 Parameters for get
Table 11 Parameters for view
Table 12 Parameters for setrunmode
The value is a positive integer and cannot be greater than the total number of DCF copies. |
Table 13 Parameters for changerole
Changes the primary role to passive or follower in the DCF mode. |
Table 14 Parameters for changemember
Changes the primary role to passive or follower in the DCF mode. |
||
Table 15 Parameters for start
Table 16 Parameters for reload
Specifies the CM parameters to be loaded. If this parameter is not specified, the CM parameters cannot be loaded. |
|
Specifies whether to dynamically load cm_server or cm_agent parameters. |
Table 17 Parameters for list
Specifies the CM parameters to be listed. This parameter is mandatory. |
|
Specifies the cm_server or cm_agent parameters to be listed. This parameter is mandatory. |
Table 18 Parameters for encrypt
Specifies the encryption type. The value can be server or client. The default value is server. |
|
Table 19 Parameters for switch
Command Reference
-
Start an instance.
cm_ctl start [-z AVAILABILITY_ZONE [--cm_arbitration_mode=ARBITRATION_MODE]] | [-n NODEID [-D DATADIR]] [-t SECS]
-
Perform a switchover between primary and standby databases.
cm_ctl switchover [-z AVAILABILITY_ZONE] | [-n NODEID -D DATADIR [-f]] | [-a] | [-A] [-t SECS]
-
Stop the playback on all standby nodes, and forcibly promote one of the shards to primary.
cm_ctl finishredo
-
Rebuild the standby node.
cm_ctl build -n NODEID -D DATADIR [-t SECS] [-f] [-b full]
-
Check the running status of an instance process.
cm_ctl check -B BINNAME -T DATAPATH
-
Stop an instance.
cm_ctl stop [[-z AVAILABILITY_ZONE] | [-n NODEID [-D DATADIR [-R]]]] [-t SECS] [-m SHUTDOWN-MODE]
-
Query the cluster status.
cm_ctl query [-z ALL] [-l FILENAME] [-v [-C [-s] [-S] [-d] [-i] [-F] [-x] [-p]] | [-r]] [-t SECS] [--minorityAz=AZ_NAME]
-
View the cluster configuration file.
cm_ctl view [-v | -N | -n NODEID] [-l FILENAME]
-
Set parameters.
cm_ctl set [--log_level=LOG_LEVEL] [--cm_arbitration_mode=ARBITRATION_MODE] [--cm_switchover_az_mode=SWITCHOVER_AZ_MODE]
-
Set CM parameters.
cm_ctl set --param --agent | --server [-n NODEID] -k PARAMETER="'value'"
-
Obtain parameters.
cm_ctl get [--log_level] [--cm_arbitration_mode] [--cm_switchover_az_mode]
-
Set the number of DCF votes.
cm_ctl setrunmode -n NODEID -D DATADIR [[--xmode=normal] | [--xmode=minority --votenum=NUM]]
-
Change the DCF role information.
cm_ctl changerole [--role=PASSIVE | --role=FOLLOWER] -n NODEID -D DATADIR [-t SECS]
-
Change the attributes of the DCF node.
cm_ctl changemember [--role=PASSIVE | --role=FOLLOWER] [--group=xx] [--priority=xx] -n NODEID -D DATADIR [-t SECS]
-
Dynamically load CM parameters.
cm_ctl reload --param [--agent | --server]
-
List all CM parameters.
cm_ctl list --param [--agent | --server]
-
Perform encryption.
cm_ctl encrypt [-M MODE] -D DATADIR
-
Run the DCC command.
cm_ctl ddb DCC_CMD Set: cm_ctl ddb --put [key] [value] Delete: cm_ctl ddb --delete [key] View DCC command help information: cm_ctl ddb --help
-
Run the switch ddb command.
cm_ctl switch [--ddb_type=[DDB]] [--commit] [--rollback]
Security Design
Procedure for Manually Replacing Certificates
-
Create a self-signed certificate.
For details about how to create a self-signed certificate, see Generating Certificates.
To protect the private key password, use the cm encrypt tool. For details, see Introduction to the cm_ctl Tool.
Copy Codecm_ctl encrypt [-M MODE] -D DATADIR
-
Generate the server key factors server.key.cipher and server.key.rand.
Copy Codecm_ctl encrypt -M server -D DATADIR please enter the password: (The password must be the same as the protection password of the server private key.)
-
Generate the client key factors client.key.cipher and client.key.rand.
Copy Codecm_ctl encrypt -M client -D DATADIR please enter the password: (The password must be the same as the protection password of the client private key.)
-
Certificate Usage Guide
-
To use the certificate, you need to set the cm_server parameter to on (The default value is off).
Copy Codecm_ctl set --param --server -k enable_ssl="on"
-
The certificate file must exist in $GAUSSHOME**/share/sslcert/cm** on all nodes. After the certificate is replaced, restart the cluster for the certificate to take effect.
Required certificate files include server.crt, server.key, client.crt, client.key, cacert.pem, server.key.cipher, server.key.rand, client.key.cipher, and client.key.rand.
The permission on the root certificate, key, certificate, and encrypted key file should be 400. If the permission does not meet the requirements, SSL cannot be used.
- chmod 400 cacert.pem
- chmod 400 server.crt
- chmod 400 server.key
- chmod 400 server.key.cipher
- chmod 400 server.key.rand
- chmod 400 client.crt
- chmod 400 client.key
- chmod 400 client.key.cipher
- chmod 400 client.key.rand
-
The certificate validity period is checked every day, which can be set through ssl_cert_expire_check_interval. An alarm is generated when the certificate is about to expire in 90 days, which can be set through ssl_cert_expire_alert_threshold. (For details about the parameter, see ssl_cert_expire_alert_threshold.)
CM Parameters
You can view cm_agent parameters in the cm_agent.conf
file in the cm_agent data directory and cm_server parameters in the cm_server.conf
file in the cm_server data directory.
Parameters Related to cm_agent
log_dir
Parameter description: Specifies the directory where cm_agent logs are stored. It can be specified as an absolute path, or a path relative to $GAUSSLOG. When you set an absolute path using cm_ctl
, the path must be included in quotation marks, for example, cm_ctl set --param --agent -k log_dir="'/log/dir'".
Value range: a string with up to 1024 characters. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: log, indicating that the cm_agent logs are generated in the CM directory in $GAUSSLOG.
log_file_size
Parameter description: Specifies the size of a log file. If the size of the cm_agent-xx-current.log file exceeds the specified size, a new log file is created to record log information.
Value range: an integer, in the range [0,2047]. The actual value range is [1,2047]. The unit is MB. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 16 MB
log_min_messages
Parameter description: Specifies which message levels are written to the cm_agent log. A higher level covers the messages of all the lower levels. The lower the level is, the fewer messages will be written into the log.
Value range: enumerated type. Valid values are debug5, debug1, warning, error, log, and fatal (case-insensitive). Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: warning
incremental_build
Parameter description: Specifies whether a standby node is incrementally built. If this parameter is enabled, a standby node is incrementally rebuilt. Otherwise, a standby node is fully rebuilt.
Value range: Boolean. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
- on, yes, true, or 1: A standby node is incrementally rebuilt.
- off, no, false, or 0: A standby node is fully rebuilt.
Default value: on
security_mode
Parameter description: Specifies whether nodes are started in secure mode. If this parameter is enabled, nodes are started in secure mode. Otherwise, nodes are started in non-secure mode.
Value range: Boolean. The modification of this parameter takes effect dynamically. For details about how to modify the parameter, see Parameters for set cm.
- on, yes, true, or 1: Nodes are started in secure mode.
- off, no, false, or 0: Nodes are started in non-secure mode.
Default value: off
upgrade_from
Parameter description: Specifies the internal version number of the database before an in-place upgrade. Do not modify the value of this parameter.
Value range: a non-negative integer, in the range [0,4294967295]. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 0
alarm_component
Parameter description: Specifies the position of the alarm component that handles alarms if the first mode is used. When you set an absolute path using cm_ctl, the path must be included in quotation marks (''), for example, cm_ctl set --param --agent -k alarm_component="'/alarm/dir'".
Value range: a string with up to 1024 characters. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: /opt/huawei/snas/bin/snas_cm_cmd
alarm_report_interval
Parameter description: Specifies the interval at which an alarm is reported.
Value range: a non-negative integer, in the range [0,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1
agent_heartbeat_timeout
Parameter description: Specifies the time to wait before the cm_server heartbeat times out.
Value range: an integer, in the range [2,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 5
agent_connect_timeout
Parameter description: Specifies the time to wait before the attempt of cm_agent to connect to cm_server times out.
Value range: an integer, in the range [0,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1
agent_connect_retries
Parameter description: Specifies the number of times cm_agent tries to connect to cm_server.
Value range: an integer, in the range [0,2147483647]. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 15
agent_kill_instance_timeout
Parameter description: Specifies the interval from the time when cm_agent fails to connect to the primary cm_server to the time when cm_agent kills all instances on the node.
Value range: an integer, in the range [0,2147483647]. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 0, indicating that the operation of killing all instances on the node is not initiated.
agent_report_interval
Parameter description: Specifies the interval at which cm_agent reports the instance status.
Value range: an integer, in the range [0,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1
alarm_report_max_count
Parameter description: Specifies the maximum number of times an alarm is reported.
Value range: a non-negative integer, in the range [1,2592000]. The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1
agent_check_interval
Parameter description: Specifies the interval at which cm_agent queries the status of instances.
Value range: an integer, in the range [0,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 2
enable_log_compress
Parameter description: Specifies whether to enable log compression.
Value range: Boolean. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
- on, yes, true, or 1: Log compression is allowed.
- off, no, false, or 0:Log compression is not allowed.
Default value: on
process_cpu_affinity
Parameter description: Specifies whether to bind a primary node process to a CPU core before starting the process. If this parameter is set to 0, core binding is not performed. If it is set to another value, core binding is performed, and the number of physical CPU cores is 2n. Restart the database and cm_agent for any modification of this parameter to take effect. Only ARM is supported. For details about how to modify the parameter, see Parameters for set cm.
Value range: an integer, in the range [0,2].
Default value: 0
enable_xc_maintenance_mode
Parameter description: Specifies whether the pgxc_node system catalog can be modified when the database is in read-only mode.
Value range: Boolean. The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
- on, yes, true, or 1: The function of modifying the pgxc_node system catalog is enabled.
- off, no, false, or 0: The function of modifying the pgxc_node system catalog is disabled.
Default value: on
log_threshold_check_interval
Parameter description: Specifies the interval for compressing and clearing CM logs. The logs are compressed and cleared every 1800 seconds.
Application scope: $GAUSSLOG**/cm/cm_ctl**, $GAUSSLOG**/cm/cm_server**, files in the $GAUSSLOG**/cm/om_monitor** directory and log files prefixed with cm_agent-, system_call-, and system_alarm- in the $GAUSSLOG**/cm/cm_agent** directory
Value range: an integer, in the range [0,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1800
log_max_size
Parameter description: Specifies the maximum size of CM logs. When the total size of CM logs exceeds (value of log_max_size x 95⁄100) MB, historical compressed logs are deleted in sequence based on the log generation time until the total size is less than (value of log_max_size x 95⁄100) MB.
Application scope: $GAUSSLOG**/cm/cm_ctl**, $GAUSSLOG**/cm/cm_server**, files in the $GAUSSLOG**/cm/om_monitor** directory and log files prefixed with cm_agent-, system_call-, and system_alarm- in the $GAUSSLOG**/cm/cm_agent** directory
Value range: an integer, in the range [0,2147483647] (unit: MB). Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 10240
log_max_count
Parameter description: Specifies the maximum number of CM log files that can be stored. When the total number of CM log files exceeds the value of this parameter, compressed logs that have been stored for days longer than those specified by log_saved_days are deleted based on the name of the compressed log file.
Application scope: $GAUSSLOG**/cm/cm_ctl**, $GAUSSLOG**/cm/cm_server**, files in the $GAUSSLOG**/cm/om_monitor** directory and log files prefixed with cm_agent-, system_call-, and system_alarm- in the $GAUSSLOG**/cm/cm_agent** directory
Value range: an integer, in the range [0,10000]. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 10000
log_saved_days
Parameter description: Specifies the number of days for storing compressed CM log files. If the number of compressed CM log files exceeds the value of this parameter and the total number of CM log files exceeds the value of log_max_count, the compressed log files are deleted.
Application scope: $GAUSSLOG**/cm/cm_ctl**, $GAUSSLOG**/cm/cm_server**, files in the $GAUSSLOG**/cm/om_monitor** directory and log files prefixed with cm_agent-, system_call-, and system_alarm- in the $GAUSSLOG**/cm/cm_agent** directory
Value range: an integer, in the range [0,1000]. (unit: day). Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 90
agent_phony_dead_check_interval
Parameter description: Specifies the interval at which cm_agent checks whether a process is suspended.
Value range: an integer, in the range [0,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 10
unix_socket_directory
Parameter description: Specifies the directory location of the Unix socket. When you set an absolute path using cm_ctl, the path must be included in quotation marks (''), for example, cm_ctl set --param --agent -k unix_socket_directory="'/unix/dir'".
Value range: a string with up to 1024 characters. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: ''
dilatation_shard_count_for_disk_capacity_alarm
Parameter description: Specifies the number of shards to be added in the scale-out scenario. This parameter is used to calculate the threshold for reporting a disk capacity alarm.
Value range: an integer, in the range [0,2147483647]. If this parameter is set to 0, the disk scale-out alarm is not reported. If this parameter is set to a value greater than 0, the disk scale-out alarm is reported and the threshold is calculated based on the number of shards specified by this parameter. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1
enable_dcf
Parameter description: Specifies the status of the DCF mode.
Value range: Boolean. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
- on, yes, true, or 1: The DCF function is enabled.
- off, no, false, or 0:The DCF function is disabled.
Default value: off
disaster_recovery_type
Parameter description: Specifies the type of the DR relationship between primary and standby databases.
Value range: an integer, in the range [0,2]. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
- 0 indicates that no DR relationship is established.
- 1 indicates that the OBS DR relationship is established.
- 2 indicates that the streaming DR relationship is established.
Default value: 0
agent_backup_open
Parameter description: Specifies whether to enable the DR mode. After the DR mode is enabled, the CM runs in DR mode.
Value range: an integer, in the range [0,2]. Any modification of this parameter takes effect only after cm_agent is restarted. For details about how to modify the parameter, see Parameters for set cm.
- 0 indicates that no DR relationship is established.
- 1 indicates that the OBS DR relationship is established (not supported later versions).
- 2 indicates that the streaming DR relationship is established.
Default value: 0
Parameters Related to cm_server
log_dir
Parameter description: Specifies the directory where cm_server logs are stored. It can be specified as an absolute path, or a path relative to $GAUSSLOG. When you set an absolute path using cm_ctl
, the path must be included in quotation marks, for example, cm_ctl set --param --server -k log_dir="'/log/dir'".
Value range: a string with up to 1024 characters. Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: log, indicating that the cm_server logs are generated in the CM directory in $GAUSSLOG.
log_file_size
Parameter description: Specifies the size of a log file. If the size of the cm_server-xx-current.log file exceeds the specified size, a new log file is created to record log information.
Value range: an integer, in the range [0,2047]. The actual value range is [1,2047]. The unit is MB. Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 16 MB
log_min_messages
Parameter description: Specifies the message levels to be written to the cm_server log. A higher level covers the messages of all the lower levels. The lower the level is, the fewer messages will be written into the log.
Value range: enumerated type. Valid values are debug5, debug1, log, warning, error, and fatal (case-insensitive). Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: warning
thread_count
Parameter description: Specifies the number of threads in the cm_server thread pool.
Value range: an integer, in the range [2,1000]. Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1000
instance_heartbeat_timeout
Parameter description: Specifies the time to wait before the instance heartbeat times out.
Value range: an integer, in the range [1,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 6
instance_failover_delay_timeout
Parameter description: Specifies the delay in cm_server failover after the primary cm_server breakdown is detected.
Value range: an integer, in the range [0,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 0
cmserver_ha_connect_timeout
Parameter description: Specifies the time to wait before the connection between the primary cm_server and standby cm_server times out.
Value range: an integer, in the range [0,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 2
cmserver_ha_heartbeat_timeout
Parameter description: Specifies the time to wait before the heartbeat between the primary cm_server and standby cm_server times out.
Value range: an integer, in the range [1,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 6
cmserver_ha_status_interval
Parameter description: Specifies the interval between synchronizations of primary cm_server and standby cm_server status.
Value range: an integer, in the range [1,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1
cmserver_self_vote_timeout
Parameter description: Specifies the timeout interval for cm_server to vote for each other. This parameter is a legacy parameter and does not take effect.
Value range: an integer, in the range [0,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 6
phony_dead_effective_time
Parameter description: Specifies the maximum number of times a database node is detected as a zombie. If the number of times the node is detected as a zombie is greater than the specified value, a process on the node is considered to be a zombie and will be restarted.
Value range: an integer, in the range [1,2147483647]. Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 5
cm_server_arbitrate_delay_base_time_out
Parameter description: Specifies the basic delay duration for cm_server arbitration. If the primary cm_server is disconnected, the arbitration starts to be timed. If the disconnection duration exceeds the arbitration delay duration, a new primary cm_server will be selected. The arbitration delay duration is determined by the basic delay duration, the node index (server ID), and the incremental delay duration. The formula is as follows: Arbitration delay duration = Basic delay duration + Node index x Incremental delay duration
Value range: an integer, in the range [0,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 10
cm_server_arbitrate_delay_incremental_time_out
Parameter description: Specifies the incremental delay duration for cm_server arbitration. If the primary cm_server is disconnected, the arbitration starts to be timed. If the disconnection duration exceeds the arbitration delay duration, a new primary cm_server will be selected. The arbitration delay duration is determined by the basic delay duration, the node index (server ID), and the incremental delay duration. The formula is as follows: Arbitration delay duration = Basic delay duration + Node index x Incremental delay duration
Value range: an integer, in the range [0,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 3
alarm_component
Parameter description: Specifies the position of the alarm component that handles alarms if the first mode is used. For details about how to modify the parameter, see Parameters for set cm. When you set an absolute path using cm_ctl, the path must be included in quotation marks (''), for example, cm_ctl set --param --server -k alarm_component="'/alarm/dir'".
Value range: a string with up to 1024 characters. Any modification of this parameter takes effect only after cm_server is restarted.
Default value: /opt/huawei/snas/bin/snas_cm_cmd
alarm_report_interval
Parameter description: Specifies the interval at which an alarm is reported.
Value range: a non-negative integer, in the range [0,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 3
alarm_report_max_count
Parameter description: Specifies the maximum number of times an alarm is reported.
Value range: a non-negative integer, in the range [1,2592000]. The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1
instance_keep_heartbeat_timeout
Parameter description: cm_agent periodically checks the instance status and reports the status to cm_server. If the instance status cannot be detected for a long time and the accumulated number of times exceeds the value of this parameter, cm_server delivers a command to cm_agent to restart the instance.
Value range: an integer, in the range [0,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 40
az_switchover_threshold
Parameter description: If the failure rate of a node shard in an AZ (Number of faulty node shards/Total number of node shards x 100%) exceeds the specified value, automatic AZ switchover is triggered.
Value range: an integer, in the range [1,100]. The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 100
az_check_and_arbitrate_interval
Parameter description: Specifies the interval for checking the AZ status. If the status of an AZ is abnormal, automatic AZ switchover is triggered.
Value range: an integer, in the range [1,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 2
az_connect_check_interval
Parameter description: Specifies the interval at which the network connection between AZs is checked.
Value range: an integer, in the range [1,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 60
az_connect_check_delay_time
Parameter description: Specifies the delay between two retries to check the network connection between AZs.
Value range: an integer, in the range [1,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 150
cmserver_demote_delay_on_etcd_fault
Parameter description: Specifies the interval at which cm_server is demoted to standby due to unhealthy ETCD.
Value range: an integer, in the range [1,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 8
instance_phony_dead_restart_interval
Parameter description: Specifies the interval at which cm_agent restarts and kills a zombie database instance. The interval between two consecutive kill operations cannot be less than the value of this parameter. Otherwise, cm_agent does not deliver commands.
Value range: an integer, in the range [1800,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 21600
enable_transaction_read_only
Parameter description: Specifies whether a database is in read-only mode.
Value range: Boolean values on, off, true, false, yes, no, 1, and 0 The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: off
datastorage_threshold_check_interval
Parameter description: Specifies the interval for checking the disk usage. This interval is specified by the user.
Value range: an integer, in the range [1,2592000] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 10
datastorage_threshold_value_check
Parameter description: Specifies the usage threshold of a read-only disk in a database. When the disk usage of the data directory exceeds the specified value, the database is automatically set to read-only mode.
Value range: an integer, in the range [1,99]. The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 85
max_datastorage_threshold_check
Parameter description: Specifies the maximum interval for checking the disk usage. After you modify the enable_transaction_read_only parameter, the system automatically checks whether the disk usage reaches the threshold at the specified interval.
Value range: an integer, in the range [1,2592000] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 43200
enable_az_auto_switchover
Parameter description: Specifies whether to enable automatic AZ switchover. If this parameter is set to 1, cm_server automatically switches over services among AZs. Otherwise, when a node is faulty, services will not be automatically switched to another AZ even if the current AZ is unavailable. You can run the switchover command to manually switch services to another AZ.
Value range: a non-negative integer. The value 0 indicates that automatic AZ switchover is disabled, and the value 1 indicates that automatic AZ switchover is enabled. The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1
cm_krb_server_keyfile
Parameter description: Specifies the location of the key file on the Kerberos server. The value must be an absolute path. The file is usually stored in the ${GAUSSHOME}/kerberos directory and the file extension is keytab. The file name is the same as the name of the user who runs the cluster. This parameter is used together with cm_auth_method. If the value of the cm_auth_method parameter is changed to gss, cm_krb_server_keyfile must also be set to the corresponding path correctly. Otherwise, the cluster status will be affected. When you set an absolute path using cm_ctl, the path must be included in quotation marks (''), for example, cm_ctl set --param --server -k cm_krb_server_keyfile="'/krb/dir'".
Value range: a string. Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: ${GAUSSHOME}/kerberos/{Username}.keytab. The default value does not take effect and is used only for reference.
switch_rto
Parameter description: Specifies the delay for the forcible startup of cm_server. When force_promote
is set to 1 and a shard in the cluster does not have primary cm_server, the system starts timing. After the delay, the forcible startup logic starts to be executed.
Value range: an integer, in the range [60,2147483647] (unit: second). Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 600
force_promote
Parameter description: Specifies whether cm_server enables the forcible startup logic (that is, when the cluster status is unknown, ensure that the basic functions of the cluster are available at the cost of data loss). The value 0 indicates that forcible startup is disabled, and the value 1 indicates that forcible startup is enabled.
Value range: an integer, 0 or 1. Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 0
backup_open
Parameter description: Specifies whether to enable the DR cluster. After the DR cluster is enabled, the CM runs in DR cluster mode.
Value range: an integer, 0 or 1. Any modification of this parameter takes effect only after cm_server is restarted. This parameter cannot be enabled for non-DR clusters. For details about how to modify the parameter, see Parameters for set cm.
- 0: The DR cluster is disabled.
- 1: The DR cluster is enabled.
Default value: 0
enable_dcf
Parameter description: Specifies the status of the DCF mode.
Value range: Boolean. Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
- on, yes, true, or 1: The DCF function is enabled.
- off, no, false, or 0: The DCF function is disabled.
Default value: off
ddb_type
Parameter description: Specifies whether to switch between ETCD and DCC modes.
Value range: an integer. 0: specifies the ETCD mode; 1: specifies the DCC mode. Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1
NOTE: (MogDB supports only the DCC mode.)
enable_ssl
Parameter description: Specifies whether to enable SSL.
Value range: Boolean. After this function is enabled, the SSL certificate is used to encrypt communication. Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value:
-
on, yes, true, or 1: SSL is enabled.
-
off, no, false, or 0: SSL is disabled.
-
Default value: off
NOTICE: To ensure security, you are not advised to disable it. After this function is disabled, the CM does not use encrypted communication and all information is transmitted in plaintext, which may bring security risks such as eavesdropping, tampering, and spoofing.
ssl_cert_expire_alert_threshold
Parameter description: Specifies the SSL certificate expiration alarm time.
Value range: an integer, in the range [7,180] (unit: day). If the certificate expiration time is less than the value of this parameter, an alarm indicating that the certificate is about to expire is reported. The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 90
ssl_cert_expire_check_interval
Parameter description: Specifies the period for checking whether the SSL certificate expires.
Value range: an integer, in the range [0,2147483647] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 86400
ddb_log_level
Parameter description: Sets the DDB log level.
To disable the log function, set this parameter to NONE, which cannot be used together with the following log levels:
To enable the log function, set this parameter to one or a combination of the following log levels: RUN_ERR|RUN_WAR|RUN_INF|DEBUG_ERR|DEBUG_WAR|DEBUG_INF|TRACE|PROFILE|OPER. If two or more log levels are used together, separate them with vertical bars (|). The log level cannot be set to an empty string.
Value range: a string containing one or a combination of the following log levels: RUN_ERR|RUN_WAR|RUN_INF|DEBUG_ERR|DEBUG_WAR|DEBUG_INF|TRACE|PROFILE|OPER. The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: RUN_ERR|RUN_WAR|DEBUG_ERR|OPER|RUN_INF|PROFILE
ddb_log_backup_file_count
Parameter description: Specifies the maximum number of log files that can be saved.
Value range: an integer, in the range [1,100]. The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 10
ddb_max_log_file_size
Parameter description: Specifies the maximum number of bytes in a log.
Value range: a string with up to 1024 characters, in the range [1 MB,1000 MB]. The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 10M
ddb_log_suppress_enable
Parameter description: Specifies whether to enable the log suppression function.
Value range: an integer. 0: disabled; 1: enabled. The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 1
ddb_election_timeout
Parameter description: Specifies the DCC election timeout period.
Value range: an integer, in the range [1,600] (unit: second). The modification of this parameter takes effect after reloading. For details about how to modify the parameter, see Parameters for set cm.
Default value: 3
coordinator_heartbeat_timeout
Parameter description: Specifies the heartbeat timeout that triggers the automatical removal of faulty nodes. The setting of this parameter takes effect immediately, and you do not need to restart cm_server. If this parameter is set to 0, faulty nodes are not automatically removed.
Value range: an integer. The unit is second. For details about how to modify the parameter, see Parameters for set cm.
Default value: 25
cluster_starting_aribt_delay
Parameter description: Specifies the time that cm_server waits for a static primary-to-primary switchover during cluster startup.
Value range: an integer. The unit is second. Any modification of this parameter takes effect only after cm_server is restarted. For details about how to modify the parameter, see Parameters for set cm.
Default value: 180
enable_e2e_rto
Parameter description: Specifies whether to enable the E2E RTO function. After this function is enabled, the zombie detection period and network detection timeout time are shortened. The CM can reach the E2E RTO value (RTO for a single instance: ≤ 10s; RTO for overlay faults: ≤ 30s).
Value range: an integer, 0 or 1. 1: The function is enabled; 0: The function is disabled. For details about how to modify the parameter, see Parameters for set cm.
Default value: 0