人大金仓V8R3安装
<p>[TOC]</p>
<h3>安装包下载地址:[点击下载金仓](<a href="http://101.69.243.254:5010/share/Ku5P3SKI">http://101.69.243.254:5010/share/Ku5P3SKI</a> "点击下载金仓安装包")</h3>
<p>安装版本:KingbaseES_V8R3_lin_x86_64</p>
<h2>一、创建相关用户及目录</h2>
<ul>
<li>创建kingbase用户、组</li>
</ul>
<pre><code class="language-shell">groupadd kingbase # 创建用户组
useradd -g kingbase -m -d /home/kingbase -s /bin/bash kingbase # 创建用户
passwd kingbase # 设置用户密码</code></pre>
<ul>
<li>上传软件包至/home并解压</li>
</ul>
<pre><code class="language-shell">unzip KingbaseES_V8R3_linx86_64.zip
chown -R kingbase.kingbase /home/KingbaseES_V8R3_linx86_64/ # 递归修改解压文件归属
chmod +x /home/KingbaseES_V8R3_linx86_64/SETUP.SH # 赋予执行权限</code></pre>
<ul>
<li>创建相关目录</li>
</ul>
<pre><code class="language-shell">mkdir -p /risen/soft/kingbase/ES/V8 #安装目录
mkdir -p /risen/data/dbdata/kingbase #数据库备份目录
chown -R kingbase:kingbase /risen/soft/kingbase/ES/V8 # 修改安装目录归属</code></pre>
<p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/f17d3179870fdf39954a3584aa6f5c0c" alt="" /></p>
<h2>二、修改内核</h2>
<pre><code class="language-shell">vim /etc/sysctl.conf
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
sysctl -p # 保存退出,执行使改动立即生效</code></pre>
<p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/adff133ecef689120cb1bb8a166d3ffe" alt="" /></p>
<h2>三、开始安装Kingbase</h2>
<pre><code class="language-shell">su - kingbase # 用kingbase用户安装Kingbase数据库
cd /home/KingbaseES_V8R3_linx86_64/SETUP/
chmod +x INSTALL.BIN
./INSTALL.BIN -i console # 字符界面安装</code></pre>
<p>按编号选择区域: <code>2</code> #2简体中文
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/c28c0c1232f17f06b11e9330b24d8ac5" alt="" />
是否接受此许可协议条款? (Y/N):<code>y</code>
输入“安装集”的号码,或按 <ENTER> 键以接受缺省值: <code>1</code> # 1完全安装
授权文件路径: <code>/home/KingbaseES_V8R3_linx86_64/license_V8R3.dat</code>
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/d66184ebfaa7a245da37a0c682c17e45" alt="" />
输入一个绝对路径,或按 <ENTER> 键以接受缺省路径: <code>/risen/soft/kingbase/ES/V8</code>
安装文件夹为:risen/soft/kingbase/ES/V8 是否正确? (Y/N): <code>y</code>
预安装摘要————————————
按 <ENTER> 键进行安装:
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/af11aee9efe494756a59942728e31d33" alt="" />
数据目录
Data folder (默认: /risen/soft/kingbase/ES/V8/data):
端口: (默认: 54321):
账户: (默认: SYSTEM):
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/f4d94f9831561abe88ae29ca7138c0fa" alt="" />
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/fcf00bcec44577aa9366ccebe4768c39" alt="" />
请输入密码:
输入您选择的号码,或按 <ENTER> 键以接受缺省值: <code>1</code> #编码格式选utf-8
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/b61512d889914e8c7bfe6b3e69d3778c" alt="" />
输入您选择的号码,或按 <ENTER> 键以接受缺省值: <code>1</code> #case-insensetive不区分大小写
数据库将要初始化,这可能会花一些时间,请耐心等待。请按 <ENTER> 键继续:
安装完成
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/7754adb640f06a76ec6750e8f82d7377" alt="" /></p>
<h2>四、将Kingbase数据库注册成系统服务并设置开机自启</h2>
<p>注册系统服务</p>
<pre><code class="language-shell">exit # 禁止套娃!上一步操作是kingbase用户,注册系统服务需要root用户
/risen/soft/kingbase/ES/V8/Scripts/root.sh</code></pre>
<p>设置开机自启</p>
<pre><code class="language-shell">chkconfig --add kingbase8d # 将系统服务kingbase加入开机自启列表(chkconfig --list)
chkconfig kingbase8d on</code></pre>
<p>数据库常用操作命令</p>
<pre><code class="language-shell">systemctl status kingbase8d.service # 查看数据库状态
systemctl start kingbase8d.service # 启动数据库
systemctl stop kingbase8d.service # 关闭数据库
systemctl restart kingbase8d.service # 重启数据库</code></pre>
<p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/dedf7aaed5f2aa34d0b466891191c2ef" alt="" />
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/3e1fdea744e2bb6e22341d59e936633e" alt="" /></p>
<h2>五、优化数据库</h2>
<p>配置参数,16核32G为例:</p>
<pre><code class="language-shell">vim /risen/soft/kingbase/ES/V8/data/kingbase.conf</code></pre>
<p>优化参数如下:</p>
<pre><code class="language-shell">max_connections = 1000 #具体根据应用来定,最大连接数
char_default_type = 'char' #默认类型
shared_buffers = 8GB #Cpu的50%,共享缓冲区
effective_cache_size = 16GB #有效缓存大小
maintenance_work_mem = 1GB #维护工作内存
max_wal_size = 8GB #最大容量
min_wal_size = 2GB #最小容量
checkpoint_completion_target = 0.8 #检查点\完成\目标
checkpoint_timeout = 15min #检查点超时
log_line_prefix = '%t %d %u %p %x' #日志行前缀
log_filename = 'kingbase-%a.log' #日志名称
ora_input_emptystr_isnull = off(false) #空字符串设置,默认为on(true)</code></pre>
<h2>六、用连接工具测试连接</h2>
<p><img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/5363cc269beb1a1a6855e7246ef3cb26" alt="" /></p>
<h2>七、设置数据库定时备份</h2>
<p><a href="http://60.191.64.5:16100/web/#/p/a97b3e9383766424d4d7101c2d57bdb7">http://60.191.64.5:16100/web/#/p/a97b3e9383766424d4d7101c2d57bdb7</a></p>
<h2>八、替换许可证书</h2>
<p><a href="http://60.191.64.5:16100/web/#/p/0ee1e5085b89dba1971abd3e6d6b33b9">http://60.191.64.5:16100/web/#/p/0ee1e5085b89dba1971abd3e6d6b33b9</a></p>
<h2>九、卸载</h2>
<pre><code class="language-shell">cd /risen/soft/kingbase/kdb/Uninstall/ #kingbase用户
./Uninstaller
cd /risen/soft/kingbase/kdb/Scripts #root用户
./rootuninstall.sh</code></pre>