OceanBase|OceanBase Docker 部署&使用 ubuntu|linux|oceanbase|docker

一、测试环境
硬件环境：virtual box虚拟机，16G内存
操作系统：ubuntu
二、环境准备

下载docker

frank@frank:~$ sudo apt install docker.io frank@frank:~$ sudo systemctl start docker frank@frank:~$ ps -ef | grep docker root1672810 09:32 ?00:00:00 /usr/bin/dockerd -H fd:// --containerd=/run/containerd/containerd.sock frank18244156700 09:33 pts/000:00:00 grep --color=auto docker frank@frank:~$ - 拉取镜像 frank@frank:~$ sudo docker pull oceanbase/obce-mini frank@frank:~$ sudo docker images [sudo] frank 的密码： REPOSITORYTAGIMAGE IDCREATEDSIZE obpilot/oceanbase-celatest943379e0b05b8 weeks ago2.25GB oceanbase/obce-minilatest1a5ca6d233a75 months ago690MB

三、启动容器

frank@frank:~$ sudo docker run -it -p 2881:2881 --name obce-minioceanbase/obce-mini generate boot.yaml ... create boot dirs and deploy ob cluster ... Package oceanbase-ce-3.1.0 is available. install oceanbase-ce-3.1.0 for local ok +-----------------------------------------------------------------------------+ |Packages| +--------------+---------+---------+------------------------------------------+ | Repository| Version | Release | Md5| +--------------+---------+---------+------------------------------------------+ | oceanbase-ce | 3.1.0| 2.el7| afd11d52f83eef4b456d77969fde620c4bfba85e | +--------------+---------+---------+------------------------------------------+ Open ssh connection ok Remote oceanbase-ce-3.1.0-afd11d52f83eef4b456d77969fde620c4bfba85e repository install ok Remote oceanbase-ce-3.1.0-afd11d52f83eef4b456d77969fde620c4bfba85e repository lib check !! [WARN] 127.0.0.1 oceanbase-ce-3.1.0-afd11d52f83eef4b456d77969fde620c4bfba85e require: libmariadb.so.3 [WARN] 127.0.0.1 oceanbase-ce-3.1.0-afd11d52f83eef4b456d77969fde620c4bfba85e require: libaio.so.1 Try to get lib-repository Package oceanbase-ce-libs-3.1.0 is available. install oceanbase-ce-libs-3.1.0 for local ok Use oceanbase-ce-libs-3.1.0-47300ca1ac4c62493caf3e9235b105e242e533b5 for oceanbase-ce-3.1.0-afd11d52f83eef4b456d77969fde620c4bfba85e Remote oceanbase-ce-libs-3.1.0-47300ca1ac4c62493caf3e9235b105e242e533b5 repository install ok Remote oceanbase-ce-3.1.0-afd11d52f83eef4b456d77969fde620c4bfba85e repository lib check ok Cluster status check ok 127.0.0.1 initializes cluster work home mini-ce deployed start ob cluster ... Get local repositories and plugins ok Open ssh connection ok Cluster param config check ok Check before start observer ok [WARN] (127.0.0.1) The recommended value of fs.aio-max-nr is 1048576 (Current value: 65536) Start observer ok observer program health check ok Connect to observer ok Initialize cluster Cluster bootstrap ok Wait for observer init ok +---------------------------------------------+ |observer| +-----------+---------+------+-------+--------+ | ip| version | port | zone| status | +-----------+---------+------+-------+--------+ | 127.0.0.1 | 3.1.0| 2881 | zone1 | active | +-----------+---------+------+-------+--------+ mini-ce running generate init_tenant.sql ... init tenant and sysbench database ... boot success!

四、链接OceanBase

frank@frank:~$ mycli -h172.17.0.2 -uroot@sys -P2881 mysql 3.1.0 mycli 1.20.1 Chat: https://gitter.im/dbcli/mycli Mail: https://groups.google.com/forum/#!forum/mycli-users Home: http://mycli.net Thanks to the contributor - Anonymous mysql root@sys@172.17.0.2:(none)> show databases; +--------------------+ | Database| +--------------------+ | oceanbase| | information_schema | | mysql| | SYS| | LBACSYS| | ORAAUDITOR| | test| +--------------------+ 7 rows in set Time: 0.012s mysql root@sys@172.17.0.2:(none)>

五、创建资源单元、资源池、租户

frank@frank:~$ mycli -h172.17.0.2 -uroot@sys -P2881 mysql 3.1.0 mycli 1.20.1 Chat: https://gitter.im/dbcli/mycli Mail: https://groups.google.com/forum/#!forum/mycli-users Home: http://mycli.net Thanks to the contributor - Magnus udd mysql root@sys@172.17.0.2:(none)> create resource unit ocp_unit min_cpu=3, max_cpu=3, min_memory=1073741824, max_memory=1073741824, max_iops=256, min_iops=128, max_disk_size=1000000000, max_session_num=64; mysql root@sys@172.17.0.2:(none)> create resource pool ocp_frank unit='ocp_unit', zone_list=('zone1'), unit_num=1; Query OK, 0 rows affected Time: 0.010s mysql root@sys@172.17.0.2:(none)> create tenant frank resource_pool_list = ('ocp_frank') set variables ob_compatibility_mode='mysql', ob_tcp_invited_nodes='%'; Query OK, 0 rows affected Time: 1.002s mysql root@sys@172.17.0.2:(none)>

六、创建用户

frank@frank:~$ mycli -h172.17.0.2 -uroot@frank -P2881 mysql 3.1.0 mycli 1.20.1 Chat: https://gitter.im/dbcli/mycli Mail: https://groups.google.com/forum/#!forum/mycli-users Home: http://mycli.net Thanks to the contributor - zer09 mysql root@frank@172.17.0.2:(none)> create user ob_user identified by '123456'; Query OK, 0 rows affected Time: 0.021s mysql root@frank@172.17.0.2:(none)> exit Goodbye! frank@frank:~$ mycli -h172.17.0.2 -uob_user@frank -P2881 -p123456 mysql 3.1.0 mycli 1.20.1 Chat: https://gitter.im/dbcli/mycli Mail: https://groups.google.com/forum/#!forum/mycli-users Home: http://mycli.net Thanks to the contributor - Angelo Lupo mysql ob_user@frank@172.17.0.2:(none)>

七、创建业务库

frank@frank:~$ mycli -h172.17.0.2 -uroot@frank -P2881 mysql 3.1.0 mycli 1.20.1 Chat: https://gitter.im/dbcli/mycli Mail: https://groups.google.com/forum/#!forum/mycli-users Home: http://mycli.net Thanks to the contributor - Chris Anderton mysql root@frank@172.17.0.2:(none)> create database obtest; Query OK, 1 row affected Time: 0.023s mysql root@frank@172.17.0.2:(none)> show databases; +--------------------+ | Database| +--------------------+ | oceanbase| | information_schema | | mysql| | test| | obtest| +--------------------+ 5 rows in set Time: 0.007s mysql root@frank@172.17.0.2:(none)> grant all privileges on *.* to 'ob_user'@'%' with grant option; Query OK, 0 rows affected Time: 0.018

八、建表

frank@frank:~$ mycli -h172.17.0.2 -uob_user@frank -P2881 -p123456 mysql 3.1.0 mycli 1.20.1 Chat: https://gitter.im/dbcli/mycli Mail: https://groups.google.com/forum/#!forum/mycli-users Home: http://mycli.net Thanks to the contributor - Matheus Rosa mysql ob_user@frank@172.17.0.2:(none)> show databases; +--------------------+ | Database| +--------------------+ | oceanbase| | information_schema | | mysql| | test| | obtest| +--------------------+ 5 rows in set Time: 0.008s mysql ob_user@frank@172.17.0.2:(none)> use obtest; You are now connected to database "obtest" as user "ob_user@frank" Time: 0.005s mysql ob_user@frank@172.17.0.2:obtest> CREATE TABLE t1(c1 INT PRIMARY KEY, c2 INT, c3 INT, c4 INT,INDEX k1(c2,c3)); Query OK, 0 rows affected Time: 0.069s mysql ob_user@frank@172.17.0.2:obtest> CREATE TABLE t2(c1 INT, c2 INT); Query OK, 0 rows affected Time: 0.050s mysql ob_user@frank@172.17.0.2:obtest> INSERT INTO t2 VALUES(1, 1); Query OK, 1 row affected Time: 0.017s mysql ob_user@frank@172.17.0.2:obtest> INSERT INTO t2 VALUES(3, 3); Query OK, 1 row affected Time: 0.005s mysql ob_user@frank@172.17.0.2:obtest> INSERT INTO t2 VALUES(5, 5); Query OK, 1 row affected Time: 0.006s mysql ob_user@frank@172.17.0.2:obtest> select * from t2; +----+----+ | c1 | c2 | +----+----+ | 1| 1| | 3| 3| | 5| 5| +----+----+ 3 rows in set Time: 0.012s

九、问题

由于使用PC环境虚拟机，整个过程主要的问题都集中在资源上，CPU、内存、硬盘在各实践阶段都出现了不同程度的问题，以下记录几个典型问题：

启动observer是失败，提示硬盘剩余空间不足（<5G）：解决方式，通过虚拟机设置扩充存储。
创建资源池时，‘(4624, " machine resource ‘zone1’ is not enough to hold a new unit")’：经排查，CPU数量、内存/磁盘空间后，定位CPU可数已经超过了物理CPU个数。通过下面SQL分析资源使用情况，并进行调整。
SELECT * FROM __all_unit_config;
SELECT * FROM __all_resource_pool;
SELECT * FROM __all_tenant;
– 减少已有资源池中CPU使用个数
ALTER RESOURCE UNIT obmysql min_cpu 2, MAX_CPU 2
删除租户时并重建时，报租户已存在：经查，删除租户默认会放入回收箱，使用FORCE 即刻删除。
DROP TENANT t1 FORCE;

十、总结
【OceanBase|OceanBase Docker 部署&使用】整个过程相对顺利，大部分遇到的问题都是资源问题，不得不说OB对资源的要求还是比较高的，想单机玩一玩需要注意资源上可能会遇到一些坑。通过以上的实践，对基本的OB安装、部署、创建租户/用户等操作有了一个比较直观的认识，后续还有很多内容值得学习，期待~~~