社区贡献 | 使用OpenTenBase命令行工具pgxc_ctl添加DN节点

PGXC monitor all
Running: gtm master
Running: gtm slave
Running: coordinator master cn001
Running: coordinator master cn002
Running: datanode master dn001
Running: datanode slave dn001
Running: datanode master dn002
复制

# 创建数据目录
mkdir -p data/opentenbase/data/dn003
mkdir -p data/opentenbase/install
chown -R opentenbase:opentenbase /data/opentenbase
# 创建 opentenbase 用户
useradd -d /data/opentenbase -s /bin/bash -m opentenbase
# 设置密码
passwd opentenbase
复制

[opentenbase]
$ vim ~/.bashrc
export OPENTENBASE_HOME=/data/opentenbase/install/opentenbase_bin_v2.6
export PATH=$OPENTENBASE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$OPENTENBASE_HOME/lib:${LD_LIBRARY_PATH}
export LC_ALL=C
复制

[opentenbase]
pgxc_ctl -c /data/opentenbase/pgxc_ctl/pgxc_ctl.conf
deploy 192.168.2.138
复制

# 生成 SSH 密钥对（如果还没有）
ssh-keygen -t rsa
# 将公钥复制到新的 DN 节点
ssh-copy-id -i ~/.ssh/id_rsa.pub opentenbase@192.168.2.138
复制

pgxc_ctl -c /data/opentenbase/pgxc_ctl/pgxc_ctl.conf
PGXC
add datanode master dn003 192.168.2.138 40004 20012 /data/opentenbase/data/dn003 none none none none
复制

[opentenbase]
pgxc_ctl -c /data/opentenbase/pgxc_ctl/pgxc_ctl.conf
PGXC
init datanode dn003
复制

[opentenbase]
pgxc_ctl -c /data/opentenbase/pgxc_ctl/pgxc_ctl.conf
PGXC
start datanode dn003
复制

[opentenbase]
pgxc_ctl -c /data/opentenbase/pgxc_ctl/pgxc_ctl.conf
PGXC
remove datanode master dn003 clean
复制

[opentenbase@db1 ~]$ psql -h 192.168.2.136 -p 30004 -d postgres -U opentenbase
psql (PostgreSQL 10.0 OpenTenBase V2)
Type "help" for help.
postgres=# select * from pgxc_node;
 node_name | node_type | node_port |   node_host   | nodeis_primary | nodeis_preferred |   node_id   |  node_cluster_name  
-----------+-----------+-----------+---------------+----------------+------------------+-------------+---------------------
 gtm       | G         |     50001 | 192.168.2.136 | t              | f                |   428125959 | opentenbase_cluster
 cn001     | C         |     30004 | 192.168.2.136 | f              | f                |  -264077367 | opentenbase_cluster
 cn002     | C         |     30004 | 192.168.2.137 | f              | f                |  -674870440 | opentenbase_cluster
 dn001     | D         |     40004 | 192.168.2.136 | t              | t                |  2142761564 | opentenbase_cluster
 dn002     | D         |     40004 | 192.168.2.137 | f              | f                |   -17499968 | opentenbase_cluster
 dn003     | D         |     40004 | 192.168.2.138 | f              | f                | -1956435056 | opentenbase_cluster
(6 rows)
复制