KDB 集群搭建
环境信息
名称 | 值 |
---|---|
节点1 | Grace |
节点2 | Slave |
节点1 IP | 192.168.0.193 |
节点2 IP | 192.168.0.194 |
节点1私网IP | 10.10.10.1 |
节点2私网IP | 10.10.10.2 |
数据库版本 | KDB 11g fs07 |
数据库安装用户 | kdb |
数据库安装目录 | /home/kdb/kdb11 |
虚拟共享磁盘nfs共享 | dd if=/dev/zero bs=1M count=5000 of=/home/kdb/DATA/disk1 |
创建用户
#groupadd -g dba
#useradd -g dba kdb
配置系统环境变量
[root@grace ~]# vi /etc/sysctl.conf
[root@grace ~]#
[root@grace ~]# sysctl -p
kernel.sem = 100000 100000 100000 100000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 67108864
net.core.wmem_max = 67108864
fs.aio-max-nr = 1048576
fs.file-max = 8388608
配置用户环境变量
--节点1:
[kdb@grace ~]$ vi ~/.bash_profile
PATH=$PATH:$HOME/bin
export PATH
export CM_SID=cm0
export CM_HOME=/home/kdb/kdb11
export KD_SID=kac0
export KD_HOME=/home/kdb/kdb11
export PATH=.:$KD_HOME/bin:$KD_HOME/client/bin:$PATH
export LD_LIBRARY_PATH=$KD_HOME/lib:$KD_HOME/client/lib:$LD_LIBRARY_PATH
# kas的环境变量
[kdb@grace ~]$ cat ~/.kas_profile
export KD_SID=kas0
export KD_HOME=/home/kdb/kdb11
export PATH=.:$KD_HOME/bin:$KD_HOME/client/bin:$PATH
export LD_LIBRARY_PATH=$KD_HOME/lib:$KD_HOME/client/lib:$LD_LIBRARY_PATH
# kac的环境变量
[kdb@grace ~]$ cat ~/.kac_profile
export KD_SID=kac0
export KD_HOME=/home/kdb/kdb11
export PATH=.:$KD_HOME/bin:$KD_HOME/client/bin:$PATH
export LD_LIBRARY_PATH=$KD_HOME/lib:$KD_HOME/client/lib:$LD_LIBRARY_PATH
--节点2:
[kdb@slave ~]$ vi ~/.bash_profile
PATH=$PATH:$HOME/bin
export PATH
export CM_SID=cm1
export CM_HOME=/home/kdb/kdb11
[kdb@slave ~]$ cat ~/.kas_profile
export KD_SID=kas1
export KD_HOME=/home/kdb/kdb11
export PATH=.:$KD_HOME/bin:$KD_HOME/client/bin:$PATH
export LD_LIBRARY_PATH=$KD_HOME/lib:$KD_HOME/client/lib:$LD_LIBRARY_PATH
[kdb@slave ~]$ cat ~/.kac_profile
export KD_SID=kac1
export KD_HOME=/home/kdb/kdb11
export PATH=.:$KD_HOME/bin:$KD_HOME/client/bin:$PATH
export LD_LIBRARY_PATH=$KD_HOME/lib:$KD_HOME/client/lib:$LD_LIBRARY_PATH
上传安装包并解压(2节点执行)
[kdb@grace ~]$ tar -zxf kdb11-bin-FS07_CS_1902-linux64_china-171177-opt-20191018101953.tar.gz
生成参数文件(2节点执行)
. ~/.bash_profile
. ~/.kas_profile
. $KD_HOME/config/gen_tip.sh
. ~/.kac_profile
. $KD_HOME/config/gen_tip.sh
修改节点1参数文件
# kas的参数文件
[kdb@grace ~]$ vi $KD_HOME/config/kas0.tip
DB_NAME=kas
LISTENER_PORT=26420
MAX_SESSION_COUNT=20
TOTAL_SHM_SIZE=2G
MEMORY_TARGET=4G
INSTANCE_TYPE=AS
CLUSTER_DATABASE=Y
THREAD=0
CM_PORT=26630
LOCAL_CLUSTER_ADDR=192.168.0.193
LOCAL_CLUSTER_PORT=26430
AS_ALLOW_ONLY_RAW_DISKS=N
DB_BLOCK_SIZE=4K
AS_DISKSTRING="/home/kdb/DATA/disk*"
_DBWR_USE_AIO=N
#kac的参数文件
[kdb@grace ~]$ vi $KD_HOME/config/k