OceanBase数据库社区版：

兼容MySQL的单机环球一体化数据库，具有左右架构，支持金融级高可用、透明水平扩展、多元化事务、多机场和语法兼容等企业级特性。OceanBase社区版数据库开源开源，与MySQL兼容、对接虚拟化和大数据技术及产品，支持多种图形化的开发工具、运维监控工具和数据迁移工具；同时社区版提供更好的开放接口和丰富的生态能力，支持企业或现实的个人化业务需求。

规划部署：

下载安装包：

• OceanBase软件下载中心

  

安装部署

OBD：10.10.5.136

• 1、下载最新版本一体式安装包，并将其上传到<10.10.5.136>任意目录下。
• 2、解压安装包并安装

• 4、加载环境变量

[root@localhost ~]# source ~/.oceanbase-all-in-one/bin/env.sh 

• 5、安装演示

[root@localhost ~]# obd demo
Package obagent-4.2.2-100000042024011120.el7 is available.
Package oceanbase-ce-4.2.1.9-109010012024101414.el7 is available.
Package prometheus-2.37.1-10000102022110211.el7 is available.
Package grafana-7.5.17-1 is available.
Package obproxy-ce-4.3.1.0-4.el7 is available.
install obagent-4.2.2 for local ok
install oceanbase-ce-4.2.1.9 for local ok
install prometheus-2.37.1 for local ok
install grafana-7.5.17 for local ok
install obproxy-ce-4.3.1.0 for local ok
Cluster param config check ok
Open ssh connection ok
Generate obproxy configuration ok
Generate grafana configuration ok
Generate prometheus configuration ok
Generate observer configuration ok
Generate obagent configuration ok
+--------------------------------------------------------------------------------------------+
|                                          Packages                                          |
+--------------+---------+------------------------+------------------------------------------+
| Repository   | Version | Release                | Md5                                      |
+--------------+---------+------------------------+------------------------------------------+
| obagent      | 4.2.2   | 100000042024011120.el7 | 19739a07a12eab736aff86ecf357b1ae660b554e |
| oceanbase-ce | 4.2.1.9 | 109010012024101414.el7 | 67b8a2b699db96053d3f8d8ba3116b0e97a27722 |
| prometheus   | 2.37.1  | 10000102022110211.el7  | 58913c7606f05feb01bc1c6410346e5fc31cf263 |
| grafana      | 7.5.17  | 1                      | 1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 |
| obproxy-ce   | 4.3.1.0 | 4.el7                  | 835f4803c1f4da186439323b66c51db4662678a3 |
+--------------+---------+------------------------+------------------------------------------+
Repository integrity check ok
Load param plugin ok
Open ssh connection ok
Parameter check ok
Cluster status check ok
Initializes obagent work home ok
Initializes observer work home ok
Initializes prometheus work home ok
Initializes grafana work home ok
Initializes obproxy work home ok
Remote obagent-4.2.2-100000042024011120.el7-19739a07a12eab736aff86ecf357b1ae660b554e repository install ok
Remote obagent-4.2.2-100000042024011120.el7-19739a07a12eab736aff86ecf357b1ae660b554e repository lib check ok
Remote oceanbase-ce-4.2.1.9-109010012024101414.el7-67b8a2b699db96053d3f8d8ba3116b0e97a27722 repository install ok
Remote oceanbase-ce-4.2.1.9-109010012024101414.el7-67b8a2b699db96053d3f8d8ba3116b0e97a27722 repository lib check !!
Remote prometheus-2.37.1-10000102022110211.el7-58913c7606f05feb01bc1c6410346e5fc31cf263 repository install ok
Remote prometheus-2.37.1-10000102022110211.el7-58913c7606f05feb01bc1c6410346e5fc31cf263 repository lib check ok
Remote grafana-7.5.17-1-1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 repository install ok
Remote grafana-7.5.17-1-1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 repository lib check ok
Remote obproxy-ce-4.3.1.0-4.el7-835f4803c1f4da186439323b66c51db4662678a3 repository install ok
Remote obproxy-ce-4.3.1.0-4.el7-835f4803c1f4da186439323b66c51db4662678a3 repository lib check ok
Try to get lib-repository
Package oceanbase-ce-libs-4.2.1.9-109010012024101414.el7 is available.
install oceanbase-ce-libs-4.2.1.9 for local ok
Remote oceanbase-ce-libs-4.2.1.9-109010012024101414.el7-03d52091e97a2207a9d8abcf601d62cc207142b7 repository install ok
Remote oceanbase-ce-4.2.1.9-109010012024101414.el7-67b8a2b699db96053d3f8d8ba3116b0e97a27722 repository lib check ok
demo deployed
Get local repositories ok
Search plugins ok
Load cluster param plugin ok
Open ssh connection ok
Check before start observer x
[WARN] OBD-1011: (127.0.0.1) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536)
[WARN] OBD-1007: (127.0.0.1) The recommended number of open files is 655350 (Current value: 65535)
[ERROR] OBD-1007: (127.0.0.1) The value of the ulimit parameter "max user processes" must not be less than 120000 (Current value: 31204), Please execute `echo -e "* soft nproc 120000\n* hard nproc 120000" >> /etc/security/limits.d/nproc.conf` as root in 127.0.0.1. if it dosen't work, please check whether UsePAM is yes in /etc/ssh/sshd_config.
[WARN] OBD-1007: (127.0.0.1) The recommended number of core file size is unlimited (Current value: 0)
[WARN] OBD-1007: (127.0.0.1) The recommended number of stack size is unlimited (Current value: 8192)
[WARN] OBD-1017: (127.0.0.1) The value of the "vm.max_map_count" must be within [327600, 1310720] (Current value: 65530, Recommended value: 655360)
[WARN] OBD-1017: (127.0.0.1) The value of the "fs.file-max" must be greater than 6573688 (Current value: 791443, Recommended value: 6573688)
[WARN] OBD-2000: (127.0.0.1) not enough memory. (Free: 132M, Need: 6G)
[WARN] OBD-1012: (127.0.0.1) clog and data use the same disk (/)

Check before start obproxy ok
Check before start obagent ok
Check before start prometheus ok
Check before start grafana ok
See https://www.oceanbase.com/product/ob-deployer/error-codes .
Trace ID: eeb9aeb8-a027-11ef-9e41-005056801edc
If you want to view detailed obd logs, please run: obd display-trace eeb9aeb8-a027-11ef-9e41-005056801edc

启动web配置数据库

• 默认端口：8680
• 命令指定端口：obd web -p PORT

• 安装

  

  

  

  

  

  

  

• OBD-1007检查报错

  

• 解决处理

• 检查再次问题，报错：OBD-2008

  

• 解决方案找到很方便

  

配置时钟源-解决：OBD-2008

OceanBase相关产品之间，在上都有一些隐含的联系，因此要求OceanBase产品的所有服务器的物理要保持同步，同步转动控制在2秒以内，甚至更小。集群的多个节点以及OCP节点的时钟必须配置时钟同步服务NTP或chrony，保证所有节点的时钟偏差在2秒以内。本文介绍如何为集群内的多台机器配置NTP时间源。您
如果是单机安装OceanBase数据库，无需设置时间。

• 每台机器上安装NTP

• 配置ntp.conf文件

• 服务器端测试

• 客户端配置
  – 安装
  – 客户端配置

• 客户端测试

检查通过

开始部署

登录数据库

• obclient -h10.10.5.163 -P2881 -uroot -p’OraclE1234{}’ -Doceanbase -A

  

登录OCP

• http://10.10.5.136:8180 账号：amdin 密码：OraclE1234{}

  

• 监控界面

  

登录 OBP

• obclient -h10.10.5.136 -P2883 -uroot@proxysys -p’}WozTBO6#’ -Doceanbase -A

  

学习小结

• 通过OBD白屏配置等各类图形界面配置非常方便，尤其是这种多种服务器的分配配置，统一管理配置非常方便；
• 建议安装规范文档，有一个前期准备或要求，比如文档上是用admin用户安装的，找了半天没找到admin用户创建的相关内容，我用root安装到找到一半了，admin创建的命令已经没办法回退了。

  想了解更多干货，可通过下方扫码关注

  

  可扫码添加上智启元官方客服微信👇