GBase数据库多VC安装

虚机：server with gui +开发工具

ps -ef|grep opt
df -h|grep opt
先确认是空机器

做完raid后，要挂载磁盘，并测试磁盘读写
lsblk
mkfs.xfs /dev/sdb
mount /dev/sdb /opt
echo "/dev/sdb /opt xfs defaults 0 0" >>/etc/fstab

磁盘的读写一定要检查，不然后期性能拉跨有你爽的。执行dd.sh脚本
检查磁盘的读写性能
写：读：读写：
cexec sjjs: dd oflag=direct if=/dev/zero of=/opt/1.dat bs=2M count=512
cexec sjjs: dd iflag=direct if=/opt/1.dat of=/dev/zero bs=2M count=512
cexec sjjs: dd iflag=direct oflag=direct if=/opt/1.dat of=/opt/2.dat bs=2M count=512

--
systemctl status sshd.service
systemctl start sshd.service
systemctl enable sshd.service

vi /etc/selinux/config
SELINUX=disabled
sed -i 's/enforcing/disabled/' /etc/selinux/config
重启机器或者 临时关闭:输入命令 setenforce 0

systemctl stop firewalld
systemctl disable firewalld
systemctl status firewalld

chmod +x /etc/rc.d/rc.local
echo "su - gbase -c 'gcluster_services all start'" >> /etc/rc.d/rc.local
echo "su - gbase -c 'gcware_services all start'" >> /etc/rc.d/rc.local

# groupadd gbase
# useradd -g gbase -m gbase
# echo gbase:gbase|chpasswd
# chown  gbase:gbase /opt
# chown gbase:gbase /tmp
# cd /opt
# tar xvf GBase8a_MPP_Cluster-NoLicense-9.5.2.20-redhat7.3-x86_64.tar.bz2
# chown -R gbase:gbase gcinstall
# cd gcinstall
./SetSysEnv.py --installPrefix=/opt --dbaUser=gbase 
# scp SetSysEnv.py 其余节点
--所有节点执行环境设置脚本

检查ip和主机名
cexec ip a|grep xx 
cexec cat /etc/hostname
检查磁盘挂载
cexec sjjs: df -h|grep opt
检查网络：
cexec sjjs: "ethtool bond1g" |grep Speed
cexec sjjs: "ethtool bond10g" |grep Speed

管理节点最好以单数?GCware 节点推荐部署在 GCluster 节点服务器上,GCluster + GCware = Coordinator
# su - gbase
这里切换成gabse用户了！
cd /opt/gcinstall
$ vi demo.options
---
installPrefix= /opt
coordinateHost = 192.168.5.22
coordinateHostNodeID = 22
gcwareHost = 192.168.5.22
gcwareHostNodeID = 22
dataHost = 192.168.5.22,192.168.5.23,192.168.5.24,192.168.5.25,192.168.5.26
dbaUser = gbase
dbaGroup = gbase
dbaPwd = 'gbase'
characterSet=gbk
-----
#rootPwd = ''
#existCoordinateHost =
#existDataHost =
#existGcwareHost=
#dbRootPwd = ''
#rootPwdFile = rootPwd.json
#characterSet = utf8
#sshPort = 22
---

$ ./gcinstall.py --silent=demo.options

checking rpms ...
checking Cgconfig service
command "lssubsys" not found on host [66.25.94.17]
command "lssubsys" not found on host [66.25.94.82]
command "lssubsys" not found on host [66.25.94.75]
Cgconfig service is not exist on host ['66.25.94.17', '66.25.94.75', '66.25.94.82'], resource manangement can not be used, continue ([Y,y]/[N,n])? 
退出重新登陆或者. ~/.bash_profile
查看集群状态 gcadmin，gn是freenode状态

创建vc
su - gbase
cd /opt/gcinstall
gcadmin createvc e vc1.xml
vi vc1.xml
-----
   <rack>
       <node ip="172.16.9.184"/>
        <node ip="172.16.9.185"/>
   </rack>
   <vc_name name="vcso"/>
   <comment message="vcso"/>
-----
gcadmin createvc vc1.xml

创建 distribution
cp gcChangeInfo.xml 1.xml
vi 1.xml
--
<?xml version="1.0" encoding="utf-8"?>
<servers>
   <rack>
       <node ip="192.168.5.23"/>
   </rack>
   <rack>
       <node ip="192.168.5.22"/>
   </rack>
   <rack>
       <node ip="192.168.5.24"/>
   </rack>
</servers>
--

gcadmin distribution 1.xml p 1 d 1 vc vc1

初始化
gccli
use vc vc1;
initnodedatamap;
检查：
gcadmin showdistribution node vc vc1
gcadmin showcluster vc vc1

这3个参数必须加到gn节点，不然后期性能不行。
检索 oneformany
gbase_loader_parallel_degree = 6
gbase_parallel_degree = 6
group_concat_max_len = 20480

修改参数文件后重启gn节点

检查字符集
show variables like '%char%';

gn节点gncli 提示：Must set environment variable GBASE_BASE
echo "source /opt/192.168.xx.xx/gbase_profile" >> .bash_profile && source .bash_profile
如果是信创机器：
echo "source /opt/192.168.xx.xx/gbase_profile" >> .bashrc && source .bashrc

------------------------------------------------
C3工具安装配置：cexecs:串行
gbase用户配置免密
$ ssh-copy-id gbase@xxxx
报错：/bin/ssh-copy-id: ERROR: No identities found
解决：ssh-keygen

重启生效
cexec vc1: gcluster_services all stop   --并行关
cexecs vc1: gcluster_services all start --串行开

特定字符串的行前插入新行 
sed -i ‘/特定字符串/i 新行字符串’ file
特定字符串的行后插入新行 
sed -i ‘/特定字符串/a 新行字符串’ file
sed -i '/gbase_parallel_degree = 6/a\bbbbbbbbbb = 8'  gbase_8a_gcluster.cnf

安装好后参数配置：改参数前务必做好备份
GN:
cexecs vc1: cp /opt/172.16.9.*/gnode/config/gbase_8a_gbase.cnf /home/gbase/

注意修改GN和GC区别：
GC：手动改下
GN:
cexecs vc1: 'sed -i "/skip_file_check = 1/a\gbase_loader_parallel_degree = 6"  /opt/172.16.9.*/gnode/config/gbase_8a_gbase.cnf'
cexecs vc1: 'sed -i "/skip_file_check = 1/a\gbase_parallel_degree = 6"  /opt/172.16.9.*/gnode/config/gbase_8a_gbase.cnf'
cexecs vc1: 'sed -i "/skip_file_check = 1/a\group_concat_max_len = 20480"  /opt/172.16.9.*/gnode/config/gbase_8a_gbase.cnf'
show variables like '%degree%';
show variables like '%group_concat%';

gn节点配置的参数  影响性能：
检索 oneformany
gbase_loader_parallel_degree = 6
gbase_parallel_degree = 6
group_concat_max_len = 20480