anolis23.4上命令行部署 OceanBase v4.5 版本 3节点分布式集群

关注

原创最新推荐文章于 2026-11-09 21:50:34 发布 619 阅读 AI 写同款· GEO 优化 ›

OceanBase只读分两层：租户账号和项目成员 OceanBase Cloud 上说「给只读」时，经常开错层。审计要查表，却只被邀请进了项目，连不上库。同事要看监控，却拿到了租户账号，控制台里仍什么都改不了，或者反过来，项目角色过宽，能改实例。两层互不影响。数据库账号管的是SELECT和 DDL。项目角色管的是创建、变配、释放和邀请别人。可以只开一层，也可以两层都开，但不要用一层代替另一层。读完可以带走：决策树、两种只读的权限边界、创建租户时为什么不能沿用预填规格。控制台域名、实例 ID、邮箱用占位符。口令不要写进文档。阅读详情

看了网上，都是安装的v4.2或者更低版本，同时，大部分操作系统选择的是centos 7.9，我这里使用的是anolis23.4 ，其他RHEL10也没有问题。另外，网上单节点的居多，我这里按生产标准安装，只是机器配置是练习的机器，记录一下。

使用命令行部署 OceanBase 数据库生产环境

1.环境准备

1.1.硬件
obd 2c/8g
observer 2c/12g X 3，内存最好是16g以上。

1.2.IP规划
ip 用途
192.168.133.10 obd obconfigserver prometheus granfana
192.168.133.11 observer1 odp obagent
192.168.133.12 observer2 odp obagent
192.168.133.13 observer3 odp obagent

1.3.版本
本次操作系统使用的龙蜥23.4,OB使用的v4.5

os: anolis 23.4,操作系统可以选择最小安装
ob: v4.5.0

1.4 系统设置
对三个OBSERVER 机器的内核参数及资源限制进行设置

配置资源限制
vim /etc/security/limits.conf

* soft nofile 655350
* hard nofile 655350

* soft stack unlimited
* hard stack unlimited

* soft core unlimited
* hard core unlimited

配置内核参数

vim /etc/sysctl.conf

vm.swappiness = 0
vm.max_map_count = 655360
vm.min_free_kbytes = 2097152
vm.overcommit_memory = 0
fs.file-max = 6573688
fs.aio-max-nr = 1048576

使用sysctl -p 让内核参数配置生效。

# sysctl -p

1.5 用户建立
在所有机器，OBD,三个OBSERVER 机器上创建安装用户admin ,可以使用root安装，但建议使用非root用户安装
# useradd admin
# echo ob |passwd --stdin admin

1.6 建立 data及log目录,并授权
在三台OBSERVER机器上创建数据和日志的目录
# mkdir -p /data /redo
# chown -R admin:admin /data /redo

2.安装
2.1 安装 Oceanbase ALL IN ONE 包

选择离线安装

下载 all in one安装包，注意，由于操作系统是最新的操作系统，all in one 安装包，要下载el8的，下载下来如下：oceanbase-all-in-one-4.5.0_20260203.el8.x86_64.tar.gz，
并上传到中控机器

使用admin 用户解压all in one 安装包：
su - admin
$ tar xvf oceanbase-all-in-one-4.5.0_20260203.el8.x86_64.tar.gz

$ cd oceanbase-all-in-one/bin
./install.sh

。。。
If you want to view detailed obd logs, please run: obd display-trace 3fbab2d8-0d70-11f1-a094-000c29d50a70

add auto set env logic to profile: /home/admin/.bash_profile

#########################################################################################
Install Finished
=========================================================================================
Setup Environment: source ~/.oceanbase-all-in-one/bin/env.sh
Quick Start: obd demo
Quick Start (performance): obd perf
Interactive install: obd cluster deploy -i
Use Web Service to install: obd web
Use Web Service to upgrade: obd web upgrade
More Details: obd -h
=========================================================================================

环境变量生效

source ~/.oceanbase-all-in-one/bin/env.sh

2.2 配置 OBD

2.2.1 禁用远程仓库
使用 obd mirror disable remote 命令完成

2.2.3 将安装包添加至本地镜像库

[admin@obd4 local]$ obd mirror clone *.rpm

2.2.4 查看本地镜像库中安装包列表

[admin@obd4 local]$ obd mirror list local

+---------------------------------------------------------------------------------------------------------------------+
| local Package List |
+---------------------------+-----------+------------------------+---------+------------------------------------------+
| name | version | release | arch | md5 |
+---------------------------+-----------+------------------------+---------+------------------------------------------+
| alertmanager | 0.28.1 | 32025073111.el8 | x86_64 | 13b24d72fe5296a68a9dca70193ed693f5697a5e |
| grafana | 7.5.17 | 1 | x86_64 | 1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 |
| obagent | 4.2.4 | 200000022025090416.el8 | x86_64 | a1f4d48503fce2f8b07eb1af3889161c6bc4c264 |
| ob-configserver | 1.0.0 | 2.el8 | x86_64 | 664f93205c913d5dc84e0779d565768fd60f1d5e |
| ob-deploy | 4.2.0 | 1.el8 | x86_64 | eb9188e03fab53aed739672db79f488cb2ef415b |
| obproxy-ce | 4.3.5.0 | 3.el8 | x86_64 | 73d0e9b4cecb53c8ba91f3ef50ac6742baa8be57 |
| ob-sysbench | 1.0.20 | 21.el8 | x86_64 | ae4bb45f91e434a62af366a59787bcfe6069951c |
| obtpcc | 5.0.0 | 1.el8 | x86_64 | 9bb0d729187938dd66fcfdf89eb7c5e9b59b0e58 |
| obtpch | 3.0.0 | 1.el8 | x86_64 | a09e5586ea25223f97169ee64acd7191610ec602 |
| oceanbase-ce | 4.2.1.8 | 108000022024072217.el8 | x86_64 | 67cdfd029a461e9563b4ed301c661479136e58bc |
| oceanbase-ce | 4.5.0.0 | 100000012025112711.el8 | x86_64 | 354e83c2c5a6d296aee92c5c762fd4dcee9d9ac5 |
| oceanbase-ce-libs | 4.2.1.8 | 108000022024072217.el8 | x86_64 | b7a867b144db1900a77c50dff33018adcc523232 |
| oceanbase-ce-libs | 4.5.0.0 | 100000012025112711.el8 | x86_64 | 9bbee841e80f1a6682b668a14ec36a38a0354bf0 |
| oceanbase-ce-utils | 4.2.1.8 | 108000022024072217.el8 | x86_64 | 8830434f4fde3a60dcfa9308182aa7d07163bda1 |
| oceanbase-ce-utils | 4.5.0.0 | 100000012025112711.el8 | x86_64 | f1dd0cd4a39ae6a7996539732b419d8500523e5f |
| oceanbase-diagnostic-tool | 3.7.1 | 12025102215.el8 | x86_64 | 92fb7e58edd3dd5507dfeed0e4fbc1562a50fae7 |
| ocp-agent-ce | 4.4.0 | 20251114143405.el7 | aarch64 | 6c619c8406abb57771d26e29ea7b0f58d5fed3de |
| ocp-agent-ce | 4.4.0 | 20251114143405.el7 | x86_64 | f8dd0ebfaa2c2f413fb3eafb922cfabde114d32f |
| ocp-server-ce | 4.4.0 | 20251114143405.el7 | noarch | f673d693677a2c640f925ad2127a604aaebf00bf |
| openjdk-jre | 17.0.16_8 | 92025080421.el8 | x86_64 | 6bd4c45a7b95d55433a18f244cea182232003d50 |
| prometheus | 2.37.1 | 10000102022110211.el8 | x86_64 | e4f8a3e784512fca75bf1b3464247d1f31542cb9 |
+---------------------------+-----------+------------------------+---------+------------------------------------------+

2.2.5 选择配置文件

在 ~/.oceanbase-all-in-one/obd/usr/obd/example 位置，有模板文件，我们选择 all-components.yaml作为模板文件
cp ~/.oceanbase-all-in-one/obd/usr/obd/example/all-components.yaml ~/deploy.yaml

2.2.6 修改配置文件
vim deploy.yaml

user:
username: admin
password: ob
oceanbase-ce:
depends:
- ob-configserver
servers:
- name: server1
ip: 192.168.133.11
- name: server2
ip: 192.168.133.12
- name: server3
ip: 192.168.133.13
global:
devname: ens160
memory_limit: 10G # 使用free -g 可用的内存
system_memory: 6G # 低于 memory_limit的75%
datafile_size: 50G # Size of the data file.
log_disk_size: 20G # The size of disk space used by the clog files.
enable_syslog_wf: false
max_syslog_file_count: 4

appname: obcluster

mysql_port: 2881
rpc_port: 2882
obshell_port: 2886
home_path: /home/admin/observer
data_dir: /data
redo_dir: /redo

server1:
zone: zone1
server2:
zone: zone2
server3:
zone: zone3

obproxy-ce:
depends:
- oceanbase-ce
- ob-configserver
servers:
- name: server1
ip: 192.168.133.11

- name: server2
ip: 192.168.133.12

- name: server3
ip: 192.168.133.13

global:
listen_port: 2883
prometheus_listen_port: 2884
home_path: /home/admin/obtest/obproxy
enable_cluster_checkout: false
skip_proxy_sys_private_check: true
enable_strict_kernel_release: false
obproxy_sys_password: ob
observer_sys_password: ob
obagent:
depends:
- oceanbase-ce
servers:
- name: server1
ip: 192.168.133.11
- name: server2
ip: 192.168.133.12
- name: server3
ip: 192.168.133.13
global:
home_path: /home/admin/obagent

prometheus:
servers:
- 192.168.133.10
depends:
- obagent
global:
home_path: /home/admin/prometheus
port: 9090
data_dir: /home/admin/prometheus/data
basic_auth_users:
admin: ob

grafana:
servers:
- 192.168.133.10
depends:
- prometheus
global:
home_path: /home/admin/grafana
login_password: 'oceanbase'

2.3 部署 OceanBase 集群

[admin@obd4 ~]$ obd cluster deploy obtest -c deploy.yaml

启动集群

[admin@obd4 ~]$ obd cluster start obtest

Wait for observer init ok
+--------------------------------------------------+
| oceanbase-ce |
+----------------+---------+------+-------+--------+
| ip | version | port | zone | status |
+----------------+---------+------+-------+--------+
| 192.168.133.11 | 4.5.0.0 | 2881 | zone1 | ACTIVE |
| 192.168.133.12 | 4.5.0.0 | 2881 | zone2 | ACTIVE |
| 192.168.133.13 | 4.5.0.0 | 2881 | zone3 | ACTIVE |
+----------------+---------+------+-------+--------+
obclient -h192.168.133.11 -P2881 -uroot@sys -p'9Ppk3kstwd9YFfjTiOQW' -Doceanbase -A

cluster unique id: 844da582-3e09-59ae-a25d-43c59f91d5c3-19c758fe5a4-00000504

Connect to obproxy ok
+--------------------------------------------------------------------+
| obproxy-ce |
+----------------+------+-----------------+-----------------+--------+
| ip | port | prometheus_port | rpc_listen_port | status |
+----------------+------+-----------------+-----------------+--------+
| 192.168.133.11 | 2883 | 2884 | 2885 | active |
| 192.168.133.12 | 2883 | 2884 | 2885 | active |
| 192.168.133.13 | 2883 | 2884 | 2885 | active |
+----------------+------+-----------------+-----------------+--------+
obclient -h192.168.133.11 -P2883 -uroot@proxysys -p'ob' -Doceanbase -A

Connect to Obagent ok
+-------------------------------------------------------------------+
| obagent |
+----------------+--------------------+--------------------+--------+
| ip | mgragent_http_port | monagent_http_port | status |
+----------------+--------------------+--------------------+--------+
| 192.168.133.11 | 8089 | 8088 | active |
| 192.168.133.12 | 8089 | 8088 | active |
| 192.168.133.13 | 8089 | 8088 | active |
+----------------+--------------------+--------------------+--------+
Connect to Prometheus ok
+-------------------------------------------------------+
| prometheus |
+----------------------------+------+----------+--------+
| url | user | password | status |
+----------------------------+------+----------+--------+
| http://192.168.133.10:9090 | | | active |
+----------------------------+------+----------+--------+
Connect to grafana ok
+-----------------------------------------------------------------------+
| grafana |
+----------------------------------------+-------+-------------+--------+
| url | user | password | status |
+----------------------------------------+-------+-------------+--------+
| http://192.168.133.10:3000/d/oceanbase | admin | 'oceanbase' | active |
+----------------------------------------+-------+-------------+--------+
obtest running
Trace ID: 495580e0-0d82-11f1-885d-000c29d50a70
If you want to view detailed obd logs, please run: obd display-trace 495580e0-0d82-11f1-885d-000c29d50a70
[admin@obd4 ~]$