-
南大通用数据库-Gbase-8a-学习-04-部署分布式集群
一、环境
名称 值 cpu Intel® Core™ i5-1035G1 CPU @ 1.00GHz 操作系统 CentOS Linux release 7.9.2009 (Core) 内存 3G 逻辑核数 2 节点1-IP 192.168.142.10 节点2-IP 192.168.142.11 二、集群部署
1、解压安装包
[root@localhost pkg]# tar -xvf GBase8a_MPP_Cluster-NoLicense-8.6.2_build43-R33-132743-redhat7-x86_64.tar.bz2 gcinstall/ gcinstall/bundle_data.tar.bz2 gcinstall/InstallTar.py gcinstall/license.txt gcinstall/CorosyncConf.py gcinstall/gbase_data_timezone.sql gcinstall/CGConfigChecker.py gcinstall/gcinstall.py gcinstall/cluster.conf gcinstall/Restore.py gcinstall/unInstall.py gcinstall/fulltext.py gcinstall/InstallFuns.py gcinstall/extendCfg.xml gcinstall/bundle.tar.bz2 gcinstall/BUILDINFO gcinstall/GetOSType.py gcinstall/RestoreLocal.py gcinstall/FileCheck.py gcinstall/rmt.py gcinstall/dependRpms gcinstall/demo.options gcinstall/rootPwd.json gcinstall/example.xml gcinstall/pexpect.py gcinstall/replace.py gcinstall/SSHThread.py gcinstall/loginUserPwd.json- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
2、配置demo.options
[root@localhost pkg]# cd gcinstall/ [root@localhost gcinstall]# ll 总用量 93016 -rw-r--r--. 1 gbase gbase 292 12月 17 2021 BUILDINFO -rw-r--r--. 1 root root 2249884 12月 17 2021 bundle_data.tar.bz2 -rw-r--r--. 1 root root 87478657 12月 17 2021 bundle.tar.bz2 -rw-r--r--. 1 gbase gbase 1951 12月 17 2021 CGConfigChecker.py -rw-r--r--. 1 gbase gbase 309 12月 17 2021 cluster.conf -rwxr-xr-x. 1 gbase gbase 4167 12月 17 2021 CorosyncConf.py -rw-r--r--. 1 gbase gbase 434 12月 17 2021 demo.options -rw-r--r--. 1 root root 154 12月 17 2021 dependRpms -rw-r--r--. 1 gbase gbase 684 12月 17 2021 example.xml -rwxr-xr-x. 1 gbase gbase 419 12月 17 2021 extendCfg.xml -rw-r--r--. 1 gbase gbase 781 12月 17 2021 FileCheck.py -rw-r--r--. 1 gbase gbase 2700 12月 17 2021 fulltext.py -rw-r--r--. 1 gbase gbase 4818440 12月 17 2021 gbase_data_timezone.sql -rwxr-xr-x. 1 gbase gbase 76282 12月 17 2021 gcinstall.py -rwxr-xr-x. 1 gbase gbase 3362 12月 17 2021 GetOSType.py -rw-r--r--. 1 gbase gbase 156505 12月 17 2021 InstallFuns.py -rw-r--r--. 1 gbase gbase 237364 12月 17 2021 InstallTar.py -rw-r--r--. 1 gbase gbase 1114 12月 17 2021 license.txt -rwxr-xr-x. 1 gbase gbase 296 12月 17 2021 loginUserPwd.json -rwxr-xr-x. 1 gbase gbase 75990 12月 17 2021 pexpect.py -rwxr-xr-x. 1 gbase gbase 25093 12月 17 2021 replace.py -rw-r--r--. 1 gbase gbase 1715 12月 17 2021 RestoreLocal.py -rwxr-xr-x. 1 gbase gbase 6622 12月 17 2021 Restore.py -rw-r--r--. 1 gbase gbase 7312 12月 17 2021 rmt.py -rwxr-xr-x. 1 gbase gbase 296 12月 17 2021 rootPwd.json -rw-r--r--. 1 gbase gbase 2717 12月 17 2021 SSHThread.py -rwxr-xr-x. 1 gbase gbase 21710 12月 17 2021 unInstall.py [root@localhost gcinstall]# vim demo.options [root@localhost gcinstall]# cat demo.options installPrefix= /opt coordinateHost = 192.168.142.10,192.168.142.11 #coordinateHostNodeID = 234,235,237 dataHost = 192.168.142.10,192.168.142.11 #existCoordinateHost = #existDataHost = loginUser= root loginUserPwd = 'qwer1234' #loginUserPwdFile = loginUserPwd.json dbaUser = gbase dbaGroup = gbase dbaPwd = 'gbase' rootPwd = 'qwer1234' #rootPwdFile = rootPwd.json dbRootPwd = '' #mcastAddr = 226.94.1.39 mcastPort = 5493- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
参数名 描述 installPrefix 指定安装目录。 coordinateHost 所有 coordinator 节点 IP 列表，IP 地址之间用“,”分隔。 coordinateHostNodeID 支持对 IPV6 地址的输入，当集群节点为 IPV4 地址，则该参数无效，可不用设置；当集群节点为 IPV6 地址，则用户必须手动设置该参数，该参数为若干个正整数，需要与 coordinateHost 中的 IP 一一对应，用逗号隔开。例如：coordinateHostNodeID = 1,2,3。 existCoordinateHost 所有已存在的 coordinator 节点 IP 列表，IP 地址之间用“,”分隔。 existDataHost 所有已存在的 data 节点 IP 列表，IP 地址之间用“,”分隔。 loginUser 通过该用户 ssh 到集群各节点，再 su 切换到 root 用户执行命令，该参数必须使用。默认用户为 root。该用户所属用户组必须也是 loginUser。 loginUserPwd 表示用户 loginUser 在集群节点密码相同的方式； loginUserPwdFile 表示支持用户 loginUser 在集群节点不同密码的方式。二者不能兼用，否则报错，可以根据密码的异同选择参数使用，必须使用其一。默认密码均为 111111。 dbaUser 操作系统中的数据库管理员用户，默认gbase。 dbaGroup 操作系统中的数据库管理员用户的用户组，默认gbase。 dbaPwd 操作系统中的数据库管理员用户的密码。 rootPwd 操作系统中的root用户密码。 rootPwdFile 该参数支持 root 用户在多节点不同密码方式，与参数rootPwd 不能同时使用，否则报错。默认密码 111111。 dbRootPwd 数据库 root 用户密码。安装集群时无需设置，仅在集群升级、扩容、节点替换时使用生效。 mcastAddr 组播地址，缺省值为 226.94.1.39，组播方式会引起网络风暴，因此不建议使用此方式，如果将 mcastAddr 参数删除，则会按照 UDPU 方式进行安装，我们建议用户按此方式安装。 mcastPort 组播端口，缺省值为 5493，如果按照 UDPU 方式安装，则此参数无效。 3、安装软件
[root@localhost gcinstall]# ./gcinstall.py --silent=demo.options- 1
显示如下表示成功
192.168.142.11 Installing gcluster. 192.168.142.10 Install gcluster on host 192.168.142.10 successfully. 192.168.142.11 Install gcluster on host 192.168.142.11 successfully. 192.168.142.10 Install gcluster on host 192.168.142.10 successfully. Starting all gcluster nodes... Adding new datanodes to gcware... InstallCluster Successfully- 1
- 2
- 3
- 4
- 5
- 6
- 7
4、查看集群状态
[root@localhost gcinstall]# gcadmin CLUSTER STATE: ACTIVE CLUSTER MODE: NORMAL ===================================================================== | GBASE COORDINATOR CLUSTER INFORMATION | ===================================================================== | NodeName | IpAddress |gcware |gcluster |DataState | --------------------------------------------------------------------- | coordinator1 | 192.168.142.10 | OPEN | OPEN | 0 | --------------------------------------------------------------------- | coordinator2 | 192.168.142.11 | OPEN | OPEN | 0 | --------------------------------------------------------------------- ================================================================= | GBASE DATA CLUSTER INFORMATION | ================================================================= |NodeName | IpAddress |gnode |syncserver |DataState | ----------------------------------------------------------------- | node1 | 192.168.142.10 | OPEN | OPEN | 0 | ----------------------------------------------------------------- | node2 | 192.168.142.11 | OPEN | OPEN | 0 | ------------------------------------------------------------------ 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
5、设置分布式策略
[root@localhost gcinstall]# su - gbase 上一次登录：日 8月 7 20:29:00 CST 2022pts/3 上 [gbase@localhost ~]$ cd /opt/pkg/gcinstall/ [gbase@localhost gcinstall]$ vim gcChangeInfo.xml [gbase@localhost gcinstall]$ cat gcChangeInfo.xml <?xml version="1.0" encoding="utf-8"?> <servers> <rack> <node ip="192.168.142.10"/> <node ip="192.168.142.11"/> </rack> </servers> [gbase@localhost gcinstall]$ gcadmin distribution gcChangeInfo.xml p 1 d 0 gcadmin generate distribution ... [warning]: parameter [d num] is 0, the new distribution will has no segment backup please ensure this is ok, input y or n: y NOTE: node [192.168.142.10] is coordinator node, it shall be data node too NOTE: node [192.168.142.11] is coordinator node, it shall be data node too gcadmin generate distribution successful- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
参数 描述 p 每一个节点的分片数。 d 副本数量。 pattern number 数据分布模式，pattern 1 为负载均衡模式，pattern 2 为高可用模式。默认模式1。 注意：
gcChangeInfo.xml 文件中 rack 内 node 数量需要大于参数 p 的值（每个
节点存放主分片的数量），否则会出现如下错误：[gbase@localhost gcinstall]$ gcadmin distribution gcChangeInfo.xml p 2 d 0 gcadmin generate distribution ... [warning]: parameter [d num] is 0, the new distribution will has no segment backup please ensure this is ok, input y or n: y rack[1] node number:[2] shall be greater than segment number each node:[2] please modify file [gcChangeInfo.xml] and try again gcadmin generate distribution failed- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
6、检查集群分布策略
[gbase@localhost gcinstall]$ gcadmin showdistribution Distribution ID: 1 | State: new | Total segment num: 2 Primary Segment Node IP Segment ID Duplicate Segment node IP ======================================================================================================================== | 192.168.142.10 | 1 | | ------------------------------------------------------------------------------------------------------------------------ | 192.168.142.11 | 2 | | ========================================================================================================================- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
7、初始化节点数据分布
[gbase@localhost gcinstall]$ gccli GBase client 8.6.2.43-R33.132743. Copyright (c) 2004-2022, GBase. All Rights Reserved. gbase> initnodedatamap; Query OK, 0 rows affected, 1 warning (Elapsed: 00:00:01.87) gbase>- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
这里就安装完成了，后面大家就可以正常操作数据库，命令类似于MySql。
8、错误记录
之前部署的错误记录，暂时未找到原因，后面知道原因了，和大家说一下解决办法，猜想会不会是资源不足。
我这里用的是一个虚机2G内存，1个核。
[root@localhost gcinstall]# ./gcinstall.py --silent=demo.options ********************************************************************************* Thank you for choosing GBase product! Please read carefully the following licencing agreement before installing GBase product: TIANJIN GENERAL DATA TECHNOLOGY CO., LTD. LICENSE AGREEMENT READ THE TERMS OF THIS AGREEMENT AND ANY PROVIDED SUPPLEMENTAL LICENSETERMS (COLLECTIVELY "AGREEMENT") CAREFULLY BEFORE OPENING THE SOFTWAREMEDIA PACKAGE. BY OPENING THE SOFTWARE MEDIA PACKAGE, YOU AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCESSING THE SOFTWARE ELECTRONICALLY, INDICATE YOUR ACCEPTANCE OF THESE TERMS. IF YOU DO NOT AGREE TO ALL THESE TERMS, PROMPTLY RETURN THE UNUSED SOFTWARE TO YOUR PLACE OF PURCHASE FOR A REFUND. 1. CHINESE GOVERNMENT RESTRICTED. If Software is being acquired by or on behalf of the Chinese Government , then the Government's rights in Software and accompanying documentatio n will be only as set forth in this Agreement. 2. GOVERNING LAW. Any action related to this Agreement will be governed by Chinese law: "COPYRIGHT LAW OF THE PEOPLE'S REPUBLIC OF CHINA","PATENT LAW OF THE PEOPLE'S REPUBLIC OF CHINA","TRADEMARK LAW OF THE PEOPLE'S REPUBLIC OF CHINA","COMPUTER SOFTWARE PROTECTION REGULATIONS OF THE PEOPLE'S REPUBLIC OF CHINA". No choice of law rules of any jurisdiction will apply." ********************************************************************************* Do you accept the above licence agreement ([Y,y]/[N,n])? y ********************************************************************************* Welcome to install GBase products ********************************************************************************* Environmental Checking on gcluster nodes. CoordinateHost: 192.168.217.66 192.168.217.67 DataHost: 192.168.217.66 192.168.217.67 Are you sure to install GCluster on these nodes ([Y,y]/[N,n])? [Y,y] or [N,n] : y 192.168.217.67 Start install on host 192.168.217.67 192.168.217.66 Start install on host 192.168.217.66 192.168.217.67 mkdir /opt_prepare on host 192.168.217.67. 192.168.217.66 Start install on host 192.168.217.66 192.168.217.67 Copying InstallFuns.py to host 192.168.217.67:/opt_prepare 192.168.217.66 Start install on host 192.168.217.66 192.168.217.67 Copying RestoreLocal.py to host 192.168.217.67:/opt_prepare 192.168.217.66 Start install on host 192.168.217.66 192.168.217.67 Copying pexpect.py to host 192.168.217.67:/opt_prepare 192.168.217.66 Start install on host 192.168.217.66 192.168.217.67 Copying bundle.tar.bz2 to host 192.168.217.67:/opt_prepare 192.168.217.66 Start install on host 192.168.217.66 192.168.217.67 Copying bundle_data.tar.bz2 to host 192.168.217.67:/opt_prepare 192.168.217.66 mkdir /opt_prepare on host 192.168.217.66. 192.168.217.67 Installing gcluster. 192.168.217.66 mkdir /opt_prepare on host 192.168.217.66. 192.168.217.67 Installing gcluster. 192.168.217.66 mkdir /opt_prepare on host 192.168.217.66. 192.168.217.67 Installing gcluster. 192.168.217.66 mkdir /opt_prepare on host 192.168.217.66. 192.168.217.67 Installing gcluster. 192.168.217.66 mkdir /opt_prepare on host 192.168.217.66. 192.168.217.67 Installing gcluster. 192.168.217.66 mkdir /opt_prepare on host 192.168.217.66. 192.168.217.67 Installing gcluster. 192.168.217.66 Copying InstallTar.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Installing gcluster. 192.168.217.66 Copying InstallTar.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Installing gcluster. 192.168.217.66 Copying InstallTar.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Installing gcluster. 192.168.217.66 Copying InstallTar.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying InstallTar.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying InstallTar.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying InstallFuns.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying InstallFuns.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying InstallFuns.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying InstallFuns.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying InstallFuns.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying rmt.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying rmt.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying rmt.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying rmt.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying rmt.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying rmt.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying SSHThread.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying SSHThread.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying SSHThread.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying SSHThread.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying SSHThread.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying RestoreLocal.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying RestoreLocal.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying RestoreLocal.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying RestoreLocal.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying RestoreLocal.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying RestoreLocal.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying pexpect.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying pexpect.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying pexpect.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying pexpect.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying pexpect.py to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying BUILDINFO to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying BUILDINFO to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying BUILDINFO to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying BUILDINFO to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying BUILDINFO to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying BUILDINFO to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying bundle.tar.bz2 to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying bundle.tar.bz2 to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying bundle.tar.bz2 to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying bundle.tar.bz2 to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying bundle.tar.bz2 to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying bundle.tar.bz2 to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying bundle_data.tar.bz2 to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying bundle_data.tar.bz2 to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying bundle_data.tar.bz2 to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying bundle_data.tar.bz2 to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Copying bundle_data.tar.bz2 to host 192.168.217.66:/opt_prepare 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Installing gcluster. 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Installing gcluster. 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Installing gcluster. 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Installing gcluster. 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Installing gcluster. 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Installing gcluster. 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Installing gcluster. 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Installing gcluster. 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Installing gcluster. 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Install gcluster on host 192.168.217.66 successfully. 192.168.217.67 Install gcluster on host 192.168.217.67 successfully. 192.168.217.66 Install gcluster on host 192.168.217.66 successfully. Starting all gcluster nodes... Adding new datanodes to gcware... Fail to add new datanodes to gcware.- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- 96
- 97
- 98
- 99
- 100
- 101
- 102
- 103
- 104
- 105
- 106
- 107
- 108
- 109
- 110
- 111
- 112
- 113
- 114
- 115
- 116
- 117
- 118
- 119
- 120
- 121
- 122
- 123
- 124
- 125
- 126
- 127
- 128
- 129
- 130
- 131
- 132
- 133
- 134
- 135
- 136
- 137
- 138
- 139
- 140
- 141
- 142
- 143
- 144
- 145
- 146
- 147
- 148
- 149
- 150
- 151
- 152
- 153
- 154
- 155
- 156
- 157
- 158
- 159
- 160
- 161
- 162
- 163
- 164
- 165
- 166
- 167
- 168
- 169
- 170
- 171
- 172
- 173
- 174
- 175
- 176
- 177
最后出现了报错，我们查看安装日志gcinstall.log中出现的错误，并没有太大头绪。
2022-08-02 09:45:13,652-root-DEBUG Starting all gcluster nodes... 2022-08-02 09:45:27,111-root-INFO start service successfull on host 192.168.217.67. 2022-08-02 09:45:37,324-root-INFO start service successfull on host 192.168.217.66. 2022-08-02 09:45:37,827-root-DEBUG /bin/chown -R gbase:gbase gcChangeInfo.xml 2022-08-02 09:45:37,830-root-DEBUG Adding new datanodes to gcware... 2022-08-02 09:45:37,830-root-DEBUG /bin/chown -R gbase:gbase dataHosts.xml 2022-08-02 09:45:42,838-root-DEBUG gcadmin addNodes dataHosts.xml 2022-08-02 09:45:42,851-root-ERROR gcadmin add nodes ... NOTE: node [192.168.217.66] is coordinator node, it shall be data node too NOTE: node [192.168.217.67] is coordinator node, it shall be data node too gcadmin add nodes failed 2022-08-02 09:45:42,851-root-ERROR gcadmin addnodes error: [40]->[GC_AIS_ERR_CLUSTER_LOCKED] 2022-08-02 09:45:47,857-root-DEBUG gcadmin addNodes dataHosts.xml 2022-08-02 09:45:47,864-root-ERROR gcadmin add nodes ... NOTE: node [192.168.217.66] is coordinator node, it shall be data node too NOTE: node [192.168.217.67] is coordinator node, it shall be data node too gcadmin add nodes failed 2022-08-02 09:45:47,864-root-ERROR gcadmin addnodes error: [40]->[GC_AIS_ERR_CLUSTER_LOCKED] 2022-08-02 09:45:52,870-root-DEBUG gcadmin addNodes dataHosts.xml 2022-08-02 09:45:52,882-root-ERROR gcadmin add nodes ...- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
每个节点停止数据库服务。
[root@bogon ~]# service gcware stop Stopping GCMonit success! Signaling GCRECOVER (gcrecover) to terminate: [ 确定 ] Waiting for gcrecover services to unload:... [ 确定 ] Signaling GCSYNC (gc_sync_server) to terminate: [ 确定 ] Waiting for gc_sync_server services to unload: [ 确定 ] Signaling GCLUSTERD to terminate: [ 确定 ] Waiting for gclusterd services to unload:..................[ 确定 ].................................. Signaling GCWARE (gcware) to terminate: [ 确定 ] Waiting for gcware services to unload:.. [ 确定 ] [root@bogon ~]# ps -ef|grep gbase root 3743 3618 0 10:00 pts/1 00:00:00 su - gbase gbase 3744 3743 0 10:00 pts/1 00:00:00 -bash root 4216 3254 0 10:01 pts/0 00:00:00 grep --color=auto gbase- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
执行卸载脚本
[root@bogon gcinstall]# ./unInstall.py --silent=demo.options Can not get gcluster node info:'NoneType' object has no attribute '__getitem__'- 1
- 2
我们看一下源码unInstall.py，是在341和448两个中的一个抛出的错误，看着像是判断调度节点和数据节点是否存在函数出的错误，这里先不做探讨，后面有时间我们再看一下。
try: existCoordinateHost = GetExistCoordinateHost() existDataHost = GetExistDataHost(prefix,dbaUser) except Exception, err: raise Exception("Can not get gcluster node info:%s" % str(err))- 1
- 2
- 3
- 4
- 5
InstallFuns.py中包含GetExistCoordinateHost和GetExistDataHost的定义。
def GetExistCoordinateHost(): coordinateHost = [] coroConf = '/etc/corosync/corosync.conf' if(not path.exists('/var/lib/gcware/SCN')): return coordinateHost [rv, out, err] = ExecCMD("cat %s | grep memberaddr" % coroConf) if(not rv): lines = out.split('\n') for l in lines: if(len(l.strip()) > 0): ip = l.split("memberaddr:")[1].strip() if(len(ip) > 0): coordinateHost.append(ip) else: raise Exception(err) coordinateHost = Distinct(coordinateHost) return coordinateHost- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
def GetExistDataHost(prefix,dbaUser): dataNodes = [] if IsFederalCluster(dbaUser, prefix) != "GBase8a_85": dataServerFile = '/var/lib/gcware/DATASERVER' dataServerFileBak = '/var/lib/gcware/DATASERVER.bak' JA=None JB=None if os.path.exists(dataServerFile): FA = file(dataServerFile) JA = json.load(FA) FA.close() if os.path.exists(dataServerFileBak): FB = file(dataServerFileBak) JB = json.load(FB) FB.close() JSON = JA if int(JB['epoch']) > int(JA['epoch']): JSON = JB nodes = JSON['nodes'] for node in nodes: dataNodes.append(node['ipaddr']) else: dataServerFile = '/var/lib/gcware/CIB.xml' logger.debug("Get exist data hosts from %s." % dataServerFile) if not os.path.exists(dataServerFile): return dataNodes f = file(dataServerFile) s = f.read() f.close() root = ElementTree.fromstring(s) for el in root.find('nodes').findall('node'): ip = el.get('ipaddr') dataNodes.append(ip) return IPConvToComp(dataNodes)- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
由于上面卸载脚本报错，我们手动清理一下，每个节点都要做哦。
rm -fr /opt/gcluster rm -fr /opt/gnode rm -fr /opt/gcware userdel -r gbase rm -fr /opt/gcluster rm -fr /opt/gnode rm -fr /etc/corosync/corosync.conf rm -fr /var/lib/gcware rm -fr /etc/init.d/gbased rm -fr /etc/init.d/gcrecover rm -fr /etc/init.d/gclusterd rm -fr /etc/init.d/gcsync rm -fr /etc/init.d/gcware- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
-
相关阅读:
预定义ContentProvider
SpringCloud搭建微服务之Config配置中心
MySQL数据库修改字段编码
软件工程理论与实践 (吕云翔) 第十一章： 软件编程课后习题及其答案解析
写一个简单食用的拦截器
MYSQL-存储引擎
论文阅读：Offboard 3D Object Detection from Point Cloud Sequences
计算机网络-局域网和城域网（二）
智慧应急解决方案-最新全套文件
【LeetCode题目详解】第九章 动态规划 part05 1049. 最后一块石头的重量 II 494. 目标和 474.一和零（day43补）
- 原文地址：https://blog.csdn.net/qq_45111959/article/details/126098111
