OceanBase数据库系列之：基于docker快速安装OceanBase数据库，基于linux服务器快速部署OceanBase数据库
一、docker快速安装OceanBase数据库 下载OceanBase数据库镜像 docker pull quay.io/oceanbase/oceanbase-ce Using default tag: latest latest: Pulling from oceanbase/oceanbase-ce 54273d8675f3: Pull complete 4f4fb700ef54: Pull complete 60f355aa4c4a: Pull complete 83956aed8185: Pull complete 4176f17fd999: Pull complete e3c85a937235: Pull complete e6ea724d067d: Pull complete b8d3209d8507: Pull complete 7b0fa550991a: Pull complete 1c5387c2c4f3: Pull complete 09ba76e17c02: Pull complete fc02c604977f: Pull complete d2086fce6738: Pull complete 98688f58b462: Pull complete ba6dd33fbdab: Pull complete 0948ee851c16: Pull complete a0d8cbe81520: Pull complete beb4f43c14c8: Pull complete Digest: sha256:99f644dc221fd0b8fc685e67445f1e50cbbcb335cb9615e3cf5d3c14350ed815 Status: Downloaded newer image for quay.io/oceanbase/oceanbase-ce:latest quay.io/oceanbase/oceanbase-ce:latest 查看镜像 docker images REPOSITORY TAG IMAGE ID CREATED SIZE quay.io/oceanbase/oceanbase-ce latest d29ae3214fa3 2 months ago 649MB 启动OceanBase数据库
部署 mini 的独立实例
sudo docker run -p 2881:2881 --name obstandalone -e MODE=MINI -e OB_TENANT_PASSWORD=debezium1****6A -d quay.io/oceanbase/oceanbase-ce 查看OceanBase数据库是否启动成功查看容器状态
docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 22b5690ec59e quay.io/oceanbase/oceanbase-ce "bash -c '/usr/sbin/…" 4 minutes ago Up 4 minutes 0.0.0.0:2881->2881/tcp obstandalone启动预计需要 2~5 分钟。执行以下命令，确认是否启动成功
docker logs obstandalone | tail -1 observer program health check ok 二、基于linux部署OceanBase数据库OceanBase 从 V4.0.0 开始提供统一的安装包 OceanBase All in One。目前包括 OceanBase 数据库软件和 OCP、obd、OBProxy（又称为 ODP）、OBClient、OCP Express（自 V4.1.0 起支持）、Prometheus、Grafana，以及诊断和测试工具。
在线安装obd bash -c "$(curl -s https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/oceanbase-all-in-one/installer.sh)" add auto set env logic to profile: /root/.bash_profile ######################################################################################### Install Finished ========================================================================================= Setup Environment: source ~/.oceanbase-all-in-one/bin/env.sh Quick Start: obd demo 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 配置 obdobd 自带仓库信息，当机器可以连接网络时，无须配置，执行 obd mirror list 命令即可查看 obd 仓库中的软件。
查看 obd 仓库信息
输出如下：
obd mirror list +-----------------------------------------------------------------------------+ | Mirror Repository List | +----------------------------+--------+---------+----------+------------------+ | SectionName | Type | Enabled | Avaiable | Update Time | +----------------------------+--------+---------+----------+------------------+ | local | local | - | True | 2024-11-29 16:24 | | oceanbase.community.stable | remote | False | False | 1970-01-01 08:00 | | oceanbase.development-kit | remote | False | False | 1970-01-01 08:00 | +----------------------------+--------+---------+----------+------------------+ Use `obd mirror list <section name>` for more details Trace ID: 49f40ff6-ae2b-11ef-b877-5254006cf5ec If you want to view detailed obd logs, please run: obd display-trace 49f40ff6-ae2b-11ef-b877-5254006cf5ec启用远程仓库
obd mirror enable remote Enable remote ok Trace ID: 040cc3d8-ae2c-11ef-a99c-5254006cf5ec If you want to view detailed obd logs, please run: obd display-trace 040cc3d8-ae2c-11ef-a99c-5254006cf5ec查看 obd 仓库信息
obd mirror list Update OceanBase-community-stable-el7 ok Update OceanBase-development-kit-el7 ok +-----------------------------------------------------------------------------+ | Mirror Repository List | +----------------------------+--------+---------+----------+------------------+ | SectionName | Type | Enabled | Avaiable | Update Time | +----------------------------+--------+---------+----------+------------------+ | local | local | - | True | 2024-11-29 16:29 | | oceanbase.community.stable | remote | True | True | 2024-11-29 16:29 | | oceanbase.development-kit | remote | True | True | 2024-11-29 16:29 | +----------------------------+--------+---------+----------+------------------+ Use `obd mirror list <section name>` for more details Trace ID: 0903521c-ae2c-11ef-8606-5254006cf5ec If you want to view detailed obd logs, please run: obd display-trace 0903521c-ae2c-11ef-8606-5254006cf5ec查看对应仓库中的软件信息
obd mirror list oceanbase.community.stable执行 obd mirror list local 命令查看本地镜像库中的安装包
obd mirror list local +---------------------------------------------------------------------------------------------------------------------+ | local Package List | +---------------------------+-----------+------------------------+---------+------------------------------------------+ | name | version | release | arch | md5 | +---------------------------+-----------+------------------------+---------+------------------------------------------+ | grafana | 7.5.17 | 1 | x86_64 | 1bf1f338d3a3445d8599dc6902e7aeed4de4e0d6 | | obagent | 4.2.2 | 100000042024011120.el7 | x86_64 | 19739a07a12eab736aff86ecf357b1ae660b554e | | ob-configserver | 1.0.0 | 2.el7 | x86_64 | feca6b9c76e26ac49464f34bfa0780b5a8d3f4a0 | | ob-deploy | 2.10.1 | 1.el7 | x86_64 | 12bbe7e79275d8ff316769aa9fa909997771db5b | | obproxy-ce | 4.3.2.0 | 26.el7 | x86_64 | fd779e401be448715254165b1a4f7205c4c1bda5 | | ob-sysbench | 1.0.20 | 21.el7 | x86_64 | 34eb6ecba0ebc4c31c4cfa01162045cbbbec55f7 | | obtpcc | 5.0.0 | 1.el7 | x86_64 | 8624590be4bfe16f28bdd9fc5e4849cda19577d6 | | obtpch | 3.0.0 | 1.el7 | x86_64 | 3e3e88f87527677998fedf25087f5c87779dee62 | | oceanbase-ce | 4.2.1.8 | 108000022024072217.el7 | x86_64 | 499b676f2ede5a16e0c07b2b15991d1160d972e8 | | oceanbase-ce | 4.3.4.0 | 100000162024110717.el7 | x86_64 | 5d59e837a0ecff1a6baa20f72747c343ac7c8dce | | oceanbase-ce-libs | 4.2.1.8 | 108000022024072217.el7 | x86_64 | d02f4bfd321370a02550424293beb1be31204038 | | oceanbase-ce-libs | 4.3.4.0 | 100000162024110717.el7 | x86_64 | 8f0416a36198edfc7ec8edc3de765e21159dca54 | | oceanbase-ce-utils | 4.2.1.8 | 108000022024072217.el7 | x86_64 | 6f87392f95b399a21382323f256cfda5969375c4 | | oceanbase-ce-utils | 4.3.4.0 | 100000162024110717.el7 | x86_64 | db5fe222ae61e907aabede05c214d1cfef38a86f | | oceanbase-diagnostic-tool | 2.4.0 | 32024091010.el7 | x86_64 | 3817915bd36866590e1e6a74ad1c308817a6985e | | ocp-agent-ce | 4.3.2 | 20241012145836.el7 | aarch64 | 467f53472b5979c8b90cba439d780eee1510f084 | | ocp-agent-ce | 4.3.2 | 20241012145836.el7 | x86_64 | 13e464a5b51e5787b7e3276c913dea3855a631f0 | | ocp-express | 4.2.2 | 100000022024011120.el7 | x86_64 | 09ffcf156d1df9318a78af52656f499d2315e3f7 | | ocp-server-ce | 4.3.2 | 20241012145836.el7 | noarch | 610610e2daf63f6df08af686f9a88b6d8cefcc52 | | openjdk-jre | 1.8.0_322 | b09.el7 | x86_64 | 051aa69c5abb8697d15c2f0dcb1392b3f815f7ed | | prometheus | 2.37.1 | 10000102022110211.el7 | x86_64 | 58913c7606f05feb01bc1c6410346e5fc31cf263 | +---------------------------+-----------+------------------------+---------+------------------------------------------+ Trace ID: e60fbff0-ae2d-11ef-830f-5254006cf5ec If you want to view detailed obd logs, please run: obd display-trace e60fbff0-ae2d-11ef-830f-5254006cf5ec官网链接：
部署 OceanBase 数据库仅部署 OceanBase 数据库
obd demo -c oceanbase-ce部署默认组件
执行 obd demo 命令后，会自动部署 OceanBase 数据库、OBProxy、OBAgent、Prometheus 和 Grafana，默认版本为镜像库中最新版本。
obd demo部署默认组件，并指定 OceanBase 数据库版本
obd demo --oceanbase-ce.version=4.3.3.0 三、连接 OceanBase 数据库实例使用 obd 命令管理和 OBClient 客户端连接实例，也可使用宿主机本地 OBClient 或 MySQL 客户端连接到 OceanBase 数据库实例。
署成功后可复制输出中的连接串，使用 OBClient 客户端连接到 OceanBase 数据库。示例如下：
obclient -h127.0.0.1 -P2881 -uroot@sys -p'*******' -Doceanbase -A
