docker 快速拉起一个 OceanBase 环境

• 以 CentOS 7.9 为例

安装 Docker

• yum 安装 docker

yum install -y yum-utils
yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
yum -y  install docker-ce docker-ce-cli containerd.io

• 启动 docker 服务

systemctl start docker

安装 OceanBase

• 查找 OckerBase 镜像

$ docker search oceanbase
oceanbase/oceanbase-ce             OceanBase is an open-source, distributed HTA…   20
oceanbasedev/ob-operator                                                           0
oceanbasedev/obagent                                                               0
oceanbasedev/oceanbase-cn                                                          0
oceanbase/obce-mini                obce-mini is a mini standalone test image fo…   3
oceanbase/oceanbase-xe             OceanBase Database 2.2 Express Edition          4
oceanbase/ob-operator                                                              0
oceanbase/obce-operator            obce-operator                                   1
oceanbase/miniob                   miniob database competition                     2
oceanbase/obagent                                                                  0
oceanbase/obproxy-ce                                                               0
oceanbasedev/sealer-ob                                                             0
oceanbasedev/obproxy-ce                                                            0
oceanbase/oceanbase-cloud-native                                                   0
oceanbase/centos7                                                                  0
obpilot/oceanbase-ce               3 steps to run an OceanBase-CE docker in you…   4
oceanbasedev/obproxy                                                               0
oceanbasedev/create_tenant                                                         0
datatomdev/oceanbase                                                               0
zibuyu886/oceanbase-ce-cluster     OceanBase ce cluster                            1
huweijie/oceanbase-ce-deploy                                                       0
oceanbasedev/vim-with-go                                                           0
hnwyllmm/oceanbase-ce                                                              0
superbigfu/oceanbase                                                               0
oceanbasedev/ob-configserver                                                       0

• 拉取并运行 oceanbase/oceanbase-ce

docker pull oceanbase/oceanbase-ce
# -e MINI_MODE=1 指定部署 mini 实例
docker run -p 2881:2881 --name ob   -e MINI_MODE=1 -d oceanbase/oceanbase-ce

• 查看启动日志
  • 需要 2~5 分钟。执行以下命令，如果返回 boot success!，则表示启动成功

$ docker logs -f ob
……
Get local repositories and plugins ok
Open ssh connection ok
Connect to observer ok
Create tenant test ok
Trace ID: 3059e5ac-3983-11ee-bc69-0242ac110002
If you want to view detailed obd logs, please run: obd display-trace 3059e5ac-3983-11ee-bc69-0242ac110002
deploy success!
boot success!

查看集群状态

• obd 查看集群状态

$ docker exec -it ob bash
[root@e8b4d0c21b34 ~]# obd cluster list
+------------------------------------------------------------+
|                        Cluster List                        |
+-----------+------------------------------+-----------------+
| Name      | Configuration Path           | Status (Cached) |
+-----------+------------------------------+-----------------+
| obcluster | /root/.obd/cluster/obcluster | running         |
+-----------+------------------------------+-----------------+

• 连接 sys 租户
  • ob-mysql 是镜像内提供的连接脚本

$ docker exec -it ob bash
[root@e8b4d0c21b34 ~]# ob-mysql sys

使用

创建 UNIT

• sys 租户下

create resource unit t_u1_1_1 max_cpu=1, memory_size='1G', max_iops=10240;

• 查看

obclient [oceanbase]> SELECT * FROM __all_unit_config \G
*************************** 3. row ***************************
    gmt_create: 2023-08-13 10:52:46.072570
  gmt_modified: 2023-08-13 10:52:46.072570
unit_config_id: 1002
          name: t_u1_1_1
       max_cpu: 1
       min_cpu: 1
   memory_size: 1073741824
 log_disk_size: 3221225472
      max_iops: 10240
      min_iops: 10240
   iops_weight: 0
3 rows in set (0.001 sec)

创建 RESOURCE POOL

create resource pool t_pool1 unit=t_u1_1_1,UNIT_NUM=1;

创建租户

CREATE TENANT IF NOT EXISTS tenant1 CHARSET='utf8mb4',RESOURCE_POOL_LIST=('t_pool1');

• 创建租户后更改 root 密码

obclient -hxx.xx.xx.xx -uroot@tenant1 -P${port_num} -Doceanbase -A
obclient> ALTER USER root IDENTIFIED BY '123456';

创建库

• 连接

obclient -h10.0.0.107 -uroot@tenant1 -P2883 -Doceanbase -A -p

• 创建测试库

obclient [oceanbase]> create database tdb;

• 查看测试路

obclient [oceanbase]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| oceanbase          |
| tdb                |
| test               |
+--------------------+

参考

• https://www.oceanbase.com/docs/common-oceanbase-database-1000000000033135