OceanBase 4.2.1 离线安装

OceanBase 4.2.1 离线安装

4.2 版本的OceanBase支持一键安装，所以在线版本的安装简单了很多，但在无法连接网络的情况下安装就只能手动离线安装。

注：如下安装过程都是在同一台机器上面进行，也就是只有一个节点，多个节点安装以此类推即可。

离线安装步骤：
下载安装包
建议使用最上面的OceanBase 数据库一键离线安装包，选择适合的版本号下载，里面包含的内容比较全

下载安装部署工具包
安装部署工具OceanBase Deployer（简称OBD），官方解释上面的All in One 包里已经包含这个包了，可以直接运行安装。

进入下载目录解压，然后进入oceanbase-all-in-one/rpms
tar -zxvf ocp-all-in-one-4.2.1-20231208144448.el7.x86_64.tar.gz

安装obd
yum install ob-deploy-2.4.0-7.el7.x86_64.rpm

然后执行如下命令，将安装工具的安装源改完本地
obd  mirror disable remote #禁用远程仓库
obd mirror clone *.rpm #设置本地仓库
obd mirror list local #查看本地仓库

启动web部署工具，web界面操作起来更方便一些
#启动OBD部署界面，可以使用obd web -h 查看可用参数
obd web -p 8000 #会输出web界面的网址，如下：
[root@ocpsys ~]# obd web -p 8000
start OBD WEB in 0.0.0.0:8000
please open http://192.168.142.12:8000

注意：所有部署过程均为web图形界面操作部署，具体过程OceanBase官方有详细的操作步骤。

vi /etc/security/limits.d/20-nproc.conf
*       soft    nproc   655350          #最大线程数
root       soft    nproc   unlimited          #最大线程数

vi /etc/security/limits.conf在文件尾部添加
*       soft    nofile  655350
*       hard    nofile  655350
*       soft    nproc  655350
*       hard    nproc  655350
*       soft    stack   unlimited
*       hard    stack   unlimited
*       soft    core    unlimited
*       hard    core    unlimited

vi /etc/sysctl.conf在文件尾部添加
vm.max_map_count=655360
vm.min_free_kbytes=2097152
fs.file-max = 6573688
fs.aio-max-nr = 1048576

设置免密码sudo
vi /etc/sudoers 在文件尾部添加
vi /etc/sudoers
admin       ALL=(ALL)       NOPASSWD: ALL

用户名密码记录：192.168.142.12
root@sys/zzh!@#123QAZ

部署日志：
+---------------------------------------------------------------------------------------------+
|                                           Packages                                          |
+---------------+---------+------------------------+------------------------------------------+
| Repository    | Version | Release                | Md5                                      |
+---------------+---------+------------------------+------------------------------------------+
| oceanbase-ce  | 4.2.1.2 | 102000042023120514.el7 | b2ccb524f200a9ef0fad2cddf59d309ddaa2e3e4 |
| obproxy-ce    | 4.2.1.0 | 11.el7                 | 0aed4b782120e4248b749f67be3d2cc82cdcb70d |
| ocp-server-ce | 4.2.1   | 20231208144448.el7     | 58cf72891d75a2fa7c754bafc42d336525baf0b5 |
+---------------+---------+------------------------+------------------------------------------+
Repository integrity check ok
Parameter check ok
Generate ocp server configuration ok
Cluster status check ok
Initializes observer work home ok
Initializes obproxy work home ok
Initializes ocp-server work home ok
Remote oceanbase-ce-4.2.1.2-102000042023120514.el7-b2ccb524f200a9ef0fad2cddf59d309ddaa2e3e4 repository install ok
Remote oceanbase-ce-4.2.1.2-102000042023120514.el7-b2ccb524f200a9ef0fad2cddf59d309ddaa2e3e4 repository lib check !!
Remote obproxy-ce-4.2.1.0-11.el7-0aed4b782120e4248b749f67be3d2cc82cdcb70d repository install ok
Remote obproxy-ce-4.2.1.0-11.el7-0aed4b782120e4248b749f67be3d2cc82cdcb70d repository lib check ok
Remote ocp-server-ce-4.2.1-20231208144448.el7-58cf72891d75a2fa7c754bafc42d336525baf0b5 repository install ok
Remote ocp-server-ce-4.2.1-20231208144448.el7-58cf72891d75a2fa7c754bafc42d336525baf0b5 repository lib check ok
Try to get lib-repository
Remote oceanbase-ce-libs-4.2.1.2-102000042023120514.el7-b4ae00ee729404557fa858d4cdd87250bca1aa63 repository install ok
Remote oceanbase-ce-4.2.1.2-102000042023120514.el7-b2ccb524f200a9ef0fad2cddf59d309ddaa2e3e4 repository lib check ok
obcluster deployed
Search plugins ok
Load cluster param plugin ok
Check before start observer ok
[WARN] OBD-1012: (192.168.142.12) clog and data use the same disk (/data)

Start observer ok
observer program health check ok
Connect to observer ok
Initialize oceanbase-ce ok
Wait for observer init ok
+--------------------------------------------------+
|                     observer                     |
+----------------+---------+------+-------+--------+
| ip             | version | port | zone  | status |
+----------------+---------+------+-------+--------+
| 192.168.142.12 | 4.2.1.2 | 2881 | zone1 | ACTIVE |
+----------------+---------+------+-------+--------+
obclient -h192.168.142.12 -P2881 -uroot -p'zzh!@#123QAZ' -Doceanbase -A

succeed
Search plugins ok
Load cluster param plugin ok
Check before start obproxy ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize obproxy-ce ok
+--------------------------------------------------+
|                     obproxy                      |
+----------------+------+-----------------+--------+
| ip             | port | prometheus_port | status |
+----------------+------+-----------------+--------+
| 192.168.142.12 | 2883 | 2884            | active |
+----------------+------+-----------------+--------+
obclient -h192.168.142.12 -P2883 -uroot -p'zzh!@#123QAZ' -Doceanbase -A
succeed
Search plugins ok
Load cluster param plugin ok
Check before start ocp-server ok
Create tenant ocp_meta ok
Create tenant ocp_monitor ok
Start ocp-server ok
ocp-server program health check ok
Start ocp-server ok
ocp-server program health check ok
Connect to ocp-server ok
+---------------------------------------------------------------+
|                           ocp-server                          |
+----------------------------+----------+--------------+--------+
| url                        | username | password     | status |
+----------------------------+----------+--------------+--------+
| http://192.168.142.12:8080 | admin    | zzh!@#123QAZ | active |
+----------------------------+----------+--------------+--------+
succeed