OceanBase_CE 4.2.1.7 容器化单机部署
# docker的版本过低拉取镜像错误: missing signature key# https://developer.aliyun.com/mirror/docker-ce/[root@ecs ~]# yum install -y yum-utils device-mapper-persistent-data lvm2[root@ecs ~]# yum-config-manager --add-repo https://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo[root@ecs ~]# yum makecache[root@ecs ~]# yum remove docker docker-client docker-common[root@ecs ~]# yum install docker-ce[root@ecs ~]# systemctl start docker[root@ecs ~]# cat /etc/redhat-release CentOS Linux release 7.9.2009 (Core)[root@ecs ~]# free total used free shared buff/cache available Mem: 1798504 504756 595964 70860 697784 1071808Swap: 3145724 0 3145724[root@ecs ~]# docker versionClient: Docker Engine - Community Version: 26.1.4 API version: 1.45 Go version: go1.21.11 Git commit: 5650f9b Built: Wed Jun 5 11:32:04 2024 OS/Arch: linux/amd64 Context: default Server: Docker Engine - Community Engine: Version: 26.1.4 API version: 1.45 (minimum version 1.24) Go version: go1.21.11 Git commit: de5c9cf Built: Wed Jun 5 11:31:02 2024 OS/Arch: linux/amd64 Experimental: false containerd: Version: 1.6.33 GitCommit: d2d58213f83a351ca8f528a95fbd145f5654e957 runc: Version: 1.1.12 GitCommit: v1.1.12-0-g51d5e94 docker-init: Version: 0.19.0 GitCommit: de40ad0[root@ecs ~]# docker pull quay.io/oceanbase/oceanbase-ceUsing default tag: latest latest: Pulling from oceanbase/oceanbase-ce 54273d8675f3: Pull complete 4f4fb700ef54: Pull complete 33d469f96650: Pull complete ec1f0c6a4699: Pull complete eb3e0c7348d2: Pull complete 8816e1cd7360: Pull complete afc80707e307: Pull complete 6350994649a8: Pull complete 01dd0f8722fc: Pull complete 32a3f014f98c: Pull complete 087c783d6be9: Pull complete a19ef209b81c: Pull complete 784e396159a7: Pull complete 2b7f06887248: Pull complete 727c823e4b45: Pull complete Digest: sha256:e6bbd8ddeb37e04f9f4ecb7be533799dbd1501f4ac167ffdb9ce78ab6a64af87 Status: Downloaded newer image for quay.io/oceanbase/oceanbase-ce:latest quay.io/oceanbase/oceanbase-ce:latest[root@ecs ~]# docker imagesREPOSITORY TAG IMAGE ID CREATED SIZE quay.io/oceanbase/oceanbase-ce latest 2563be8325d5 4 weeks ago 652MB[root@ecs ~]# docker run --name obstandalone -p 2881:2881 -itd quay.io/oceanbase/oceanbase-ce:latest[root@ecs ~]# docker logs -f $(docker ps -a -q)发现云主机内存不足,无法部署,更换另一台.[root@t2 ~]# cat /etc/redhat-release CentOS Linux release 8.5.2111[root@t2 ~]# free total used free shared buff/cache available Mem: 3760764 3017420 118536 2204 624808 502308Swap: 0 0 0[root@t2 ~]# podman pull quay.io/oceanbase/oceanbase-ceTrying to pull quay.io/oceanbase/oceanbase-ce:latest... Getting image source signatures Copying blob 4f4fb700ef54 done Copying blob ec1f0c6a4699 done Copying blob 33d469f96650 done Copying blob 54273d8675f3 done Copying blob 8816e1cd7360 done Copying blob eb3e0c7348d2 done Copying blob afc80707e307 done Copying blob 6350994649a8 done Copying blob 01dd0f8722fc done Copying blob 32a3f014f98c done Copying blob 4f4fb700ef54 skipped: already exists Copying blob 087c783d6be9 done Copying blob 784e396159a7 done Copying blob a19ef209b81c done Copying blob 727c823e4b45 done Copying blob 2b7f06887248 done Copying config 2563be8325 done Writing manifest to image destination Storing signatures 2563be8325d587a93b96d3f2fdacc8de96ee9a27596e960c4dcc7e6ceae96fdb[root@t2 ~]# [root@t2 ~]# podman imagesREPOSITORY TAG IMAGE ID CREATED SIZE quay.io/oceanbase/oceanbase-ce latest 2563be8325d5 4 weeks ago 663 MBpodman run --name obstandalone -p 2881:2881 -itd quay.io/oceanbase/oceanbase-ce:latestpodman logs -f $(podman ps -a -q)ob-configserver-1.0.0 already installed. +-----------------------------------------------------------------------------------------------+| Packages |+-----------------+---------+------------------------+------------------------------------------+| Repository | Version | Release | Md5 |+-----------------+---------+------------------------+------------------------------------------+| oceanbase-ce | 4.2.1.8 | 108000022024072217.el7 | 499b676f2ede5a16e0c07b2b15991d1160d972e8 || obagent | 4.2.2 | 100000042024011120.el7 | 19739a07a12eab736aff86ecf357b1ae660b554e || ob-configserver | 1.0.0 | 2.el7 | feca6b9c76e26ac49464f34bfa0780b5a8d3f4a0 |+-----------------+---------+------------------------+------------------------------------------+ Repository integrity check ok Load param plugin ok Open ssh connection x[ERROR] OBD-1013: root@10.88.0.5 connect failed: username or password error --- 发现总是报错用户密码不对,换一个镜像 Trace ID: ba88d8fc-7760-11ef-9b45-565908491197[root@t2 ~]# podman imagesREPOSITORY TAG IMAGE ID CREATED SIZE quay.io/oceanbase/oceanbase-ce 4.2.1-lts 2563be8325d5 4 weeks ago 663 MB quay.io/oceanbase/oceanbase-ce latest 2563be8325d5 4 weeks ago 663 MB[root@t2 ~]# podman run --name obstandalone -p 2881:2881 -itd quay.io/oceanbase/oceanbase-ce:4.2.1-ltsd86a0b513f4a1ece540808ab734722fc514df4e176e65ffaf729605e6b33ce6e[root@t2 ~]# podman ps -aCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES d86a0b513f4a quay.io/oceanbase/oceanbase-ce:4.2.1-lts 6 seconds ago Up 5 seconds ago 0.0.0.0:2881->2881/tcp obstandalone[root@t2 ~]# podman logs -f d86a0b513f4a[root@t2 ~]# podman imagesREPOSITORY TAG IMAGE ID CREATED SIZE quay.io/oceanbase/oceanbase-ce 4.2.1-lts 2563be8325d5 4 weeks ago 663 MB quay.io/oceanbase/oceanbase-ce latest 2563be8325d5 4 weeks ago 663 MB quay.io/oceanbase/oceanbase-ce 4.2.1.6-106000012024042515 b9355766eca3 4 weeks ago 701 MB 换了好几个镜像,都是 [ERROR] OBD-1013: root@10.88.0.7 connect failed: username or password error 重新使用离线tar包[root@t2 ~]# wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/docker_img/oceanbase-ce-421.x86.tar[root@t2 ~]# podman load -i oceanbase-ce-421.x86.tar[root@t2 ~]# podman imagesREPOSITORY TAG IMAGE ID CREATED SIZE quay.io/oceanbase/oceanbase-ce 4.2.1-lts 2563be8325d5 4 weeks ago 663 MB quay.io/oceanbase/oceanbase-ce latest 2563be8325d5 4 weeks ago 663 MB quay.io/oceanbase/oceanbase-ce 4.2.1.6-106000012024042515 b9355766eca3 4 weeks ago 701 MB localhost/oceanbase-ce 4.2.1 8174ac5a6ae0 3 months ago 657 MB[root@t2 ~]# podman run --name obstandalone -p 2881:2881 -itd localhost/oceanbase-ce:4.2.184b3f8cc61830746e129ce3dadc32f7d52bd5dd75e028bcdfe8a6bab8e087474[root@t2 ~]# podman ps -aCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 84b3f8cc6183 localhost/oceanbase-ce:4.2.1 /bin/sh -c _boot 2 seconds ago Up 2 seconds ago 0.0.0.0:2881->2881/tcp obstandalone[root@t2 ~]# podman logs - 84b3f8cc6183 Error: no container with name or ID "-" found: no such container[root@t2 ~]# podman logs -f 84b3f8cc6183 /////////////////////// STEP 1: Config Generation /////////////////////// oceanbase-ce docker in mini mode /////////////////////// phase end: 0.031 s /////////////////////// /////////////////////// STEP 2: Ob-deploy mirror clone /////////////////////// name: jq version: 1.6release:15.an8 arch: x86_64 md5: 89ff72f125e93deaff15103214135697dc152bec size: 450301add /root/pkg/jq-1.6-15.an8.x86_64.rpm to local mirror name: ob-configserver version: 1.0.0 release:2.el7 arch: x86_64 md5: feca6b9c76e26ac49464f34bfa0780b5a8d3f4a0 size: 24259515add /root/pkg/ob-configserver-1.0.0-2.el7.x86_64.rpm to local mirror name: obagent version: 4.2.2 release:100000042024011120.el7 arch: x86_64 md5: 19739a07a12eab736aff86ecf357b1ae660b554e size: 72919140add /root/pkg/obagent-4.2.2-100000042024011120.el7.x86_64.rpm to local mirror name: oceanbase-ce version: 4.2.1.7 release:107000162024060611.el7 arch: x86_64 md5: f69097e5f6056a0f6949867a799eea3724a905aa size: 452109379add /root/pkg/oceanbase-ce-4.2.1.7-107000162024060611.el7.x86_64.rpm to local mirror name: oceanbase-ce-libs version: 4.2.1.7 release:107000162024060611.el7 arch: x86_64 md5: a172d6c44ded2b9999fd09ca67cd6b60b68b1abe size: 468528add /root/pkg/oceanbase-ce-libs-4.2.1.7-107000162024060611.el7.x86_64.rpm to local mirror name: oniguruma version: 6.8.2 release:3.0.1.an8 arch: x86_64 md5: 777ef3bb1a900f4019b44be1f588f6f8d28f4add size: 553335add /root/pkg/oniguruma-6.8.2-3.0.1.an8.x86_64.rpm to local mirror Trace ID: 0f54e3a8-7766-11ef-8159-22e6ee5c2dec If you want to view detailed obd logs, please run: obd display-trace 0f54e3a8-7766-11ef-8159-22e6ee5c2dec +----------------------------------------------------------------------------------------------------------+| local Package List |+-------------------+---------+------------------------+--------+------------------------------------------+| name | version | release | arch | md5 |+-------------------+---------+------------------------+--------+------------------------------------------+| jq | 1.6 | 15.an8 | x86_64 | 89ff72f125e93deaff15103214135697dc152bec || ob-configserver | 1.0.0 | 2.el7 | x86_64 | feca6b9c76e26ac49464f34bfa0780b5a8d3f4a0 || obagent | 4.2.2 | 100000042024011120.el7 | x86_64 | 19739a07a12eab736aff86ecf357b1ae660b554e || oceanbase-ce | 4.2.1.7 | 107000162024060611.el7 | x86_64 | f69097e5f6056a0f6949867a799eea3724a905aa || oceanbase-ce-libs | 4.2.1.7 | 107000162024060611.el7 | x86_64 | a172d6c44ded2b9999fd09ca67cd6b60b68b1abe || oniguruma | 6.8.2 | 3.0.1.an8 | x86_64 | 777ef3bb1a900f4019b44be1f588f6f8d28f4add |+-------------------+---------+------------------------+--------+------------------------------------------+ Trace ID: 107f5d62-7766-11ef-ab6a-22e6ee5c2dec If you want to view detailed obd logs, please run: obd display-trace 107f5d62-7766-11ef-ab6a-22e6ee5c2dec /////////////////////// phase end: 3.342 s /////////////////////// /////////////////////// STEP 3: Ob-deploy deploy /////////////////////// Local deploy is empty Trace ID: 1103d9ac-7766-11ef-9088-22e6ee5c2dec If you want to view detailed obd logs, please run: obd display-trace 1103d9ac-7766-11ef-9088-22e6ee5c2dec /////////////////////// STEP 4: Ob-deploy autodeploy /////////////////////// Dev Mode: ON Trace ID: 11994a82-7766-11ef-9908-22e6ee5c2dec If you want to view detailed obd logs, please run: obd display-trace 11994a82-7766-11ef-9908-22e6ee5c2dec Package oceanbase-ce-4.2.1.7-107000162024060611.el7 is available. Package obagent-4.2.2-100000042024011120.el7 is available.install oceanbase-ce-4.2.1.7 for local okinstall obagent-4.2.2 for local ok Cluster param config check ok Open ssh connection ok Generate obagent configuration ok Generate observer configuration ok +--------------------------------------------------------------------------------------------+| Packages |+--------------+---------+------------------------+------------------------------------------+| Repository | Version | Release | Md5 |+--------------+---------+------------------------+------------------------------------------+| oceanbase-ce | 4.2.1.7 | 107000162024060611.el7 | f69097e5f6056a0f6949867a799eea3724a905aa || obagent | 4.2.2 | 100000042024011120.el7 | 19739a07a12eab736aff86ecf357b1ae660b554e |+--------------+---------+------------------------+------------------------------------------+ Repository integrity check ok Load param plugin ok Open ssh connection ok Parameter check ok Cluster status check ok Initializes observer work home ok Initializes obagent work home ok Remote oceanbase-ce-4.2.1.7-107000162024060611.el7-f69097e5f6056a0f6949867a799eea3724a905aa repository install ok Remote oceanbase-ce-4.2.1.7-107000162024060611.el7-f69097e5f6056a0f6949867a799eea3724a905aa repository lib check !!Remote obagent-4.2.2-100000042024011120.el7-19739a07a12eab736aff86ecf357b1ae660b554e repository install ok Remote obagent-4.2.2-100000042024011120.el7-19739a07a12eab736aff86ecf357b1ae660b554e repository lib check ok Try to get lib-repository Package oceanbase-ce-libs-4.2.1.7-107000162024060611.el7 is available.install oceanbase-ce-libs-4.2.1.7 for local ok Remote oceanbase-ce-libs-4.2.1.7-107000162024060611.el7-a172d6c44ded2b9999fd09ca67cd6b60b68b1abe repository install ok Remote oceanbase-ce-4.2.1.7-107000162024060611.el7-f69097e5f6056a0f6949867a799eea3724a905aa repository lib check ok obcluster deployed Get local repositories ok Search plugins ok Load cluster param plugin ok Open ssh connection ok Check before start observer ok[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 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: 371713, Recommended value: 6573688)[WARN] OBD-2000: (127.0.0.1) not enough memory. (Available: 3022M, Need: 3072M)[WARN] OBD-1012: (127.0.0.1) clog and data use the same disk (/)Check before start obagent ok Start observer ok observer program health check ok Connect to observer 127.0.0.1:2881 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 |+-----------+---------+------+-------+--------+| 127.0.0.1 | 4.2.1.7 | 2881 | zone1 | ACTIVE |+-----------+---------+------+-------+--------+ obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -Acluster unique id: 3e7xxxx5-xxxxx-5fe7-b740-xxxxxxxxxxxxx-192xxxx5b5f1-xxxxx0204 +---------------------------------------------------------------+| obagent |+------------+--------------------+--------------------+--------+| ip | mgragent_http_port | monagent_http_port | status |+------------+--------------------+--------------------+--------+| 10.88.0.11 | 8089 | 8088 | active |+------------+--------------------+--------------------+--------+ obcluster running Trace ID: 1232446c-7766-11ef-b7d9-22e6ee5c2dec If you want to view detailed obd logs, please run: obd display-trace 1232446c-7766-11ef-b7d9-22e6ee5c2dec /////////////////////// phase end: 163.566 s /////////////////////// /////////////////////// STEP 5: Ob-deploy Create Tenant /////////////////////// Get local repositories and plugins ok Open ssh connection ok Connect to observer 127.0.0.1:2881 ok Create tenant test ok Trace ID: 7437e194-7766-11ef-97db-22e6ee5c2dec If you want to view detailed obd logs, please run: obd display-trace 7437e194-7766-11ef-97db-22e6ee5c2dec /////////////////////// phase end: 70.767 s /////////////////////// deploy success!boot success![root@t2 ~]# podman ps -aCONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 84b3f8cc6183 localhost/oceanbase-ce:4.2.1 /bin/sh -c _boot 7 minutes ago Up 7 minutes ago 0.0.0.0:2881->2881/tcp obstandalone[root@t2 ~]# podman exec -itd 84b3f8cc6183 /bin/bashab347e24f7cc5f11b65dea88c6b7f232942cadc1a91b8b1de58ea1fd30d1223f[root@t2 ~]# [root@t2 ~]# podman exec -it 84b3f8cc6183 /bin/bash[root@84b3f8cc6183 ~]# [root@84b3f8cc6183 ~]# [root@84b3f8cc6183 ~]# obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -AWelcome to the OceanBase. Commands end with ; or \g. Your OceanBase connection id is 3221487925Server version: OceanBase_CE 4.2.1.7 (r107000162024060611-69b64b84b656a4cfa126dab60b4e66dc1bc156ca) (Built Jun 6 2024 11:51:48)Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. obclient [oceanbase]> show tenant;+---------------------+| Current_tenant_name |+---------------------+| sys |+---------------------+1 row in set (0.006 sec)obclient [oceanbase]> obclient [oceanbase]> select svr_ip,svr_port,id,zone from __all_server;+-----------+----------+----+-------+| svr_ip | svr_port | id | zone |+-----------+----------+----+-------+| 127.0.0.1 | 2882 | 1 | zone1 |+-----------+----------+----+-------+1 row in set (0.003 sec)