• About PolarDB-X
  • Key Features
    • High Availability and Disaster Recovery
    • Distributed Transactions
    • Distributed Linear Scalability
    • Compatibility with the MySQL Ecosystem
    • Global Secondary Index
    • HTAP
    • Capture Data Change(CDC)
  • Quick Start
    • PXD Quick Start
    • Deploy via PXD
    • Deploy via K8S
    • Build From Source Code
  • Deploy Production Cluster
    • Deploy Process
    • Hardware and Software Configuration
    • System Configuration
    • Download Software Package
    • Installing Docker and Image Repository
    • Installing Kubernetes
    • Database Deployment (Distributed Version)
      • Deploying with PXD
      • Deploying with Kubernetes
    • Database Deployment (Centralized Version)
      • Deploying with RPM
  • Performance White Paper
    • Performance White Paper (Centralized Version)
      • Sysbench Test Report
      • TPC-C Test Report
    • Performance White Paper (Distributed Version)
      • Sysbench Test Report
      • TPC-C Test Report
  • Developer Guide
    • Connect PolarDB-X
    • SQL syntax overview
    • Limits on database development
    • Data types
      • Numeric data types
      • String data types
      • Collation types
      • Date and time data types
      • JSON types
    • Operators
      • Logical operators
      • Arithmetic operators
      • Comparison operators
      • Bitwise operators
      • Assignment operators
      • Operator precedence
    • Functions
      • Sharding functions
        • HASH
        • STR_HASH
        • UNI_HASH
        • RANGE_HASH
        • RIGHT_SHIFT
        • MM
        • DD
        • YYYYDD
        • WEEK
        • MMDD
        • YYYYMM
        • YYYYWEEK
      • Date and time functions
      • String functions
      • Conversion functions
      • Aggregate functions
      • Mathematical functions
      • Comparison functions
      • Bit functions
      • Flow control functions
      • Information functions
      • Encryption functions and compression functions
      • Window functions
      • JSON functions
      • Other functions
    • DDL statements
      • Shading Syntax
        • CREATE DATABASE
        • DROP DATABASE
        • CREATE TABLE
        • DROP TABLE
        • ALTER TABLE
        • TRUNCATE TABLE
        • RENAME TABLE
        • CREATE INDEX
        • API Reference
        • CREATE VIEW
        • DROP VIEW
      • Partition Syntax
        • CREATE DATABASE
        • DROP DATABASE
        • CREATE TABLEGROUP
        • DROP TABLEGROUP
        • ALTER TABLEGROUP
        • CREATE TABLE
        • DROP TABLE
        • ALTER TABLE
        • TRUNCATE TABLE
        • RENAME TABLE
        • CREATE INDEX
        • API Reference
        • CREATE VIEW
        • DROP VIEW
    • DML statements
      • INSERT
      • REPLACE
      • UPDATE
      • DELETE
      • SOURCE
      • EXPORT
      • LOAD DATA
    • DQL statements
      • SELECT
      • Subqueries
      • GROUPING SETS, ROLLUP, and CUBE extensions
    • Data Access Language (DAL) statements
      • DDL management statements
        • SHOW DDL
        • SHOW DDL RESULT
        • CANCEL DDL
        • PAUSE DDL
        • CONTINUE DDL
      • SHOW
        • SHOW HELP
        • Rule and topology query statements
        • Slow SQL queries
        • Statistics queries
        • SHOW PROCESSLIST
        • SHOW GLOBAL INDEX
        • SHOW INDEX
        • SHOW METADATA LOCK
        • SHOW TABLEGROUP
      • SET
        • SET statement for setting variables
        • SET CHARACTER SET
        • SET NAMES
      • CHECK TABLE
      • CHECK GLOBAL INDEX
      • KILL
      • USE
      • EXPLAIN
      • SQL throttling
    • TCL statements
    • Prepared statements
    • Permission management
      • Manage accounts and permissions
      • Manage role permissions
      • Three-role Mode Overview
      • Permission management in the three-role mode
    • Replication
    • Sequence
      • Overview
      • Limits
      • Explicit Usage
        • Create Sequence
        • Alter Sequence
        • Query Sequence
        • Drop Sequence
      • Implicit Usage
        • CREATE TABLE
        • ALTER TABLE
        • Query Table And Sequence
    • Metadatabases and data dictionaries
    • Parameters
      • Parameters for compute node settings
      • Storage layer parameters
    • Transparent Sharding Mode
      • Primary Key Splitting
      • Clustered indexes
      • Change sharding rule(DRDS mode)
      • Change partitioning rule
    • FAQ
      • DDL FAQ
      • How to use global secondary indexes
      • How to use hints
      • How to specify a timeout period for an SQL statement
      • Specify database shards to execute SQL statements
      • Scan all or specific table shards in all or specific database shards
      • How to use INDEX hints
    • Error Codes
  • PolarDB-X Operator Operations Guide
    • Installation and Deployment
      • Installation
        • Modify Data Directory
        • Modify Default Image
        • Modify Default Image Repository
      • Uninstallation
      • Upgrade
    • PolarDB-X CRD API
      • PolarDBXCluster
      • XStore
    • Operations and Management
      • Lifecycle Management
        • Create Enterprise Edition Cluster
          • Cluster Topology Rule - Node Selector
          • Cluster Topology Rule - Stateless Node Rule (Compute, Log Node)
          • Cluster Topology Rule - Stateful Node Rule (GMS, Storage Node)
          • Cluster Topology Rule - Disaster Recovery Deployment Example
          • Container Host Network Mode
          • Minimal Deployment Mode (ShareGMS)
        • Setting Up a Standard Cluster
        • Creating Read-Only Clusters
        • Deleting
        • Updating
        • Upgrading
        • Scaling Out
        • Scaling In
        • Interrupting Operations/Rolling Back
          • Exceptional Cases
        • Handling Complex Operations
        • Managing Components
          • Operations and Maintenance for Compute Nodes
            • Checking Compute Node Status
            • Liveness and Availability Configuration
            • Accessing Compute Node Containers
            • Checking Compute Node Logs
            • Recreating Compute Nodes
      • Storage Node Operation and Maintenance
        • Check Node Status
        • Login to Internal Node
        • Retrieve Internal Node Logs
        • Get Storage Node Connection Information
        • Get Storage Node Task Information
        • Delete/Rebuild Internal Node
      • Log Node Operation and Maintenance
        • Create Log Node
        • Check Node Status
        • Login to Log Node Container
        • Delete and Rebuild Log Node
      • Connect to PolarDB-X Database
        • Get Username and Password
        • K8S In-cluster Connection
        • K8S Out-of-cluster Connection
        • Internet Connection
      • Database Parameter Settings
        • CN Static Parameters
        • CN Dynamic Parameters
          • Create Database Parameter Operation Object
          • Modify Database Parameters
          • Delete Database Parameter Operation Object
        • DN Parameters
        • Parameter Templates
        • Dynamic Parameters
      • Monitoring and Alerts
        • Install Monitoring Components
        • Create Monitoring Objects for Existing Clusters
        • View Monitoring
        • Configure Prometheus + Grafana
        • Alert Configuration
      • Log Collection
        • Log Collection
        • Log Fields
      • Backup and Restore
        • Backup Set Storage Configuration
        • Cluster Backup
        • Backup Scheduling
        • Incremental Log Backup
        • Cluster Restore
        • Point-In-Time Recovery
      • Standby Rebuild
        • Health Check
        • Rebuild Follower Node
        • Rebuild Learner Node
        • Rebuild Logger Node
    • FAQ
      • How to Obtain System Component Logs
      • Cluster Creation Stuck in 'Creating' Status
      • Cluster Deletion Stuck in 'Deleting' Status
      • No Leader for Storage Node
      • Pod Restarted Inccidentally
      • Pod Not in Running State
      • Dump Memory for Compute Node
      • Copy Core File for Storage Node
      • Get Flame Graph for Compute Node
      • Get Flame Graph for Storage Node
      • Pod Blocks in ImagePullBackOff State
      • Pod Restarts after Killing a Process
      • Get Logs from a Terminated Pod
      • How to Build an Image
      • How to Turn On/Off Private RPC
      • How to Modify Transaction Policy
      • How to Create One Replica Cluster
      • Port Conflicts in Host Network
  • Replication
    • Replication
    • Import
  • Operation and Maintenance Guide
    • Account and Permissions
      • Account Management
      • Role Management
      • Triple Authority
    • Parameter Settings
      • Compute Node Parameters
      • Data Node Parameters
      • Setting Parameters
    • Import and export data
      • Use mysqldump to migrate data
      • Use a program to import data
      • Use Batch Tool to export and import data
      • PolarDB-X CDC
        • Flink
        • Kafka
        • Elasticsearch
    • SQL Concurrency Control
    • Monitor
  • SQL Tuning Guide
    • SQL query optimization rules
    • SQL execution plans
    • Advanced SQL tuning
      • Query optimizers
      • Push down and rewrite queries
      • Introduction to the query executor
      • Optimize and execute JOIN operations
      • Optimize and execute subqueries
      • Optimize and execute aggregation operations
      • Optimize and execute sorting operators
      • Execution plan management
    • Intelligent index recommendation
    • Methods that are used to optimize slow queries
  • Best Practice
    • Configure a connection pool for an application to connect to a PolarDB-X instance
    • Identify and resolve database issues
    • Handle DDL exceptions
    • Analyze and optimize slow SQL queries
    • Throttle slow SQL requests
    • Asynchronously delete the data files associated with a large table
    • Update hot rows
    • Analyze and handle data skew
    • Use IN queries in an efficient manner
    • Optimize batch insert queries
    • Optimize data import and export
    • Optimize the way in which full data is extracted
    • Use blobs
    • Practice and optimization in high concurrency scenarios
    • Practice and optimization in analysis scenarios
    • Practice and optimization of HTAP
  • Tool kit
    • Importing and Exporting Data using Batch Tool
    • Using Benchmark Boot for Performance Testing
  • Published with GitBook
  • 浙公网安备 33011002016148号
  • 浙ICP备12022327号-1016

Managing Components

Component Management

Operations and Maintenance for Compute Nodes

  1. Checking Compute Node Status
  2. Liveness and Availability Configuration
  3. Accessing Compute Node Containers
  4. Checking Compute Node Logs
  5. Recreating Compute Nodes

Operations and Maintenance for Storage Nodes

  1. Checking Node Status
  2. Logging into Internal Nodes
  3. Retrieving Internal Node Logs
  4. Retrieving Storage Node Connection Information
  5. Retrieving Storage Node Task Information
  6. Deleting/Rebuilding Internal Nodes

Operations and Maintenance for Log Nodes

  1. Log Node Creation
  2. Checking Node Status
  3. Logging into Log Node Containers
  4. Rebuilding Log Nodes

results matching ""

    No results matching ""