OpenTenBase 分布式数据库集群：从部署到管理 - opentenbase_ctl 工具指南

# 使用 root 用户操作
sudo mkdir -p /data
sudo useradd -m -d /data/opentenbase -s /bin/bash opentenbase
sudo passwd opentenbase # 为 opentenbase 用户设置密码
​
# 将用户添加到 sudoers
sudo usermod -aG wheel opentenbase
echo "opentenbase ALL=(ALL) NOPASSWD: ALL" | sudo tee -a /etc/sudoers
​
# 创建数据存储目录
sudo mkdir -p /home/opentenbase/data/{gtm,coord,dn_m,dn_s}
sudo chown -R opentenbase:opentenbase /home/opentenbase/data
sudo chown -R opentenbase:opentenbase /data/opentenbase

# 切换到 opentenbase 用户
su - opentenbase
​
# 更新系统
sudo dnf update -y
​
# 安装基础依赖
sudo dnf install -y \
    gcc \
    gcc-c++ \
    make \
    cmake \
    readline-devel \
    zlib-devel \
    openssl-devel \
    uuid-devel \
    bison \
    flex \
    git \
    libcurl-devel \
    libxml2-devel \
    libxslt-devel \
    perl-IPC-Run \
    perl-Test-Simple \
    tcl-devel \
    python3-devel \
    rpm-build \
    pkgconfig \
    krb5-devel \
    openldap-devel \
    vim \
    libssh2-devel \
    sshpass

cd /tmp
wget https://github.com/facebook/zstd/releases/download/v1.5.2/zstd-1.5.2.tar.gz
tar -xzf zstd-1.5.2.tar.gz
cd zstd-1.5.2
​
# 编译安装到 /usr/local 目录
make -j$(nproc)
sudo make install PREFIX=/usr/local
​
# 更新系统的库缓存路径
sudo ldconfig

cd /tmp
wget https://github.com/lz4/lz4/archive/v1.9.4.tar.gz
tar -xzf v1.9.4.tar.gz
cd lz4-1.9.4
​
# 编译安装到 /usr/local 目录
make -j$(nproc)
sudo make install PREFIX=/usr/local
​
# 更新系统的库缓存路径
sudo ldconfig

sudo dnf install -y libxml2-devel libxml2
​
# 验证安装是否成功
xml2-config --version
xml2-config --cflags
xml2-config --libs

cd /tmp
git clone https://github.com/CLIUtils/CLI11.git
cd CLI11
mkdir build && cd build
cmake .. -DCLI11_TESTING=OFF -DCLI11_EXAMPLES=OFF
make -j$(nproc)
sudo make install

echo 'export SOURCECODE_PATH=/data/opentenbase/OpenTenBase' >> ~/.bashrc
echo 'export INSTALL_PATH=/data/opentenbase/install' >> ~/.bashrc
echo 'export PG_HOME=$INSTALL_PATH/opentenbase_bin_v5.0' >> ~/.bashrc
echo 'export PATH=$PG_HOME/bin:$PATH' >> ~/.bashrc
echo 'export LD_LIBRARY_PATH=$PG_HOME/lib:/usr/local/lib:$LD_LIBRARY_PATH' >> ~/.bashrc
echo 'export LC_ALL=C' >> ~/.bashrc
source ~/.bashrc

# 生成 SSH 密钥对
ssh-keygen -t rsa -b 4096 -f ~/.ssh/id_rsa -N ""
​
# 将公钥添加到 authorized_keys
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
chmod 600 ~/.ssh/authorized_keys
​
# 测试本地免密登录
ssh localhost date

# 关闭防火墙
sudo systemctl stop firewalld
sudo systemctl disable firewalld
​
# 关闭 SELinux
sudo setenforce 0
sudo sed -i 's/^SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config

mkdir -p $SOURCECODE_PATH
cd /data/opentenbase/
git clone https://github.com/OpenTenBase/OpenTenBase

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

cd ${INSTALL_PATH}/opentenbase_bin_v5.0
tar -zcf ${INSTALL_PATH}/opentenbase-5.21.8-i.x86_64.tar.gz *

# 实例配置
[instance]
name=opentenbase_cluster
type=distributed
package=/data/opentenbase/install/opentenbase-5.21.8-i.x86_64.tar.gz
​
# GTM 配置
[gtm]
master=192.168.1.101
slave=192.168.1.102
​
# 协调节点配置
[coordinators]
master=192.168.1.101,192.168.1.102
slave=192.168.1.103
nodes-per-server=1
​
# 数据节点配置
[datanodes]
primary=192.168.1.101,192.168.1.102
standby=192.168.1.103,192.168.1.104
nodes-per-server=1
​
# 服务器访问配置
[server]
ssh-user=opentenbase
ssh-password=your_password
ssh-port=22
​
# 端口配置
[port]
gtm=6666
coord=5432,5433
datanode=5434,5435,5436,5437
​
# 数据目录配置
[dir]
gtm=/home/opentenbase/data/gtm
coord=/home/opentenbase/data/coord
datanode=/home/opentenbase/data/dn_m,/home/opentenbase/data/dn_s
​
# 日志配置
[log]
level=INFO

cd $INSTALL_PATH
opentenbase_ctl generate -c opentenbase_config.ini

opentenbase_ctl install -c opentenbase_config.ini

opentenbase_ctl status -c opentenbase_config.ini

# 启动集群
opentenbase_ctl start -c opentenbase_config.ini
​
# 停止集群
opentenbase_ctl stop -c opentenbase_config.ini
​
# 重启集群
opentenbase_ctl restart -c opentenbase_config.ini
​
# 清理集群（删除数据文件）
opentenbase_ctl clean -c opentenbase_config.ini
​
# 重新初始化集群
opentenbase_ctl reinit -c opentenbase_config.ini

export LD_LIBRARY_PATH=$PG_HOME/lib
export PATH=$PG_HOME/bin:$PATH
 psql -h 127.0.0.1 -p 30004

-- 查看集群节点信息
SELECT * FROM pgxc_node;
​
-- 创建默认节点组和分片组
CREATE DEFAULT NODE GROUP default_group WITH (dn001);
CREATE SHARDING GROUP TO GROUP default_group;
​
-- 创建测试数据库和分布式表
CREATE DATABASE testdb;
\c testdb
​
CREATE TABLE dist_table (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    create_time TIMESTAMP DEFAULT NOW()
) DISTRIBUTE BY SHARD(id) TO GROUP default_group;
​
-- 插入和查询测试数据
INSERT INTO dist_table (name) VALUES ('测试数据1'), ('测试数据2'), ('测试数据3');
SELECT * FROM dist_table;
​
-- 查看数据分布情况
SELECT xc_node_id, COUNT(*) FROM dist_table GROUP BY xc_node_id;