电商购物网站,长沙官网网站制作公司,建设网站如何赢利,做的好的ppt下载网站文章目录 说明机器软硬件要求指导文档本次部署环境说明 OceanBase单机部署#xff08;Docker#xff09;一#xff1a;拉取 OceanBase 数据库相关镜像二#xff1a;启动 OceanBase 数据库实例完整启动日志展示 三#xff1a;连接实例遇到报错#xff1a;没有mysql客户端 … 文章目录 说明机器软硬件要求指导文档本次部署环境说明 OceanBase单机部署Docker一拉取 OceanBase 数据库相关镜像二启动 OceanBase 数据库实例完整启动日志展示 三连接实例遇到报错没有mysql客户端 四挂载数据卷 说明
机器软硬件要求
机器有足够的资源可以执行至少 2 个物理核心和 4GB 内存官方推荐8g及以上但是4g内存拿来学习使用也是可以官方提供的试用的服务就是4g内存Docker环境推荐使用1panel进行服务器的可视化管理和维护
指导文档
参考OceanBase官方的部署方法dockerHub的镜像操作指南
本次部署环境说明
系统armbian( debian-11.7)cpu:Cortex-A55 4c内存4G硬盘容量32G
OceanBase单机部署Docker
一拉取 OceanBase 数据库相关镜像
拉取 OceanBase 数据库最新镜像,默认安装最新版可在OceanBase镜像地址进行版本选择docker pull oceanbase/oceanbase-ce二启动 OceanBase 数据库实例
启动 OceanBase 实例时执行以下命令
#根据当前容器部署最大规格实例
docker run -p 2881:2881 --name obstandalone -e MINI_MODE0 -d oceanbase/oceanbase-ce
#部署 mini 的独立实例
docker run -p 2881:2881 --name obstandalone -e MINI_MODE1 -d oceanbase/oceanbase-ce挂载数据卷版本 docker run -d -p 2881:2881 -v $PWD/ob:/root/ob -v $PWD/obd:/root/.obd --name oceanbase oceanbase/oceanbase-ce注意docker 镜像将数据保存到 /root/ob 目录默认。应同时绑定 /root/ob 和 /root/.obd。如果只绑定 /root/ob 目录则无法启动新的 docker 镜像因为 docker 镜像 oceanbase-ce 使用 obd 来管理数据库集群而新的 docker 容器中没有关于数据库集群的信息 启动预计需要 2~5 分钟。执行以下命令如果返回 boot success!则表示启动成功。 需要耐心等待因为初始化需要很多操作需要一些时间cpu干到100%是正常的现象着急的话建议执行命令参考下面提供的完整日志信息进行查看
rootarmbian:~# docker logs obstandalone | tail -1
boot success!完整启动日志展示
/// STEP 1: Config Generation ///
oceanbase-ce docker in mini mode
/// phase end: 0.155 s ///
/// STEP 2: Ob-deploy mirror clone ///
name: ob-configserver
version: 1.0.0
release:2.el7
arch: aarch64
md5: 35c121739b84e26b57dae1276ce33ba1186411e3
add /root/pkg/ob-configserver-1.0.0-2.el7.aarch64.rpm to local mirror
name: obagent
version: 4.2.1
release:100000092023101717.el7
arch: aarch64
md5: 4c0f5de0abc7c633454642540cb458b7a855aed2
add /root/pkg/obagent-4.2.1-100000092023101717.el7.aarch64.rpm to local mirror
name: oceanbase-ce
version: 4.2.1.2
release:102000042023120514.el7
arch: aarch64
md5: 080bd5dac6f6253fd2682331be3f1353856fd240
add /root/pkg/oceanbase-ce-4.2.1.2-102000042023120514.el7.aarch64.rpm to local mirror
name: oceanbase-ce-libs
version: 4.2.1.2
release:102000042023120514.el7
arch: aarch64
md5: f1db7c86312516a4d6bb4672dc1b4848a070b315
add /root/pkg/oceanbase-ce-libs-4.2.1.2-102000042023120514.el7.aarch64.rpm to local mirror
Trace ID: 90abbfc4-9c21-11ee-a331-0242ac110003
If you want to view detailed obd logs, please run: obd display-trace 90abbfc4-9c21-11ee-a331-0242ac110003
-----------------------------------------------------------------------------------------------------------
| local Package List |
-------------------------------------------------------------------------------------------------------
| name | version | release | arch | md5 |
-------------------------------------------------------------------------------------------------------
| ob-configserver | 1.0.0 | 2.el7 | aarch64 | 35c121739b84e26b57dae1276ce33ba1186411e3 |
| obagent | 4.2.1 | 100000092023101717.el7 | aarch64 | 4c0f5de0abc7c633454642540cb458b7a855aed2 |
| oceanbase-ce | 4.2.1.2 | 102000042023120514.el7 | aarch64 | 080bd5dac6f6253fd2682331be3f1353856fd240 |
| oceanbase-ce-libs | 4.2.1.2 | 102000042023120514.el7 | aarch64 | f1db7c86312516a4d6bb4672dc1b4848a070b315 |
-------------------------------------------------------------------------------------------------------
Trace ID: 929fccc6-9c21-11ee-83e5-0242ac110003
If you want to view detailed obd logs, please run: obd display-trace 929fccc6-9c21-11ee-83e5-0242ac110003
/// phase end: 6.511 s ///
/// STEP 3: Ob-deploy deploy ///
Local deploy is empty
Trace ID: 944ce3f6-9c21-11ee-9cd1-0242ac110003
If you want to view detailed obd logs, please run: obd display-trace 944ce3f6-9c21-11ee-9cd1-0242ac110003
/// STEP 4: Ob-deploy autodeploy ///
Dev Mode: ON
Trace ID: 9603be54-9c21-11ee-b213-0242ac110003
If you want to view detailed obd logs, please run: obd display-trace 9603be54-9c21-11ee-b213-0242ac110003
[WARN] Use centos 7 remote mirror repository for anolis 8.8
Package oceanbase-ce-4.2.1.2-102000042023120514.el7 is available.
[WARN] Use centos 7 remote mirror repository for anolis 8.8
Package obagent-4.2.1-100000092023101717.el7 is available.
install oceanbase-ce-4.2.1.2 for local ok
install obagent-4.2.1 for local ok
Cluster param config check ok
Open ssh connection ok
Generate observer configuration ok
Generate obagent configuration ok
[WARN] Use centos 7 remote mirror repository for anolis 8.8
[WARN] Use centos 7 remote mirror repository for anolis 8.8
--------------------------------------------------------------------------------------------
| Packages |
-----------------------------------------------------------------------------------------
| Repository | Version | Release | Md5 |
-----------------------------------------------------------------------------------------
| oceanbase-ce | 4.2.1.2 | 102000042023120514.el7 | 080bd5dac6f6253fd2682331be3f1353856fd240 |
| obagent | 4.2.1 | 100000092023101717.el7 | 4c0f5de0abc7c633454642540cb458b7a855aed2 |
-----------------------------------------------------------------------------------------
Repository integrity check ok
Parameter check ok
Cluster status check ok
Initializes observer work home ok
Initializes obagent work home ok
Remote oceanbase-ce-4.2.1.2-102000042023120514.el7-080bd5dac6f6253fd2682331be3f1353856fd240 repository install ok
Remote oceanbase-ce-4.2.1.2-102000042023120514.el7-080bd5dac6f6253fd2682331be3f1353856fd240 repository lib check !!
Remote obagent-4.2.1-100000092023101717.el7-4c0f5de0abc7c633454642540cb458b7a855aed2 repository install ok
Remote obagent-4.2.1-100000092023101717.el7-4c0f5de0abc7c633454642540cb458b7a855aed2 repository lib check ok
Try to get lib-repository
[WARN] Use centos 7 remote mirror repository for anolis 8.8
Package oceanbase-ce-libs-4.2.1.2-102000042023120514.el7 is available.
install oceanbase-ce-libs-4.2.1.2 for local ok
Remote oceanbase-ce-libs-4.2.1.2-102000042023120514.el7-f1db7c86312516a4d6bb4672dc1b4848a070b315 repository install ok
Remote oceanbase-ce-4.2.1.2-102000042023120514.el7-080bd5dac6f6253fd2682331be3f1353856fd240 repository lib check ok
obcluster deployed
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
[WARN] OBD-1011: (172.17.0.3) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536)
[WARN] OBD-1007: (172.17.0.3) The recommended number of stack size is unlimited (Current value: 8192)
[WARN] OBD-1017: (172.17.0.3) The value of the vm.max_map_count must be within [327600, 1310720] (Current value: 262144, Recommended value: 655360)
[WARN] OBD-2000: (172.17.0.3) not enough memory. (Free: 192.7M, Buff/Cache: 3.0G, Need: 6.0G)
[WARN] OBD-1012: (172.17.0.3) clog and data use the same disk (/)Check before start obagent ok
Start observer ok
observer program health check ok
Connect to observer ok
Initialize oceanbase-ce ok
Start obagent ok
obagent program health check ok
Connect to Obagent ok
Wait for observer init ok
----------------------------------------------
| observer |
------------------------------------------
| ip | version | port | zone | status |
------------------------------------------
| 172.17.0.3 | 4.2.1.2 | 2881 | zone1 | ACTIVE |
------------------------------------------
obclient -h172.17.0.3 -P2881 -uroot -Doceanbase -A---------------------------------------------------------------
| obagent |
------------------------------------------------------------
| ip | mgragent_http_port | monagent_http_port | status |
------------------------------------------------------------
| 172.17.0.3 | 8089 | 8088 | active |
------------------------------------------------------------
obcluster running
Trace ID: 97a8f238-9c21-11ee-b805-0242ac110003
If you want to view detailed obd logs, please run: obd display-trace 97a8f238-9c21-11ee-b805-0242ac110003
/// phase end: 180.265 s ///
/// STEP 5: Ob-deploy Create Tenant ///
Get local repositories and plugins ok
Open ssh connection ok
Connect to observer ok
Create tenant test ok
Trace ID: 02cee2b6-9c22-11ee-a370-0242ac110003
If you want to view detailed obd logs, please run: obd display-trace 02cee2b6-9c22-11ee-a370-0242ac110003
/// phase end: 122.693 s ///
deploy success!
boot success!三连接实例
oceanbase-ce 镜像安装了 OceanBase 数据库客户端 OBClient并提供了默认连接脚本 ob-mysql# 可以通过 root 用户连接到 oceanbase无需密码
docker exec -it obstandalone ob-mysql sys # 使用 root 用户登录集群的 sys 租户
docker exec -it obstandalone ob-mysql root # 使用 root 用户登录集群的 test 租户
docker exec -it obstandalone ob-mysql test # 使用 test 用户登录集群的 test 租户使用您本机的 OBClient 或者 MySQL 客户端连接实例obclient -urootsys -h127.1 -P2881连接成功rootarmbian:~# mysql -uroot -h127.1 -P2881
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 3221487879
Server version: 5.7.25 OceanBase_CE 4.2.1.2 (r102000042023120514-ccdde7d34de421336c5362483d64bf2b73348bd4) (Built Dec 5 2023 14:34:15)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 [(none)] show databases;
--------------------
| Database |
--------------------
| information_schema |
| LBACSYS |
| mysql |
| oceanbase |
| ORAAUDITOR |
| SYS |
| test |
--------------------
7 rows in set (0.028 sec)遇到报错没有mysql客户端
根据提示执行命令安装即可rootarmbian:~# mysql -uroot -h127.1 -P2881
Command mysql not found, but can be installed with:
apt install mariadb-client-core-10.5
rootarmbian:~# apt install mariadb-client-core-10.5四挂载数据卷
如果想持久化容器的数据可以在 docker 命令中使用 parameter 将数据保存在主机 os 中这里使用1panel提供的可视化管理进行操作
本地创建挂载的目录/home/OceanBase/ob和/home/OceanBase/bos/home/OceanBase|--ob|--obs挂载数据卷 然后确定重启镜像可在1pane容器的日志中查看启动状态
