合 人大金仓V8单机环境安装
单机下载安装
https://www.kingbase.com.cn/rjcxxz/index.htm
https://help.kingbase.com.cn/stage-api/profile/document/kes/v8r6/html/index.html
KingbaseES_V8R6_Lin64_install,1.6GB
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 | wget https://kingbase.oss-cn-beijing.aliyuncs.com/KESV8R3/V8R6/%E5%AE%89%E8%A3%85%E5%8C%85/KingbaseES_V008R006C005B0041_Lin64_install.iso wget https://kingbase.oss-cn-beijing.aliyuncs.com/KESV8R3/V8R6/%E5%AE%98%E7%BD%91license_V8R6-%E4%BC%81%E4%B8%9A%E7%89%88.zip docker run -d --name lhrkingbase -h lhrkingbase \ -p 54321:54321 -p 54322:3389 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/lhrcentos76:8.8 \ /usr/sbin/init yum -y install coreutils glib2 lrzsz dstat sysstat e4fsprogs xfsprogs\ ntp readline-devel zlib-devel openssl-devel pam-devel libxml2-devel\ libxslt-devel python-devel tcl-devel gcc gcc-c++ make smartmontools \ flex bison perl-devel perl-ExtUtils* openldap-devel jadetex openjade bzip2 useradd kingbase echo "kingbase:lhr" | chpasswd mkdir -p /opt/Kingbase/ES/V8 chown -R kingbase:kingbase /opt/Kingbase/ES/V8 -- 环境变量 cat >> /home/kingbase/.bashrc <<"EOF" export KINGBASE_DATA=/opt/Kingbase/ES/V8/data export LD_LIBRARY_PATH=/opt/Kingbase/ES/V8/Server/lib:$LD_LIBRARY_PATH #export PATH=/opt/Kingbase/ES/V8/Server/bin:$PATH EOF source /home/kingbase/.bashrc cat >> /etc/sysctl.conf <<"EOF" fs.aio-max-nr= 1048576 fs.file-max= 6815744 kernel.shmall= 2097152 kernel.shmmax= 4294967295 kernel.shmmni= 4096 kernel.sem= 250 32000 100 128 net.ipv4.ip_local_port_range= 9000 65500 net.core.rmem_default= 262144 net.core.rmem_max= 4194304 net.core.wmem_default= 262144 net.core.wmem_max= 1048576 EOF /sbin/sysctl-p /sbin/sysctl-a -- 挂载iso文件:iso格式的安装程序包需要先挂载才能使用。挂载iso文件需要使用root用户 mkdir -p /KingbaseESV8 mknod -m 0660 /dev/loop0 b 7 0 mount /soft/KingbaseES_V008R006C005B0041_Lin64_install.iso /KingbaseESV8 cd /KingbaseESV8 -- 启用图形界面 echo xfce4-session > /home/kingbase/.xsession chmod +x /home/kingbase/.xsession systemctl restart xrdp && systemctl enable xrdp -- 图形化界面安装 mstsc: 192.168.66.35:54322 , 以kingbase用户登录 sh setup.sh -i swing kingbase -V -- 控制台安装 su - kingbase sh setup.sh -i console -- 初始化实例 initdb -D /opt/Kingbase/ES/V8/data sys_ctl -D /opt/Kingbase/ES/V8/data -l logfile start sys_ctl status -- 开机启动服务 /opt/Kingbase/ES/V8/install/script/root.sh systemctl status kingbase8d.service /sbin/chkconfig kingbase8d on ksql -d test \password kingbase ksql -h 192.168.66.35 -p 54321 -U kingbase -d test psql -h 192.168.66.35 -p 54321 -U kingbase -d test [root@lhrkingbase /]# ps -ef|grep kingbase root 248 213 0 Mar29 pts/0 00:00:00 su - kingbase kingbase 249 248 0 Mar29 pts/0 00:00:00 -bash kingbase 25369 1 1 08:34 ? 00:00:00 /opt/Kingbase/ES/V8/KESRealPro/V008R006C005B0041/Server/bin/kingbase -D /opt/Kingbase/ES/V8/data kingbase 25370 25369 0 08:34 ? 00:00:00 kingbase: logger kingbase 25372 25369 0 08:34 ? 00:00:00 kingbase: checkpointer kingbase 25373 25369 0 08:34 ? 00:00:00 kingbase: background writer kingbase 25374 25369 0 08:34 ? 00:00:00 kingbase: walwriter kingbase 25375 25369 0 08:34 ? 00:00:00 kingbase: autovacuum launcher kingbase 25376 25369 0 08:34 ? 00:00:00 kingbase: stats collector kingbase 25377 25369 0 08:34 ? 00:00:00 kingbase: ksh writer kingbase 25378 25369 0 08:34 ? 00:00:00 kingbase: ksh collector kingbase 25379 25369 0 08:34 ? 00:00:00 kingbase: kwr collector kingbase 25380 25369 0 08:34 ? 00:00:00 kingbase: logical replication launcher root 25391 24257 0 08:34 pts/2 00:00:00 grep --color=auto kingbase |