GBase 8a
适配迁移
文章

以扩容的方式进行bclinux 7.6和euler 21.10混搭测试

发表于2024-04-25 09:54:06354次浏览0个评论

以扩容的方式进行bclinux 7.6和euler 21.10混搭测试

当前集群如下:

[gbase@node1 ~]$ gcadmin
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL

=================================================================
|             GBASE COORDINATOR CLUSTER INFORMATION             |
=================================================================
|   NodeName   |   IpAddress    | gcware | gcluster | DataState |
-----------------------------------------------------------------
| coordinator1 | 192.168.110.21 |  OPEN  |   OPEN   |     0     |
-----------------------------------------------------------------
=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |              192.168.110.21              |       2        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node4   |              192.168.110.24              |       2        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------


以上192.168.110.21和192.168.110.24为bclinux,重新安装成Euler操作系统的192.168.110.122和192.168.110.123

************************* data *************************
--------- 192.168.110.21---------
BigCloud Enterprise Linux release 7.6.1905 (Core)
--------- 192.168.110.24---------
BigCloud Enterprise Linux release 7.6.1905 (Core)
--------- 192.168.110.122---------
BigCloud Enterprise Linux For Euler release 21.10 (LTS-SP2)
--------- 192.168.110.123---------
BigCloud Enterprise Linux For Euler release 21.10 (LTS-SP2)
[gbase@node1 .ssh]$


把192.168.110.122扩容进去,作为混合节点。

提前编写demo.option

installPrefix= /opt
coordinateHost = 192.168.110.122
coordinateHostNodeID = 122
dataHost = 192.168.110.122
existCoordinateHost = 192.168.110.21
existDataHost = 192.168.110.21,192.168.110.24
dbaUser = gbase
dbaGroup = gbase
dbaPwd = 'gbase'
rootPwd = ''
#dbRootPwd = ''
#rootPwdFile = rootPwd.json


gcinstall.py安装脚本注释掉版本检查

   if IsExtendCluster():
       (currentVersion,gcwareTarPackageVersion) = GetCurVersionAndPackageVersion()
      # if currentVersion != gcwareTarPackageVersion:
       #    raise InstallError("current gcware version (%s) and package gcware version (%s) are not same."%(currentVersion,gcwareTarPackageVersion))

   if installOptions.license != "none":
    
    
gc和gn层都加上如下这个参数

skip_file_check=1

[gbase@node1 gcinstall]$ cpush data:3,4 SetSysEnv.py /opt/

./SetSysEnv.py --installPrefix=/opt --dbaUser=gbase

搞之前最后检查一下版本:
[gbase@node1 gcinstall]$ cat BUILDINFO
release_version = 9.5.2.45.7_patch.10.r1.2
revision = e4bf1dc154
os_ventor = centos8
arch = x86_64
build_version = release
license = none
install_revision: e4bf1dc154
autobuild_revision: e4bf1dc154
monit_revision: e4bf1dc154
gcrcman_revision: e4bf1dc154
corosync_revision: e4bf1dc154
gcware_revision: e4bf1dc154
gcluster_revision: e4bf1dc154
logCollector_revision: e4bf1dc154
GCMonit_revision: e4bf1dc154
gnode_revision: e4bf1dc154

停库:
[gbase@node1 gcinstall]$ cexec data:1,2 'gcluster_services all stop'

[gbase@node1 gcinstall]$ cexec data:1,2 'gcluster_services all info'

安装:
./gcinstall.py --silent=demo.options --timeout=3600 --generalDBUser=gbase --generalDBPwd=GBase2O11O531

安装日志报错少包:

2024-03-01 22:43:47,372-INFO 192.168.110.122 is
2024-03-01 22:43:52,409-ERROR cluster needs some rpms to running.
192.168.110.122: ncurses-compat-libs,libcom_err,python2-libs

mount -t iso9660 -o loop BCLinux-for-Euler-21.10-dvd-x86_64-230324.iso /mnt/
 

镜像中么有需要手工打

[root@Euler-node-22 rpms]#
[root@Euler-node-22 rpms]# rpm -ivh libcom_err-1.45.6-1.el8.x86_64.rpm --force --nodeps
警告:libcom_err-1.45.6-1.el8.x86_64.rpm: 头V3 RSA/SHA256 Signature, 密钥 ID 8483c65d: NOKEY
Verifying...                          ################################# [100%]
准备中...                          ################################# [100%]
正在升级/安装...
  1:libcom_err-1.45.6-1.el8          ################################# [100%]
[root@Euler-node-22 rpms]#
[root@Euler-node-22 rpms]# rpm -ivh ncurses-compat-libs-6.1-7.20180224.el8.x86_64.rpm --force --nodeps
警告:ncurses-compat-libs-6.1-7.20180224.el8.x86_64.rpm: 头V3 RSA/SHA256 Signature, 密钥 ID 8483c65d: NOKEY
Verifying...                          ################################# [100%]
准备中...                          ################################# [100%]
正在升级/安装...
  1:ncurses-compat-libs-6.1-7.2018022################################# [100%]
[root@Euler-node-22 rpms]#
[root@Euler-node-22 rpms]# rpm -ivh python2-libs-2.7.18-7.module_el8.5.0+894+1c54b371.x86_64.rpm --force --nodeps
警告:python2-libs-2.7.18-7.module_el8.5.0+894+1c54b371.x86_64.rpm: 头V3 RSA/SHA256 Signature, 密钥 ID 8483c65d: NOKEY
Verifying...                          ################################# [100%]
准备中...                          ################################# [100%]
正在升级/安装...
  1:python2-libs-2.7.18-7.module_el8.################################# [100%]
[root@Euler-node-22 rpms]#


再次安装,但是出现回退

具体报错如下:
192.168.110.21          install cluster on host 192.168.110.21 successfully.
192.168.110.122         install cluster on host 192.168.110.122 successfully.
update and sync configuration file...
Starting all gcluster nodes...
sync coordinator system tables ...
check database user and password ...
ERROR 1045 (28000): Access denied for user 'gbase'@'localhost' (using password: YES)

please enter database user(gbase) password:
ERROR 1045 (28000): Access denied for user 'gbase'@'localhost' (using password: YES)

please enter database user(gbase) password:
check database user and password successful
check rsync command status on available coordinator and new coordinator
use rsync command sync metadata

fail to execute gcadmin cpcorditbl coorHosts.xml
Fail to sync coordinator system tables.
extend gcluster failed,begin to restoring...
192.168.110.122         unInstall 192.168.110.122 successfully.
restore successfully,unInstalled nodes are ['192.168.110.122']

gcinstall日志如下:
user gbase dba_os_password '***' timeout '15' rsync_valid 1
generate sync command file
copy sync command file to available coordinator
execute sync gcluster metadata command on coordinator
check target coordinator metadata begin
check target coordinator metadata end
restart target coordinator gclusterd
restart gclusterd failed on node:['192.168.110.122']
sync coordinator metedata start ......
generate sync command file
copy sync command file to available coordinator
execute sync gcluster metadata command on coordinator
check target coordinator metadata begin
check target coordinator metadata end
restart target coordinator gclusterd
restart gclusterd failed on node:['192.168.110.122']
sync coordinator metedata start ......
generate sync command file
copy sync command file to available coordinator
execute sync gcluster metadata command on coordinator
check target coordinator metadata begin
check target coordinator metadata end
restart target coordinator gclusterd
restart gclusterd failed on node:['192.168.110.122']
sync coordinator metedata start ......
2024-03-01 23:24:05,427-ERROR fail to execute gcadmin cpcorditbl coorHosts.xml
2024-03-01 23:24:05,428-DEBUG stop all gcluster nodes...
2024-03-01 23:24:27,438-INFO 192.168.110.122: stop service successfully.
2024-03-01 23:24:35,669-INFO 192.168.110.21: stop service successfully.
2024-03-01 23:24:36,174-DEBUG extend gcluster failed,begin to restoring...
2024-03-01 23:24:36,207-DEBUG cat /opt/gcware/config/gcware.conf | grep memberaddr
2024-03-01 23:24:36,283-DEBUG Start StartUninstallThread...


122的systemlog日志如下:

240301 23:23:43 [Note] /opt/gcluster/server/bin/gclusterd: Shutdown complete

Error in GXianchengGlobalEnd(): 1 threads didn't exit
240301 23:23:49 [Note] ==================================
240301 23:23:49 [ERROR] Can't open shared library 'libmonit_info.so' (errno: 0 API version for INFORMATION SCHEMA plugin is too different)
240301 23:23:49 [Warning] Couldn't load plugin named 'MONIT_INFO' with soname 'libmonit_info.so'.
240301 23:23:49 [ERROR] Can't open shared library '/opt/gcluster/server/lib/gbase/plugin/libcluster_monit_info.so' (errno: 0 undefined symbol: _ZN15GCShowStatement7SetVcIdERKSs)
240301 23:23:49 [Warning] Couldn't load plugin named 'CLUSTER_MONIT_INFO' with soname 'libcluster_monit_info.so'.
240301 23:23:50 [ERROR] libfulltext_udf.la checksum wrong!
240301 23:23:50 [ERROR] libfulltext_udf.so.0.0.0 checksum wrong!
240301 23:23:50 [ERROR] libpyudf.la checksum wrong!
240301 23:23:50 [ERROR] libpyudf.so.0.0.0 checksum wrong!
240301 23:23:50 [ERROR] file check failed.
240301 23:23:50 [ERROR] Aborting

240301 23:23:59 [Note] /opt/gcluster/server/bin/gclusterd: Shutdown complete

Error in GXianchengGlobalEnd(): 1 threads didn't exit
240301 23:24:05 [Note] ==================================
240301 23:24:05 [ERROR] Can't open shared library 'libmonit_info.so' (errno: 0 API version for INFORMATION SCHEMA plugin is too different)
240301 23:24:05 [Warning] Couldn't load plugin named 'MONIT_INFO' with soname 'libmonit_info.so'.
240301 23:24:05 [ERROR] Can't open shared library '/opt/gcluster/server/lib/gbase/plugin/libcluster_monit_info.so' (errno: 0 undefined symbol: _ZN15GCShowStatement7SetVcIdERKSs)
240301 23:24:05 [Warning] Couldn't load plugin named 'CLUSTER_MONIT_INFO' with soname 'libcluster_monit_info.so'.
240301 23:24:06 [ERROR] libfulltext_udf.la checksum wrong!
240301 23:24:06 [ERROR] libfulltext_udf.so.0.0.0 checksum wrong!
240301 23:24:06 [ERROR] libpyudf.la checksum wrong!
240301 23:24:06 [ERROR] libpyudf.so.0.0.0 checksum wrong!
240301 23:24:06 [ERROR] file check failed.
240301 23:24:06 [ERROR] Aborting

240301 23:24:05 [ERROR] Can't open shared library 'libmonit_info.so' (errno: 0 API version for INFORMATION SCHEMA plugin is too different)


根据报systemlog错判断应该是 /opt/gcluster/server/lib/gbase/plugin 下面文件版本问题,两个操作系统一个是7的一个是8的

解压bundle.tar.bz2

tar -xvf bundle.tar.bz2

[gbase@node1 tmp20240301]$ cd /opt/setup/gcinstall/tmp20240301
[gbase@node1 tmp20240301]$ pwd
/opt/setup/gcinstall/tmp20240301
[gbase@node1 tmp20240301]$ ll
总用量 163892
-rw-r--r-- 1 gbase gbase   2261474 3月   1 23:49 bundle_data.tar.bz2
-rw-r--r-- 1 gbase gbase 165559708 3月   1 23:49 bundle.tar.bz2
drwxrwxr-x 3 gbase gbase        20 3月   1 23:50 gcluster
drwxrwxr-x 3 gbase gbase        20 3月   1 23:50 gnode
drwxr-xr-x 2 gbase gbase       325 2月  24 02:58 rpms
[gbase@node1 tmp20240301]$


[gbase@node1 tmp20240301]$ ll gcluster/server/lib/gbase/plugin/*.la
-rwxr-xr-x 1 gbase gbase 1272 2月  24 02:44 gcluster/server/lib/gbase/plugin/libauth_kerberos_client.la
-rwxr-xr-x 1 gbase gbase 1272 2月  24 02:44 gcluster/server/lib/gbase/plugin/libauth_kerberos_server.la
-rwxr-xr-x 1 gbase gbase 1184 2月  24 02:44 gcluster/server/lib/gbase/plugin/libcluster_monit_info.la
-rwxr-xr-x 1 gbase gbase 1148 2月  24 02:44 gcluster/server/lib/gbase/plugin/libfulltext_udf.la
-rwxr-xr-x 1 gbase gbase 1136 2月  24 02:44 gcluster/server/lib/gbase/plugin/libmonit_info.la
-rwxr-xr-x 1 gbase gbase 1117 2月  24 02:44 gcluster/server/lib/gbase/plugin/libpyudf.la
[gbase@node1 tmp20240301]$ ll gcluster/server/lib/gbase/plugin/*.so
lrwxrwxrwx 1 gbase gbase      32 2月  24 02:44 gcluster/server/lib/gbase/plugin/libauth_kerberos_client.so -> libauth_kerberos_client.so.0.0.0
lrwxrwxrwx 1 gbase gbase      32 2月  24 02:44 gcluster/server/lib/gbase/plugin/libauth_kerberos_server.so -> libauth_kerberos_server.so.0.0.0
lrwxrwxrwx 1 gbase gbase      30 2月  24 02:44 gcluster/server/lib/gbase/plugin/libcluster_monit_info.so -> libcluster_monit_info.so.0.0.0
lrwxrwxrwx 1 gbase gbase      24 2月  24 02:44 gcluster/server/lib/gbase/plugin/libfulltext_udf.so -> libfulltext_udf.so.0.0.0
-rwxr-xr-x 1 gbase gbase 5597816 2月  24 02:58 gcluster/server/lib/gbase/plugin/libgbmllib.so
lrwxrwxrwx 1 gbase gbase      22 2月  24 02:44 gcluster/server/lib/gbase/plugin/libmonit_info.so -> libmonit_info.so.0.0.0
lrwxrwxrwx 1 gbase gbase      17 2月  24 02:44 gcluster/server/lib/gbase/plugin/libpyudf.so -> libpyudf.so.0.0.0
-rwxr-xr-x 1 gbase gbase  348712 2月  24 02:58 gcluster/server/lib/gbase/plugin/libxgblib.so
[gbase@node1 tmp20240301]$


2024-03-02 00:30:28,648-INFO . /home/gbase/.gbase_profile;gcadmin cpcorditbl coorHosts.xml db_user_name gbase db_password '***' dba_os_user gbase dba_os_password '***' timeout '15' rsync_valid 1

generate sync command file
copy sync command file to available coordinator
execute sync gcluster metadata command on coordinator
check target coordinator metadata begin
check target coordinator metadata end
=====================================================================================
需要在检查完元数据后手工进行scp

scp gcluster/server/lib/gbase/plugin/*.la 192.168.110.122:/opt/gcluster/server/lib/gbase/plugin/
scp gcluster/server/lib/gbase/plugin/*.so 192.168.110.122:/opt/gcluster/server/lib/gbase/plugin/


scp gnode/server/lib/gbase/plugin/*.la 192.168.110.122:/opt/gnode/server/lib/gbase/plugin/
scp gnode/server/lib/gbase/plugin/*.so 192.168.110.122:/opt/gnode/server/lib/gbase/plugin/


=========================================================================================
第一次重启失败,然后scp后,gcinstall就正常了

2024-03-02 00:30:28,648-INFO . /home/gbase/.gbase_profile;gcadmin cpcorditbl coorHosts.xml db_user_name gbase db_password '***' dba_os_user gbase dba_os_password '***' timeout '15' rsync_valid 1

generate sync command file
copy sync command file to available coordinator
execute sync gcluster metadata command on coordinator
check target coordinator metadata begin
check target coordinator metadata end
restart target coordinator gclusterd
restart gclusterd failed on node:['192.168.110.122']
sync coordinator metedata start ......
generate sync command file
copy sync command file to available coordinator
execute sync gcluster metadata command on coordinator
check target coordinator metadata begin
check target coordinator metadata end
restart target coordinator gclusterd
sync coordinator metedata start ......
sync coordinator metedata end ......
sync coordinator metedata end,spend time 74180 ms......

2024-03-02 00:33:10,881-DEBUG rm -f coorHosts.xml
2024-03-02 00:33:10,888-DEBUG adding new datanodes to gcware...
2024-03-02 00:33:10,889-DEBUG /bin/chown -R gbase:gbase dataHosts.xml
2024-03-02 00:33:10,894-DEBUG id -nu
2024-03-02 00:33:15,906-DEBUG source /home/gbase/.gbase_profile;gcadmin addNodes /opt/setup/gcinstall/dataHosts.xml
2024-03-02 00:33:22,219-DEBUG rm -f dataHosts.xml
2024-03-02 00:33:22,228-INFO gcmonit restart on ['192.168.110.122']
2024-03-02 00:33:24,131-DEBUG Execute cmd: gcmonit.sh restart on 192.168.110.122.
2024-03-02 00:33:26,770-INFO ExtendCluster Successfully.


安装命令执行成功:

update and sync configuration file...
Starting all gcluster nodes...
sync coordinator system tables ...
check database user and password ...
ERROR 1045 (28000): Access denied for user 'gbase'@'localhost' (using password: YES)

please enter database user(gbase) password:
check database user and password successful
check rsync command status on available coordinator and new coordinator
use rsync command sync metadata
adding new datanodes to gcware...
ExtendCluster Successfully.

gcadmin显示正常:
[gbase@node1 gcinstall]$ gcadmin
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL

==================================================================
|             GBASE COORDINATOR CLUSTER INFORMATION              |
==================================================================
|   NodeName   |    IpAddress    | gcware | gcluster | DataState |
------------------------------------------------------------------
| coordinator1 | 192.168.110.21  |  OPEN  |   OPEN   |     0     |
------------------------------------------------------------------
| coordinator2 | 192.168.110.122 |  OPEN  |   OPEN   |     0     |
------------------------------------------------------------------
=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |              192.168.110.21              |       2        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node4   |              192.168.110.24              |       2        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node5   |             192.168.110.122              |                | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------

================
创建新的distribution,同时把192.168.110.24缩容出来。
[gbase@node1 gcinstall]$ cat gcChangeInfo.xml
<?xml version="1.0" encoding="utf-8"?>
<servers>
<rack>
 <node ip="192.168.110.122"/>
 <node ip="192.168.110.21"/>
</rack>
</servers>
[gbase@node1 gcinstall]$


NOTE: node [192.168.110.122] is coordinator node, it shall be data node too
please input parameter [dba_os_password password]
gcadmin generate distribution failed
[gbase@node1 gcinstall]$
[gbase@node1 gcinstall]$ gcadmin distribution gcChangeInfo.xml p 1 d 1 dba_os_password gbase
gcadmin generate distribution ...

NOTE: node [192.168.110.122] is coordinator node, it shall be data node too
check distribution 2 data node os password
check new distribution data node os password
copy system table to 192.168.110.122
gcadmin generate distribution successful

[gbase@node1 gcinstall]$


这个创建完成之后gbased起不来了,不知是元数据同步导致。

[gbase@Euler-node-22 ~]$ gcadmin
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL

==================================================================
|             GBASE COORDINATOR CLUSTER INFORMATION              |
==================================================================
|   NodeName   |    IpAddress    | gcware | gcluster | DataState |
------------------------------------------------------------------
| coordinator1 | 192.168.110.21  |  OPEN  |   OPEN   |     0     |
------------------------------------------------------------------
| coordinator2 | 192.168.110.122 |  OPEN  |   OPEN   |     0     |
------------------------------------------------------------------
=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |              192.168.110.21              |      2,3       | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node4   |              192.168.110.24              |       2        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node5   |             192.168.110.122              |       3        | CLOSE |    OPEN    |     0     |

 

重新scp gcadmin正常
scp gnode/server/lib/gbase/plugin/*.la 192.168.110.122:/opt/gnode/server/lib/gbase/plugin/
scp gnode/server/lib/gbase/plugin/*.so 192.168.110.122:/opt/gnode/server/lib/gbase/plugin/

===

初始化完成:

GBase client 9.5.2.45.7_patch.10350d612. Copyright (c) 2004-2024, GBase.  All Rights Reserved.

gbase> initnodedatamap;
Query OK, 1 row affected, 20 warnings (Elapsed: 00:00:00.80)

gbase> show warnings;


gbase> set global gcluster_rebalancing_concurrent_count=0
   -> ;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)

gbase>
gbase> rebalance instance;
Query OK, 8 rows affected (Elapsed: 00:00:00.25)

gbase>
gbase> use gclusterdb;
Query OK, 0 rows affected (Elapsed: 00:00:00.00)


gbase> select index_name,start_time,status,priority,distribution_id from rebalancing_status;
+------------------------------------+----------------------------+----------+----------+-----------------+
| index_name                         | start_time                 | status   | priority | distribution_id |
+------------------------------------+----------------------------+----------+----------+-----------------+
| tanshuang.tans_test_002            | 2024-03-02 01:23:42.079000 | STARTING |        5 |               3 |
| test.tan_load_test                 | 2024-03-02 01:23:42.079000 | STARTING |        5 |               3 |
| tanshuang.tans_test_003            | 2024-03-02 01:23:42.079000 | STARTING |        5 |               3 |
| test.test_sm3_encrypt              | 2024-03-02 01:23:42.079000 | STARTING |        5 |               3 |
| gclusterdb.audit_log_express       | 2024-03-02 01:23:42.122000 | STARTING |        5 |               3 |
| gclusterdb.import_audit_log_errors | 2024-03-02 01:23:42.122000 | STARTING |        5 |               3 |
| tanshuang.tans_test_001            | 2024-03-02 01:23:42.122000 | STARTING |        5 |               3 |
| tanshuang.tans_test_004            | 2024-03-02 01:23:42.122000 | STARTING |        5 |               3 |
+------------------------------------+----------------------------+----------+----------+-----------------+
8 rows in set (Elapsed: 00:00:00.03)

 

gbase> select index_name,start_time,status,priority,distribution_id from rebalancing_status;
+------------------------------------+----------------------------+-----------+----------+-----------------+
| index_name                         | start_time                 | status    | priority | distribution_id |
+------------------------------------+----------------------------+-----------+----------+-----------------+
| gclusterdb.audit_log_express       | 2024-03-02 01:26:42.712000 | COMPLETED |        5 |               3 |
| gclusterdb.import_audit_log_errors | 2024-03-02 01:26:42.478000 | COMPLETED |        5 |               3 |
| tanshuang.tans_test_001            | 2024-03-02 01:26:48.884000 | COMPLETED |        5 |               3 |
| tanshuang.tans_test_004            | 2024-03-02 01:26:51.433000 | COMPLETED |        5 |               3 |
| tanshuang.tans_test_002            | 2024-03-02 01:26:49.867000 | COMPLETED |        5 |               3 |
| test.tan_load_test                 | 2024-03-02 01:26:52.028000 | COMPLETED |        5 |               3 |
| tanshuang.tans_test_003            | 2024-03-02 01:26:53.761000 | COMPLETED |        5 |               3 |
| test.test_sm3_encrypt              | 2024-03-02 01:26:54.396000 | COMPLETED |        5 |               3 |
+------------------------------------+----------------------------+-----------+----------+-----------------+
8 rows in set (Elapsed: 00:00:00.03)


[gbase@node1 gcinstall]$ gcadmin
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL

==================================================================
|             GBASE COORDINATOR CLUSTER INFORMATION              |
==================================================================
|   NodeName   |    IpAddress    | gcware | gcluster | DataState |
------------------------------------------------------------------
| coordinator1 | 192.168.110.21  |  OPEN  |   OPEN   |     0     |
------------------------------------------------------------------
| coordinator2 | 192.168.110.122 |  OPEN  |   OPEN   |     0     |
------------------------------------------------------------------
=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |              192.168.110.21              |      2,3       | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node4   |              192.168.110.24              |       2        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node5   |             192.168.110.122              |       3        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------

删除老的DistributionId 2


[gbase@node1 gcinstall]$ gcadmin rmdistribution 2
cluster distribution ID [2]
it will be removed now
please ensure this is ok, input [Y,y] or [N,n]: y
select count(*) from gbase.nodedatamap where data_distribution_id=2 result is not 0
refreshnodedatamap drop 2 success
gcadmin remove distribution [2] success
[gbase@node1 gcinstall]$


从集群中删除节点信息:


[gbase@node1 gcinstall]$ vim gcChangeInfo.xml
[gbase@node1 gcinstall]$
[gbase@node1 gcinstall]$ cat gcChangeInfo.xml
<?xml version="1.0" encoding="utf-8"?>
<servers>
<rack>
 <node ip="192.168.110.24"/>
</rack>
</servers>
[gbase@node1 gcinstall]$ gcadmin rmnodes gcChangeInfo.xml
gcadmin remove nodes ...


gcadmin rmnodes from cluster success

[gbase@node1 gcinstall]$
[gbase@node1 gcinstall]$ gcadmin
CLUSTER STATE:         ACTIVE
VIRTUAL CLUSTER MODE:  NORMAL

==================================================================
|             GBASE COORDINATOR CLUSTER INFORMATION              |
==================================================================
|   NodeName   |    IpAddress    | gcware | gcluster | DataState |
------------------------------------------------------------------
| coordinator1 | 192.168.110.21  |  OPEN  |   OPEN   |     0     |
------------------------------------------------------------------
| coordinator2 | 192.168.110.122 |  OPEN  |   OPEN   |     0     |
------------------------------------------------------------------
=========================================================================================================
|                                    GBASE DATA CLUSTER INFORMATION                                     |
=========================================================================================================
| NodeName |                IpAddress                 | DistributionId | gnode | syncserver | DataState |
---------------------------------------------------------------------------------------------------------
|  node1   |              192.168.110.21              |       3        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------
|  node5   |             192.168.110.122              |       3        | OPEN  |    OPEN    |     0     |
---------------------------------------------------------------------------------------------------------

[gbase@node1 gcinstall]$

完成。

 

评论

登录后才可以发表评论