OpenTenBase

https://docs.opentenbase.org/
Admin
OpenTenBase is an enterprise-grade distributed HTAP database providing high scalability, commercial...
Tokens:243,754
Snippets:1,361
Trust Score:6.4
Update:1 month ago
Show doc for...
Tokens:
Raw
### Start example cluster and enter opentenbaseCN container

Source: https://docs.opentenbase.org/guide/15-docker-deploy

Starts the example 1C2D cluster services and enters the opentenbaseCN container. Run from the example/1c_2d_cluster directory.

```bash
cd ${SOURCECODE_PATH}/example/1c_2d_cluster
docker-compose up -d
docker-compose exec opentenbaseCN /bin/bash
```

--------------------------------

### Initialize database and create shard table

Source: https://docs.opentenbase.org/guide/15-docker-deploy

SQL statements to set up the default node group, create a test database and user, and create a shard table. Detailed explanations are in the Quick Start guide.

```sql
-- 使用 dn001, dn002 存储节点组成默认存储组
create default node group default_group  with (dn001,dn002); 
create sharding group to group default_group;      -- 设置 shard 类型的表使用的存储组
create database test;                              -- 创建 test 数据库
create user test with password 'test';             -- 创建一个 test 用户密码为 test
alter database test owner to test;                 -- 修改 test 数据库 owner 为 test 用户
\c test test                                       -- 切换到 test 数据库
-- 创建一个 shard 表 foo, 使用 id 作为分布键
create table foo(id bigint, str text) distribute by shard(id);
insert into foo values(1, 'tencent'), (2, 'shenzhen');
select * from foo;
```

--------------------------------

### Compile and install OpenTenBase from source

Source: https://docs.opentenbase.org/guide/01-quickstart?q=

Compile and install OpenTenBase from source. This includes cloning the repository, configuring with the specified options, building, and installing the main and contrib components.

```bash
su - opentenbase
cd /data/opentenbase/
git clone https://github.com/OpenTenBase/OpenTenBase

export SOURCECODE_PATH=/data/opentenbase/OpenTenBase
export INSTALL_PATH=/data/opentenbase/install/

cd ${SOURCECODE_PATH}
rm -rf ${INSTALL_PATH}/opentenbase_bin_v5.0
chmod +x configure*
./configure --prefix=${INSTALL_PATH}/opentenbase_bin_v5.0 --enable-user-switch --with-libxml --disable-license --with-openssl --with-ossp-uuid CFLAGS="-g"
make clean
make -sj
make install
chmod +x contrib/pgxc_ctl/make_signature
cd contrib
make -sj
make install

```

--------------------------------

### Start TXSQL test server with ./mtr --start

Source: https://docs.opentenbase.org/guide/18-txsql_deploy?q=

Starts a MySQL test server using the MTR (MySQL Test Run) framework. Run this in the mysql-test directory after building TXSQL; it launches mysqld and initializes the test environment.

```bash
cd bld-release/mysql-test
./mtr --start

```

--------------------------------

### Install OpenTenBase cluster with opentenbase_ctl install

Source: https://docs.opentenbase.org/guide/01-quickstart

Run the opentenbase_ctl install command with the configuration file to install the cluster. The output shows the installation steps and success messages. After seeing 'Installation completed successfully', the installation is complete.

```shell
export LD_LIBRARY_PATH=/data/opentenbase/install/opentenbase_bin_v5.0/lib
./opentenbase_bin_v5.0/bin/opentenbase_ctl install  -c opentenbase_config.ini

====== Start to Install Opentenbase test_cluster01  ====== 

step 1: Make *.tar.gz pkg ...
    Make opentenbase-5.21.8-i.x86_64.tar.gz successfully.

step 2: Transfer and extract pkg to servers ...
    Package_path: /data/opentenbase/opentenbase_ctl/opentenbase-5.21.8-i.x86_64.tar.gz
    Transfer and extract pkg to servers successfully.

step 3: Install gtm master node ...
    Install gtm0001(172.16.16.49) ...
    Install gtm0001(172.16.16.49) successfully
    Success to install  gtm master node. 

step 4: Install cn/dn master node ...
    Install cn0001(172.16.16.49) ...
    Install dn0001(172.16.16.49) ...
    Install dn0002(172.16.16.131) ...
    Install cn0001(172.16.16.49) successfully
    Install dn0001(172.16.16.49) successfully
    Install dn0002(172.16.16.131) successfully
    Success to install all cn/dn master nodes. 

step 5: Install slave nodes ...
    Install gtm0002(172.16.16.131) ...
    Install cn0001(172.16.16.131) ...
    Install dn0002(172.16.16.49) ...
    Install gtm0002(172.16.16.131) successfully
    Install dn0002(172.16.16.49) successfully
    Install dn0001(172.16.16.131) successfully
    Install cn0001(172.16.16.131) successfully
    Success to install all slave nodes. 

step 6: Create node group ...
    Create node group successfully. 

====== Installation completed successfully  ====== 

```

--------------------------------

### Install opentenbase_subscription extension

Source: https://docs.opentenbase.org/guide/12-opentenbase_subscription?q=

Install the opentenbase_subscription extension on the CN of each cluster participating in multi-active replication. Execute on any CN of each cluster; both clusters need installation.

```sql
CREATE EXTENSION opentenbase_subscription;

```

--------------------------------

### Install opentenbase_ai with CASCADE

Source: https://docs.opentenbase.org/guide/23-opentenbase_ai?q=

Installs opentenbase_ai and its dependency pgsql-http in one command using CASCADE.

```sql
CREATE EXTENSION opentenbase_ai CASCADE;

```

--------------------------------

### Install and check OpenTenBase cluster with opentenbase_ctl

Source: https://docs.opentenbase.org/guide/01-quickstart?q=

Install the OpenTenBase cluster using opentenbase_ctl install with the configuration file opentenbase_config.ini. The output shows the installation steps and success message. After installation, check the cluster status with opentenbase_ctl status -c opentenbase_config.ini; the output lists all nodes as Running and provides the master CN connection info.

```shell
export LD_LIBRARY_PATH=/data/opentenbase/install/opentenbase_bin_v5.0/lib
./opentenbase_bin_v5.0/bin/opentenbase_ctl install  -c opentenbase_config.ini

====== Start to Install Opentenbase test_cluster01  ====== 

step 1: Make *.tar.gz pkg ...
    Make opentenbase-5.21.8-i.x86_64.tar.gz successfully.

step 2: Transfer and extract pkg to servers ...
    Package_path: /data/opentenbase/opentenbase_ctl/opentenbase-5.21.8-i.x86_64.tar.gz
    Transfer and extract pkg to servers successfully.

step 3: Install gtm master node ...
    Install gtm0001(172.16.16.49) ...
    Install gtm0001(172.16.16.49) successfully
    Success to install  gtm master node. 

step 4: Install cn/dn master node ...
    Install cn0001(172.16.16.49) ...
    Install dn0001(172.16.16.49) ...
    Install dn0002(172.16.16.131) ...
    Install cn0001(172.16.16.49) successfully
    Install dn0001(172.16.16.49) successfully
    Install dn0002(172.16.16.131) successfully
    Success to install all cn/dn master nodes. 

step 5: Install slave nodes ...
    Install gtm0002(172.16.16.131) ...
    Install cn0001(172.16.16.131) ...
    Install dn0001(172.16.16.131) ...
    Install dn0002(172.16.16.49) ...
    Install gtm0002(172.16.16.131) successfully
    Install dn0002(172.16.16.49) successfully
    Install dn0001(172.16.16.131) successfully
    Install cn0001(172.16.16.131) successfully
    Success to install all slave nodes. 

step 6: Create node group ...
    Create node group successfully. 

====== Installation completed successfully  ====== 

```

```shell
[opentenbase@VM-16-49-tencentos opentenbase_ctl]$ ./opentenbase_bin_v5.0/bin/opentenbase_ctl status -c opentenbase_config.ini

------------- Instance status -----------  
Instance name: test_cluster01
Version: 5.21.8

-------------- Node status --------------  
Node gtm0001(172.16.16.49) is Running 
Node dn0001(172.16.16.49) is Running 
Node dn0002(172.16.16.49) is Running 
Node cn0001(172.16.16.49) is Running 
Node dn0002(172.16.16.131) is Running 
Node cn0001(172.16.16.131) is Running 
Node gtm0002(172.16.16.131) is Running 
Node dn0001(172.16.16.131) is Running 
[Result] Total: 8, Running: 8, Stopped: 0, Unknown: 0

------- Master CN Connection Info -------  
[1] cn0001(172.16.16.49)  
Environment variable: export LD_LIBRARY_PATH=/data/opentenbase/install/opentenbase/5.21.8/lib  && export PATH=/data/opentenbase/install/opentenbase/5.21.8/bin:${PATH} 
PSQL connection: psql -h 172.16.16.49 -p 11000 -U opentenbase postgres 

```

--------------------------------

### Distribution key join with LIMIT optimization example

Source: https://docs.opentenbase.org/guide/09-problem-performance

Shows the setup and execution of a join with limit on distribution key columns in a sharded PostgreSQL environment. The query plan reveals a Merge Join with remote subquery scans on all data nodes, and the execution time is reported as 2976.008 ms. The example includes table creation, data insertion, analyze, and the EXPLAIN ANALYZE output.

```sql
--数据准备  
postgres=# CREATE TABLE t1(f1 serial not null unique,f2 text,f3 text,f4 text,f5 text,f6 text,f7 text,f8 text,f9 text,f10 text,f11 text,f12 text) distribute by shard(f1); 
NOTICE:  Replica identity is needed for shard table, please add to this table through "alter table" command.
CREATE TABLE
postgres=# CREATE TABLE t2(f1 serial not null unique,f2 text,f3 text,f4 text,f5 text,f6 text,f7 text,f8 text,f9 text,f10 text,f11 text,f12 text) distribute by shard(f1); 
NOTICE:  Replica identity is needed for shard table, please add to this table through "alter table" command.
CREATE TABLE
postgres=# insert into t1 select t,md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text) from generate_series(1,1000000) as t;
INSERT 0 1000000
postgres=# insert into t2 select t,md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text),md5(t::text) from generate_series(1,1000000) as t; 
INSERT 0 1000000
postgres=# analyze t1;
ANALYZE
postgres=# analyze t2;
ANALYZE
postgres=# 

postgres=# \timing 
Timing is on.
postgres=# explain  select t1.* from t1,t2 where t1.f1=t2.f1 limit 10;       
                                                                                         QUERY PLAN                                                                                         
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=0.25..1.65 rows=10 width=367) (actual time=2675.437..2948.199 rows=10 loops=1)
   ->  Merge Join  (cost=0.25..140446.26 rows=1000000 width=367) (actual time=2675.431..2675.508 rows=10 loops=1)
         Merge Cond: (t1.f1 = t2.f1)
         ->  Remote Subquery Scan on all (dn01,dn02,dn03,dn04,dn05,dn06,dn07,dn08,dn09,dn10)  (cost=100.12..434823.13 rows=1000000 width=367) (actual time=1.661..1.704 rows=10 loops=1)
         ->  Remote Subquery Scan on all (dn01,dn02,dn03,dn04,dn05,dn06,dn07,dn08,dn09,dn10)  (cost=100.12..71823.13 rows=1000000 width=4) (actual time=2673.761..2673.783 rows=10 loops=1)
 Planning time: 0.358 ms
 Execution time: 2973.948 ms
(7 rows)

Time: 2976.008 ms (00:02.976)
postgres=# 

```

--------------------------------

### Install pg_clean extension

Source: https://docs.opentenbase.org/guide/10-pg_clean

Installs the pg_clean extension on any primary CN. Run this before using the pg_clean functions.

```sql
CREATE EXTENSION pg_clean;

```

--------------------------------

### Join query example: p_cpu join server_physical_info

Source: https://docs.opentenbase.org/guide/17-txsql_architecture

Example query used to illustrate how the optimizer chooses between different join orders and index usage. The same logical result can be obtained by different execution plans, and the optimizer selects based on cost estimation.

```sql
select * from p_cpu join server_physical_info using(SvrAssetId) where p_cpu.SN = 'sn1' and server_physical_info.SvrIsSpecial=1;
```

--------------------------------

### 部署 OpenTenBase 插件

Source: https://docs.opentenbase.org/guide/14-kubeblocks-support?q=

使用 helm install 命令部署 OpenTenBase 插件。

```bash
$ helm install opentenbase ./opentenbase

```

--------------------------------

### Connect to OpenTenBase coordinator and run basic SQL

Source: https://docs.opentenbase.org/guide/01-quickstart?q=

Connects to the OpenTenBase coordinator node via psql, then creates a database, user, and table, inserts data, and queries it. The session output shows each command's result, including the COPY 2 confirmation and the final SELECT result.

```shell
export LD_LIBRARY_PATH=/home/opentenbase/install/opentenbase/5.21.8/lib  && export PATH=/home/opentenbase/install/opentenbase/5.21.8/bin:${PATH} 
$ psql -h ${CoordinateNode_IP} -p ${CoordinateNode_PORT} -U opentenbase -d postgres

postgres=# create database test;
CREATE DATABASE
postgres=# create user test with password 'test';
CREATE ROLE
postgres=# alter database test owner to test;
ALTER DATABASE
postgres=# \c test test
You are now connected to database "test" as user "test".
test=> create table foo(id bigint, str text) distribute by shard(id);
CREATE TABLE
test=> insert into foo values(1, 'tencent'), (2, 'shenzhen');
COPY 2
test=> select * from foo;
 id |   str    
----+----------
  1 | tencent
  2 | shenzhen
(2 rows)


```

--------------------------------

### Install PyMySQL for Python

Source: https://docs.opentenbase.org/guide/19-txsql_access

Installs PyMySQL for Python 3 (pip3) or Python 2 (pip). Required before using the Python PyMySQL example to connect to TXSQL.

```bash
## python3 
pip3 install PyMySQL
## python2
pip install pymysql


```

--------------------------------

### Install TXSQL build dependencies (yum)

Source: https://docs.opentenbase.org/guide/18-txsql_deploy?q=

Installs the build dependencies for compiling TXSQL on CentOS 7.8/7.9 or TencentOS Server. The first command installs general packages; the second installs the GCC 7 toolchain via Software Collections (SCL). Run these as root before starting the build.

```bash
yum install -y git ncurses-devel bison cmake3 libaio-devel openssl openssl-devel cyrus-sasl-devel openldap-devel gtest libtirpc-devel 

### gcc
yum install centos-release-scl -y
yum install devtoolset-7-gcc devtoolset-7-gcc-c++ devtoolset-7-binutils -y

```

--------------------------------

### 编译连接数据库程序

Source: https://docs.opentenbase.org/guide/02-access

编译conn.c并链接libpq库。需要指定OpenTenBase的include和lib路径。

```bash
gcc -c -I /usr/local/install/opentenbase_pgxz/include/ conn.c  
gcc -o conn conn.o -L /usr/local/install/opentenbase_pgxz/lib/ -lpq  

```

--------------------------------

### 创建数据表运行输出（go run createtable.go）

Source: https://docs.opentenbase.org/guide/02-access

运行创建数据表示例的输出，显示连接成功和创建数据表成功日志。

```bash
[root@VM_0_29_centos opentenbase]# go run createtable.go 
访问时间： 2018-04-03 20:50:24
日志级别： Log
详细信息： 连接数据库成功
访问时间： 2018-04-03 20:50:24
日志级别： Log
详细信息： 创建数据表成功
```

--------------------------------

### Install opentenbase_ai extension

Source: https://docs.opentenbase.org/guide/23-opentenbase_ai?q=

Installs the opentenbase_ai extension. Requires the HTTP extension to be installed first.

```sql
CREATE EXTENSION opentenbase_ai;

```

--------------------------------

### Create opentenbase user and configure sudo

Source: https://docs.opentenbase.org/guide/01-quickstart?q=

Create the 'opentenbase' user, set its password, add it to the appropriate sudo group (wheel for RedHat, sudo for Debian), and enable sudo via visudo.

```bash
# 1. 创建目录 /data
mkdir -p /data

# 2. 添加用户
useradd -d /data/opentenbase -s /bin/bash -m opentenbase # 添加用户 opentenbase

# 3. 设置密码
passwd opentenbase # 设置密码

# 4. 将用户添加到 wheel 组
# 对于 RedHat
usermod -aG wheel opentenbase
# 对于 Debian
usermod -aG sudo opentenbase

# 5. 为 wheel 组启用 sudo 权限（通过 visudo）
visudo 
# 然后取消注释 "% wheel" 行，保存并退出

```

--------------------------------

### 编译并运行连接数据库示例（go build conn.go）

Source: https://docs.opentenbase.org/guide/02-access

编译并运行连接数据库示例，输出与直接运行相同。

```bash
[root@VM_0_29_centos opentenbase]# go build conn.go 
[root@VM_0_29_centos opentenbase]# ./conn 
访问时间： 2018-04-03 20:40:48
日志级别： Log
详细信息： 连接数据库成功
```

--------------------------------

### 查看 pgxz 应用程序目录结构

Source: https://docs.opentenbase.org/guide/06-switching?q=

使用 ll 命令查看 /data/opentenbase/install/pgxz 目录下的内容，确认 bin、include、lib、share 子目录存在。

```bash
[opentenbase@VM_0_29_centos pgxz]$ ll /data/opentenbase/install/pgxz
total 4
drwxrwxr-x 2 pgxz pgxz 4096 Nov 10 04:33 bin
drwxrwxr-x 4 pgxz pgxz  189 Nov 10 04:33 include
drwxrwxr-x 4 pgxz pgxz  172 Nov 10 04:33 lib
drwxrwxr-x 3 pgxz pgxz   24 Oct  1 14:54 share
[opentenbase@VM_0_29_centos pgxz]$ 

```

--------------------------------

### Start dn02 datanode with pg_ctl

Source: https://docs.opentenbase.org/guide/05-component

Starts the dn02 datanode service using pg_ctl with the datanode role.

```shell
[opentenbase@VM_0_47_centos ~]# pg_ctl -Z datanode -D /data/opentenbase/data/pgxz/dn02 start

```

--------------------------------

### 编译建立数据表程序

Source: https://docs.opentenbase.org/guide/02-access

编译createtable.c并链接libpq库。

```bash
gcc -c -I /usr/local/install/opentenbase_pgxz/include/ createtable.c  
gcc -o createtable createtable.o -L /usr/local/install/opentenbase_pgxz/lib/ -lpq  

```

--------------------------------

### Start datanode with pg_ctl

Source: https://docs.opentenbase.org/guide/05-component?q=

Starts the datanode service using pg_ctl with the datanode role and the specified data directory.

```shell
[opentenbase@VM_0_29_centos ~]# pg_ctl -Z datanode -D /data/opentenbase/data/pgxz/dn01 start

```

--------------------------------

### 创建数据表（Go + pgx）

Source: https://docs.opentenbase.org/guide/02-access

在连接数据库后，执行CREATE TABLE语句创建分布式数据表，并输出创建成功日志。运行示例：go run createtable.go。

```go
package main

import (
    "fmt"
    "time"

    "github.com/jackc/pgx"
)

func main() {
    var error_msg string
    var sql string

    //连接数据库
    conn, err := db_connect()
    if err != nil {
        error_msg = "连接数据库失败，详情：" + err.Error()
        write_log("Error", error_msg)
        return
    }
    //程序运行结束时关闭连接
    defer conn.Close()
    write_log("Log", "连接数据库成功")

    //建立数据表
    sql = "create table public.opentenbase(id varchar(20),nickname varchar(100)) distribute by shard(id) to group  default_group;"
    _, err = conn.Exec(sql)
    if err != nil {
        error_msg = "创建数据表失败,详情：" + err.Error()
        write_log("Error", error_msg)
        return
    } else {
        write_log("Log", "创建数据表成功")
    }
}

/*
功能描述：写入日志处理

参数说明：
log_level -- 日志级别，只能是`Error`或`Log`
error_msg -- 日志内容

返回值说明：无
*/

func write_log(log_level string, error_msg string) {
    //打印错误信息
    fmt.Println("访问时间：", time.Now().Format("2006-01-02 15:04:05"))
    fmt.Println("日志级别：", log_level)
    fmt.Println("详细信息：", error_msg)
}

/*
功能描述：连接数据库

参数说明：无

返回值说明：
conn *pgx.Conn -- 连接信息
err error --错误信息

*/

func db_connect() (conn *pgx.Conn, err error) {
    var config pgx.ConnConfig
    config.Host = "127.0.0.1"    //数据库主机host或ip
    config.User = "opentenbase"         //连接用户
    config.Password = "pgsql"    //用户密码
    config.Database = "postgres" //连接数据库名
    config.Port = 15432          //端口号
    conn, err = pgx.Connect(config)
    return conn, err
}
```

--------------------------------

### Start cn02 coordinator service with pg_ctl

Source: https://docs.opentenbase.org/guide/05-component?q=

Starts the coordinator service for cn02 using pg_ctl with the coordinator role.

```shell
[opentenbase@VM_0_47_centos ~]# pg_ctl -Z coordinator -D /data/opentenbase/data/pgxz/cn02 start

```

--------------------------------

### Connect to TXSQL with Go GORM

Source: https://docs.opentenbase.org/guide/19-txsql_access

Go example using GORM with the MySQL driver to connect to TXSQL and query the first student record. Fill in the connection parameters (username, password, host, port, dbname). Note the code is incomplete (missing fmt import and port value) and uses db.close() instead of sqlDB.Close().

```go
package main

import (
"gorm.io/gorm"
"gorm.io/driver/mysql"
)

type Student struct{
    Name string
    Age int
}

func main(){

    // 配置 TXSQL 连接参数 
    username := ""  // 用户名
    password := ""  // 密码
    host := ""    // IP 地址
    port :=      // 端口
    dbname := ""  // 库名

    dsn := fmt.Sprintf("%s:%s@tcp(%s:%d)/%s?charset=utf8&parseTime=True&loc=Local", username, password, host, port, dbname)        
    db, err := gorm.Open(mysql.Open(dsn), &gorm.Config{}) 
    if err != nil { 
        panic("连接数据库失败, error=" + err.Error()) 
    }
    defer db.close()

    var stu Student
    db.First(&stu)
}


```

--------------------------------

### Drop idx_customer_date from orders

Source: https://docs.opentenbase.org/guide/20-txsql_basic?q=

Deletes the idx_customer_date index from the orders table. This example appears in the management examples section.

```sql
DROP INDEX idx_customer_date ON orders;
```

--------------------------------

### 创建 opentenbase 应用程序运行目录

Source: https://docs.opentenbase.org/guide/06-switching?q=

切换到 opentenbase 用户并创建应用程序安装目录 /data/opentenbase/install/pgxz。

```bash
[root@VM_0_29_centos pgxz]# su opentenbase  
[opentenbase@VM_0_29_centos install]$ mkdir -p /data/opentenbase/install/pgxz

```

--------------------------------

### Example: drop composite index on orders

Source: https://docs.opentenbase.org/guide/20-txsql_basic

Drops the idx_customer_date index from the orders table. This is the third example in the '示例' section.

```sql
DROP INDEX idx_customer_date ON orders;

```

--------------------------------

### 编译查询数据程序

Source: https://docs.opentenbase.org/guide/02-access

编译select.c，使用C99标准，并链接libpq库。

```bash
gcc -std=c99 -c -I /usr/local/install/opentenbase_pgxz/include/ select.c  
gcc -o select select.o -L /usr/local/install/opentenbase_pgxz/lib/ -lpq

```

--------------------------------

### Start dn02 data node

Source: https://docs.opentenbase.org/guide/05-component?q=

Start the dn02 data node service using pg_ctl with the datanode role and the data directory /data/opentenbase/data/pgxz/dn02.

```shell
[opentenbase@VM_0_29_centos ~]# pg_ctl -Z datanode -D /data/opentenbase/data/pgxz/dn02 start

```

--------------------------------

### 创建 OpenTenBase 集群

Source: https://docs.opentenbase.org/guide/14-kubeblocks-support?q=

使用 helm install 命令创建一个包含一个 GTM、一个 Coordinator 和两个 Datanode 的 OpenTenBase 集群。

```bash
$ helm install otb ./opentenbase-cluster

```

--------------------------------

### 连接数据库运行输出（go run conn.go）

Source: https://docs.opentenbase.org/guide/02-access

运行连接数据库示例的输出，显示连接成功日志。

```bash
[root@VM_0_29_centos opentenbase]# go run conn.go 
访问时间： 2018-04-03 20:40:28
日志级别： Log
详细信息： 连接数据库成功
```

--------------------------------

### Start dn01 data node

Source: https://docs.opentenbase.org/guide/05-component?q=

Start the dn01 data node service using pg_ctl with the datanode role and the data directory /data/opentenbase/data/pgxz/dn01.

```shell
[opentenbase@VM_0_47_centos ~]# pg_ctl -Z datanode -D /data/opentenbase/data/pgxz/dn01 start

```

--------------------------------

### Install dependencies with yum or apt

Source: https://docs.opentenbase.org/guide/01-quickstart?q=

Install the required build dependencies for OpenTenBase. The first command is for RedHat-based systems (yum), the second for Debian-based systems (apt).

```bash
yum -y install git sudo gcc make readline-devel zlib-devel openssl-devel uuid-devel bison flex cmake postgresql-devel libssh2-devel sshpass libcurl-devel libxml2-devel

```

```bash
apt install -y git sudo gcc make libreadline-dev zlib1g-dev libssl-dev libossp-uuid-dev bison flex cmake libssh2-1-dev sshpass libxml2-dev language-pack-zh-hans

```

--------------------------------

### Create composite index on orders

Source: https://docs.opentenbase.org/guide/20-txsql_basic?q=

Creates a composite index named idx_customer_date on the customer_id and order_date columns of the orders table. This example appears in the management examples section.

```sql
CREATE INDEX idx_customer_date ON orders (customer_id, order_date);
```
Tokens:
Raw