oceanbase 4.0小鱼发布以来，有好多心动的功能，主要体现在单机分布式一体化架构，降低了使用门槛。2023年3月25日，4.1又发布了，面向开发者提升性能和效率。现将web方式部署过程记录如下：
操作系统版本
[root@node1 ~]# cat /etc/os-release
NAME=“openEuler”
VERSION=“20.03 (LTS-SP3)”
ID=“openEuler”
VERSION_ID=“20.03”
PRETTY_NAME=“openEuler 20.03 (LTS-SP3)”
ANSI_COLOR=“0;31”
硬盘空间情况
内存大小
下载oceanbase 4.1的安装包
wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/oceanbase-all-in-one/7/x86_64/oceanbase-all-in-one-4.1.0.0-100120230323143519.el7.x86_64.tar.gz
解压安装包
[root@node1 ~]# tar xvf oceanbase-all-in-one-4.1.0.0-100120230323143519.el7.x86_64.tar.gz
[root@node1 ~]# cd oceanbase-all-in-one/bin
[root@node1 bin]# ls
env.sh install.sh uninstall.sh
安装
[root@node1 bin]# sh install.sh
name: grafana
version: 7.5.17
release:1
arch: x86_64
md5: 1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6
add /root/oceanbase-all-in-one/rpms/grafana-7.5.17-1.el7.x86_64.rpm to local mirror
name: obagent
version: 1.2.0
release:4.el7
arch: x86_64
md5: 0e8f5ee68c337ea28514c9f3f820ea546227fa7e
add /root/oceanbase-all-in-one/rpms/obagent-1.2.0-4.el7.x86_64.rpm to local mirror
name: obagent
version: 1.3.0
release:22.el7
arch: x86_64
md5: d57fbb4962b2fbecb6282358c59295fdfba4d6ac
add /root/oceanbase-all-in-one/rpms/obagent-1.3.0-22.el7.x86_64.rpm to local mirror
name: obproxy-ce
version: 4.0.0
release:5.el7
arch: x86_64
md5: de53232a951184fad75b15884458d85e31d2f6c3
add /root/oceanbase-all-in-one/rpms/obproxy-ce-4.0.0-5.el7.x86_64.rpm to local mirror
name: obproxy-ce
version: 4.1.0.0
release:7.el7
arch: x86_64
md5: 2a9d9bf67f179dcca2a8c9e7c77373d94e7e2abe
add /root/oceanbase-all-in-one/rpms/obproxy-ce-4.1.0.0-7.el7.x86_64.rpm to local mirror
name: oceanbase-ce
version: 4.0.0.0
release:100000282022112511.el7
arch: x86_64
md5: 75ec57ebe42718b386901357cef1e5d3864748ee
add /root/oceanbase-all-in-one/rpms/oceanbase-ce-4.0.0.0-100000282022112511.el7.x86_64.rpm to local mirror
name: oceanbase-ce
version: 4.1.0.0
release:100000192023032010.el7
arch: x86_64
md5: 8439ecf8db5e0649bd49671b41ea9e8c85756b63
add /root/oceanbase-all-in-one/rpms/oceanbase-ce-4.1.0.0-100000192023032010.el7.x86_64.rpm to local mirror
name: oceanbase-ce-libs
version: 4.0.0.0
release:100000282022112511.el7
arch: x86_64
md5: c5f1e971cc335efe36233cae291a170a0f518e19
add /root/oceanbase-all-in-one/rpms/oceanbase-ce-libs-4.0.0.0-100000282022112511.el7.x86_64.rpm to local mirror
name: oceanbase-ce-libs
version: 4.1.0.0
release:100000192023032010.el7
arch: x86_64
md5: a83b1dd1cab44d3f610d439931322be7a08555f2
add /root/oceanbase-all-in-one/rpms/oceanbase-ce-libs-4.1.0.0-100000192023032010.el7.x86_64.rpm to local mirror
name: ocp-express
version: 1.0.0
release:100000432023032015.el7
arch: x86_64
md5: 42c6fc921063f24f9e1072d75bfa7f21f42146e3
add /root/oceanbase-all-in-one/rpms/ocp-express-1.0.0-100000432023032015.el7.x86_64.rpm to local mirror
name: prometheus
version: 2.37.1
release:10000102022110211.el7
arch: x86_64
md5: 58913c7606f05feb01bc1c6410346e5fc31cf263
add /root/oceanbase-all-in-one/rpms/prometheus-2.37.1-10000102022110211.el7.x86_64.rpm to local mirror
Trace ID: ee7e80b2-e0b2-11ed-878e-0800271cae62
If you want to view detailed obd logs, please run: obd display-trace ee7e80b2-e0b2-11ed-878e-0800271cae62
Disable remote ok
Trace ID: ef07e6b8-e0b2-11ed-b02a-0800271cae62
If you want to view detailed obd logs, please run: obd display-trace ef07e6b8-e0b2-11ed-b02a-0800271cae62
add auto set env logic to profile: /root/.bash_profile
#####################################################################
Install Finished
=====================================================================
Setup Environment: source ~/.oceanbase-all-in-one/bin/env.sh
Start Web Service: obd web
Quick Start: obd demo
More Details: obd -h
=====================================================================
这里不仅有单机示例数据库demo,还增加web方式集群部署工具。
让环境变量生效
[root@node1 bin]# source ~/.oceanbase-all-in-one/bin/env.sh
启动web
[root@node1 bin]# obd web
start OBD WEB in 0.0.0.0:8680
please open http://192.168.56.40:8680
用浏览器登录
有完全部署和精简部署两种模式
完全部署比精简部署多了OBProxy ,OCPExpress和OBAent三个组件。
选择精简部署模式
输入节点IP和软件安装路径，进入下一步
因虚拟机资源有限，选择最小可用模式，并记录root@sys密码。
对datafile_size和system_memory，log_disk_size改小，预检查通不过。
预检查过程中还出现时钟不一致问题,将ntp改为chrony,
全部预检查通过
开始部署
部署完成，提示保留相关信息
复制出来的信息如下
[{"component":"oceanbase-ce","access_url":"192.168.56.40:2881","user":"root","password":"]EreWzdY}Qn9FmivP35lOZ8Z","connect_url":"obclient -h192.168.56.40 -P2881 -uroot -p']EreWzdY}Qn9FmivP35lOZ8Z' -Doceanbase -A"}]
json格式用来登录的信息
用admin用户登录到任一节点，登录数据库
[admin@node2 ~]$ obclient -h192.168.56.40 -P2881 -uroot -p']EreWzdY}Qn9FmivP35lOZ8Z' -Doceanbase -A
Welcome to the OceanBase. Commands end with ; or \g.
Your MySQL connection id is 3221525861
Server version: 5.7.25 OceanBase_CE 4.1.0.0 (r100000192023032010-0265dfc6d00ff4f0ff4ad2710504a18962abaef6) (Built Mar 20 2023 10:12:57)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [oceanbase]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| LBACSYS |
| mysql |
| oceanbase |
| ORAAUDITOR |
| SYS |
| test |
+--------------------+
7 rows in set (0.015 sec)
部署后空间占用
[root@node1 ]# cd /opt/myoceanbase/
[root@node1 myoceanbase]# ls
oceanbase
[root@node1 myoceanbase]# du -sh
14G
部署的目录结构
[root@node1 myoceanbase]# tree -l
.
└── oceanbase
├── admin
│ ├── dbms_application_body_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_application_body_mysql.sql
│ ├── dbms_application_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_application_mysql.sql
│ ├── dbms_ash_internal_body.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_ash_internal_body.sql
│ ├── dbms_ash_internal.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_ash_internal.sql
│ ├── dbms_monitor_body_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_monitor_body_mysql.sql
│ ├── dbms_monitor_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_monitor_mysql.sql
│ ├── dbms_resource_manager_body_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_resource_manager_body_mysql.sql
│ ├── dbms_resource_manager_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_resource_manager_mysql.sql
│ ├── dbms_rls_body.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_rls_body.sql
│ ├── dbms_rls.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_rls.sql
│ ├── dbms_scheduler_mysql_body.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_scheduler_mysql_body.sql
│ ├── dbms_scheduler_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_scheduler_mysql.sql
│ ├── dbms_session_body_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_session_body_mysql.sql
│ ├── dbms_session_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_session_mysql.sql
│ ├── dbms_stats_body_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_stats_body_mysql.sql
│ ├── dbms_stats_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_stats_mysql.sql
│ ├── dbms_udr_body_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_udr_body_mysql.sql
│ ├── dbms_udr_body.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_udr_body.sql
│ ├── dbms_udr_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_udr_mysql.sql
│ ├── dbms_udr.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_udr.sql
│ ├── __dbms_upgrade_body_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./__dbms_upgrade_body_mysql.sql
│ ├── __dbms_upgrade_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./__dbms_upgrade_mysql.sql
│ ├── dbms_workload_repository_body.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_workload_repository_body.sql
│ ├── dbms_workload_repository.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_workload_repository.sql
│ ├── dbms_xplan_mysql_body.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_xplan_mysql_body.sql
│ ├── dbms_xplan_mysql.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./dbms_xplan_mysql.sql
│ ├── json_element_type_body.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./json_element_type_body.sql
│ ├── json_element_type.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./json_element_type.sql
│ ├── json_object_type_body.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./json_object_type_body.sql
│ └── json_object_type.sql -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/admin/./json_object_type.sql
├── audit
│ └── observer_167173_20230422105447138679453.aud
├── bin
│ ├── import_time_zone_info.py -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/bin/./import_time_zone_info.py
│ └── observer -> /root/.obd/repository/oceanbase-ce/4.1.0.0/8439ecf8db5e0649bd49671b41ea9e8c85756b63/bin/./observer
├── etc
│ ├── default_srs_data_mysql.sql
│ ├── fill_help_tables-ob.sql
│ ├── observer.config.bin
│ ├── observer.config.bin.history
│ ├── oceanbase_upgrade_dep.yml
│ ├── timezone_V1.log
│ ├── upgrade_checker.py
│ ├── upgrade_health_checker.py
│ ├── upgrade_post.py
│ └── upgrade_pre.py
├── etc2
│ ├── observer.conf.bin
│ └── observer.conf.bin.history
├── etc3
│ ├── observer.conf.bin
│ └── observer.conf.bin.history
├── lib
├── log
│ ├── election.log
│ ├── election.log.wf
│ ├── observer.log
│ ├── observer.log.20230422112938924
│ ├── observer.log.wf
│ ├── rootservice.log
│ ├── rootservice.log.wf
│ ├── trace.log
│ └── trace.log.20230422113416778
├── run
│ ├── lua.sock
│ ├── mysql.sock
│ └── observer.pid
└── store
├── clog
│ ├── log_pool
│ │ ├── 10
│ │ ├── 38
│ │ ├── 39
│ │ ├── 4
│ │ ├── 40
│ │ ├── 41
│ │ ├── 42
│ │ ├── 43
│ │ ├── 44
│ │ ├── 45
│ │ ├── 46
│ │ ├── 47
│ │ ├── 5
│ │ ├── 6
│ │ ├── 7
│ │ ├── 8
│ │ ├── 9
│ │ └── meta
│ └── tenant_1
│ └── 1
│ ├── log
│ │ └── 0
│ └── meta
│ └── 0
├── slog
│ ├── server
│ │ └── 1
│ └── tenant_1
│ └── 1
└── sstable
└── block_file
21 directories, 111 files
查看集群名称
[root@node1 myoceanbase]# obd cluster list
+----------------------------------------------------------------+
| Cluster List |
+-------------+--------------------------------+-----------------+
| Name | Configuration Path | Status (Cached) |
+-------------+--------------------------------+-----------------+
| myoceanbase | /root/.obd/cluster/myoceanbase | running |
| demo | /root/.obd/cluster/demo | deployed |
+-------------+--------------------------------+-----------------+
Trace ID: 902bb824-e0bf-11ed-95a1-0800271cae62
If you want to view detailed obd logs, please run: obd display-trace 902bb824-e0bf-11ed-95a1-0800271cae62
停止集群
[root@node1 myoceanbase]# obd cluster stop myoceanbase
Get local repositories ok
Search plugins ok
Open ssh connection ok
Stop observer ok
myoceanbase stopped
Trace ID: d2b40fd4-e0bf-11ed-96f3-0800271cae62
If you want to view detailed obd logs, please run: obd display-trace d2b40fd4-e0bf-11ed-96f3-0800271cae62
启动集群
[root@node1 myoceanbase]# obd cluster start myoceanbase
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
Start observer ok
observer program health check ok
Connect to observer ok
Wait for observer init ok
+-------------------------------------------------+
| observer |
+---------------+---------+------+-------+--------+
| ip | version | port | zone | status |
+---------------+---------+------+-------+--------+
| 192.168.56.40 | 4.1.0.0 | 2881 | zone1 | ACTIVE |
| 192.168.56.41 | 4.1.0.0 | 2881 | zone2 | ACTIVE |
| 192.168.56.42 | 4.1.0.0 | 2881 | zone3 | ACTIVE |
+---------------+---------+------+-------+--------+
obclient -h192.168.56.40 -P2881 -uroot -p']EreWzdY}Qn9FmivP35lOZ8Z' -Doceanbase -A
myoceanbase running
Trace ID: 0e67a086-e0c0-11ed-9437-0800271cae62
If you want to view detailed obd logs, please run: obd display-trace 0e67a086-e0c0-11ed-9437-0800271cae62
最后修改时间：2023-05-08 07:19:35
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
