GBase8s数据库安装指导手册

1. 检查操作系统依赖：

    java  -version
    unzip 

2. 操作系统安全相关：

    关闭防火墙:
    systemctl  status firewalld
    systemctl  stop firewalld
    systemctl  disable firewalld
    放开防火墙的访问端口:
    firewall-cmd --add-port=9000-9900/tcp  --permanent
    firewall-cmd --add-port=9000-9900/udp  --permanent
    firewall-cmd --reload
    firewall-cmd --list-ports
    ==========禁用selinux============================
    getenforce
    setenforce 0
    sed -i s/SELINUX=enforcing/SELINUX=disabled/g /etc/selinux/config 
    ==========ssh-key(非必须)============================
    在不同的主机上执行
    ssh-keygen
    复制公钥到其他服务器上
    ssh-copy-id -i ./.ssh/id_rsa.pub gbasedbt@XXX

3. 创建用户:

    groupadd  gbasedbt
    useradd -g gbasedbt -d /home/gbasedbt -s /bin/bash -m gbasedbt
    passwd gbasedbt
    echo "GBase123"|passwd --stdin gbasedbt

4. 设置gbasedbt环境变量：

    export GBASEDBTSERVER=gbase01
    export GBASEDBTDIR=/opt/gbase
    export PATH=$GBASEDBTDIR/bin:/usr/bin:${PATH}:.
    export ONCONFIG=onconfig.gbase01
    export GBASEDBTSQLHOSTS=$GBASEDBTDIR/etc/sqlhosts.gbase01
    export GL_DATE="%iY-%m-%d"
    export DATETIME="%iY-%m-%d %H:%M:%S"
    export DB_LOCALE=zh_cn.GB18030-2000
    export CLIENT_LOCALE=zh_cn.GB18030-2000
    export LD_LIBRARY_PATH=${GBASEDBTDIR}/lib:${GBASEDBTDIR}/lib/esql:${GBASEDBTDIR}/lib/cli
    export TERM=vt100
    export TERMCAP=$GBASEDBTDIR/etc/termcap
    export GBASEDBTTERM=termcap
    export DBTEMP=$GBASEDBTDIR/tmp
    stty   erase '^H'
    alias  etc='cd $GBASEDBTDIR/etc'
    alias  h='history'

5. 数据库软件安装:

tar  -xvf  GB*.tar
ids_install -i silent -DLICENSE_ACCEPTED=TRUE -DUSER_INSTALL_DIR=/opt/gbase

6. 数据库初始化：

cd  $GBASEDBTDIR/etc
cp sqlhosts.std sqlhosts.gbase01

echo >> sqlhosts.gbase01 <"EOF"
gbase01		onsoctcp	192.168.1.106	9099
EOF

cp onconfig.std   onconfig.gbase01
修改参数如下：
ROOTPATH $GBASEDBTDIR/chunks/rootchk
TAPEDEV /dev/null
LTAPEDEV /dev/null
DBSERVERNAME   gbase01

mkdir -p $GBASEDBTDIR/chunks
cd $GBASEDBTDIR/chunks
touch rootchk
chmod 660 rootchk


oninit -ivy        

7. 创建dbspaces:

cd $GBASEDBTDIR/chunks/
touch plogchk llogchk tmpchk01 tmpchk02 datachk01
chmod 660 *
onspaces -c -d plogdbs -o 0 -s 512000 -p /opt/gbase/chunks/plogchk  
onspaces -c -d llogdbs -o 0 -s 1024000 -p /opt/gbase/chunks/llogchk 
onspaces -c -d tmpdbs01 -o 0 -s 204800 -p /opt/gbase/chunks/tmpchk01 -t -k 16
onspaces -c -d tmpdbs02 -o 0 -s 204800 -p /opt/gbase/chunks/tmpchk02 -t -k 16
onspaces -c -d datadbs01 -o 0 -s 204800 -p /opt/gbase/chunks/datachk01  -k 16

8. 迁移物理日志和逻辑日志：

onparams -p -s 500000 -d plogdbs 
onparams -a -d llogdbs -s 200000 
onparams -a -d llogdbs -s 200000 
onparams -a -d llogdbs -s 200000 
onparams -a -d llogdbs -s 200000 
onparams -a -d llogdbs -s 200000 
for i in {1..6}; do onmode -l; done
for i in {1..6}; do onparams -d -l $i -y; done

9. 调整其他参数：

PHYSBUFF 512
LOGBUFF  512
DBSPACETEMP tmpdbs01,tmpdbs0
NETTYPE soctcp,1,50,NET
MULTIPROCESSOR 1
VPCLASS cpu,num=3,noage
LOCKS 100000
DEF_TABLE_LOCKMODE row
SHMVIRTSIZE 204800
SHMADD      204800
STACKSIZE   512
TEMPTAB_NOLOG  1
DUMPSHMEM      0
BUFFERPOOL      size=16K,buffers=50000,lrus=8,lru_min_dirty=50,lru_max_dirty=6


onmode -ky
oninit -v