10分钟让你快速部署一套OceanBase数据库

OceanBase 社区版是一款开源分布式 HTAP（Hybrid Transactional/Analytical Processing）数据库管理系统，具有原生分布式架构，支持金融级高可用、透明水平扩展、分布式事务、多租户和语法兼容等企业级特性。OceanBase 内核通过大规模商用场景的考验，已服务众多行业客户，现面向未来持续构建内核技术竞争力。

以前考过OceanBase的OBCA认证，但OceanBase部署对机器资源要求非常高，一直没有机会亲自体验OceanBase的强大功能，最近看OceanBase 社区版入门教程发现可以快速通过 Docker部署OceanBase数据库；

本篇文件记录我用时10分钟不到就部署的OceanBase数据库的过程，让大家看到体验OceanBase数据库如此简单。

参考dockerhub网址：https://hub.docker.com/r/obpilot/oceanbase-ce

资源要求Prerequisite：

Make sure the available resources meet the requirements:

The logical CPU count is no less than 4.

The available memory is no less than 10G, and the docker container memory limit is no less than 10G.

The available disk space is no less than 10G.

我的主机环境

hhj@k-m:~$ cat /etc/issue
Ubuntu 18.04.5 LTS \n \l
hhj@k-m:~$ free -m
              total        used        free      shared  buff/cache   available
Mem:          11701        6104        4787           0         810        5352
Swap:             0           0           0

docker版本信息

hhj@k-m:~$ docker info
Client:Context:    defaultDebug Mode: false

Server:
ERROR: Got permission denied while trying to connect to the Docker daemon socket at unix:///var/run/docker.sock: Get ck: connect: permission denied
errors pretty printing info
hhj@k-m:~$ sudo docker info 
[sudo] password for hhj: 
Client:Context:    defaultDebug Mode: false

Server:Containers: 40Running: 7Paused: 0Stopped: 33Images: 18Server Version: 20.10.7Storage Driver: overlay2Backing Filesystem: extfsSupports d_type: trueNative Overlay Diff: trueuserxattr: falseLogging Driver: json-fileCgroup Driver: cgroupfsCgroup Version: 1Plugins:Volume: localNetwork: bridge host ipvlan macvlan null overlayLog: awslogs fluentd gcplogs gelf journald json-file local logentries splunk syslogSwarm: inactiveRuntimes: io.containerd.runc.v2 io.containerd.runtime.v1.linux runcDefault Runtime: runcInit Binary: docker-initcontainerd version: 
 runc version: 
 init version: 
 Security Options:apparmorseccompProfile: defaultKernel Version: 4.15.0-140-genericOperating System: Ubuntu 18.04.5 LTSOSType: linuxArchitecture: x86_64CPUs: 1Total Memory: 3.666GiBName: k-mID: 2QL5:WAWI:KZQU:BQF3:5TPQ:HYYZ:J3DX:HBKK:3O53:ACJI:ZGTB:M4QNDocker Root Dir: /var/lib/dockerDebug Mode: falseRegistry: https://index.docker.io/v1/Labels:Experimental: falseInsecure Registries:127.0.0.0/8Registry Mirrors:https://b9pmyelo.mirror.aliyuncs.com/Live Restore Enabled: false

下载dockerhub的OB镜像

hhj@k-m:~$ sudo docker pull obpilot/oceanbase-ce
Using default tag: latest
latest: Pulling from obpilot/oceanbase-ce
7a0437f04f83: Pull complete 
615dc48ac9f1: Pull complete 
b10c1cdae3af: Pull complete 
4f4fb700ef54: Pull complete 
c0f6c94a6a6a: Pull complete 
792630f35e24: Pull complete 
Digest: sha256:7ac28415cf27ba19cb47acb67a55ebf9848ad73a63d80b7e2e85d653233dbaeb
Status: Downloaded newer image for obpilot/oceanbase-ce:latest
docker.io/obpilot/oceanbase-ce:latest

启动oceanbase镜像并查看容器

hhj@k-m:~$ sudo docker run -itd -m 9G --name OB  obpilot/oceanbase-ce:latest
WARNING: Your kernel does not support swap limit capabilities or the cgroup is not mounted. Memory limited without swap.
b587086e636802447bfa90b613e19627c05df94609da12501c29fd82d43e3b84
hhj@k-m:~$ sudo docker ps
CONTAINER ID   IMAGE                         COMMAND       CREATED          STATUS          PORTS                NAMES
b587086e6368   obpilot/oceanbase-ce:latest   "/bin/bash"   20 seconds ago   Up 15 seconds   2881/tcp, 2883/tcp   OB

进入oceanbase容器并启动obdemo

hhj@k-m:~$ free -m
              total        used        free      shared  buff/cache   available
Mem:          11701         246       11040           0         414       11210
Swap:             0           0           0
hhj@k-m:~$ sudo docker exec -it OB bash
[admin@b587086e6368 ~]$ free -m
              total        used        free      shared  buff/cache   available
Mem:          11701         275       11009           0         416       11183
Swap:             0           0           0
[admin@b587086e6368 ~]$ obd cluster list
+------------------------------------------------------------+
|                        Cluster List                        |
+--------+---------------------------------+-----------------+
| Name   | Configuration Path              | Status (Cached) |
+--------+---------------------------------+-----------------+
| obdemo | /home/admin/.obd/cluster/obdemo | deployed        |
+--------+---------------------------------+-----------------+
[admin@b587086e6368 ~]$ obd cluster start obdemo
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)

Check before start obproxy ok
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.1   | 2881 | zone1 | active |
+-----------+---------+------+-------+--------+

Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize cluster
+---------------------------------------------+
|                   obproxy                   |
+-----------+------+-----------------+--------+
| ip        | port | prometheus_port | status |
+-----------+------+-----------------+--------+
| 127.0.0.1 | 2883 | 2884            | active |
+-----------+------+-----------------+--------+
obdemo running
[admin@b587086e6368 ~]$ obd cluster list
+------------------------------------------------------------+
|                        Cluster List                        |
+--------+---------------------------------+-----------------+
| Name   | Configuration Path              | Status (Cached) |
+--------+---------------------------------+-----------------+
| obdemo | /home/admin/.obd/cluster/obdemo | running         |
+--------+---------------------------------+-----------------+

验证第一次登陆OB并查看有些什么库，好激动。

admin 用户的密码是 : adminPWD123

[admin@b587086e6368 ~]$ obclient -h127.1 -uroot@sys#obce-single -P2883 -prootPWD123 -c -A oceanbase

Welcome to the OceanBase.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.25 OceanBase 3.1.1 (r4-8c615943cbd25a6f7b8bdfd8677a13a21709a05e) (Built Oct 21 2021 10:52:05)

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 [oceanbase]> 
MySQL [oceanbase]> show databases;
+--------------------+
| Database           |
+--------------------+
| oceanbase          |
| information_schema |
| mysql              |
| SYS                |
| LBACSYS            |
| ORAAUDITOR         |
| test               |
+--------------------+
7 rows in set (0.025 sec)

快速创建资源单元、资源池以及租户

MySQL [oceanbase]> CREATE resource unit S4C1G max_cpu=4, min_cpu=4, max_memory='1G', min_memory='1G', max_iops=10000, min_iops=1000, max_session_num=1000000, max_disk_size='1024G'; 
Query OK, 0 rows affected (0.266 sec)

MySQL [oceanbase]> CREATE resource pool my_pool unit = 'S4C1G', unit_num = 1;
Query OK, 0 rows affected (0.480 sec)

MySQL [oceanbase]> create tenant obmysql resource_pool_list=('my_pool'), primary_zone='RANDOM',comment 'mysql tenant/instance', charset='utf8' set ob_tcp_invited_nodes='%', ob_compatibility_mode='mysql';

Query OK, 0 rows affected (35.438 sec)

MySQL [oceanbase]> 
MySQL [oceanbase]> select * from __all_tenant\G
*************************** 1. row ***************************gmt_create: 2021-12-15 16:16:07.626888gmt_modified: 2021-12-15 16:16:07.626888tenant_id: 1tenant_name: sysreplica_num: -1zone_list: zone1primary_zone: zone1locked: 0collation_type: 0info: system tenantread_only: 0rewrite_merge_version: 0locality: FULL{1}@zone1logonly_replica_num: 0previous_locality: 
     storage_format_version: 0
storage_format_work_version: 0default_tablegroup_id: -1compatibility_mode: 0drop_tenant_time: -1status: TENANT_STATUS_NORMALin_recyclebin: 0
*************************** 2. row ***************************gmt_create: 2021-12-15 16:42:01.677021gmt_modified: 2021-12-15 16:42:01.677021tenant_id: 1001tenant_name: obmysqlreplica_num: -1zone_list: zone1primary_zone: RANDOMlocked: 0collation_type: 0info: mysql tenant/instanceread_only: 0rewrite_merge_version: 0locality: FULL{1}@zone1logonly_replica_num: 0previous_locality: 
     storage_format_version: 0
storage_format_work_version: 0default_tablegroup_id: -1compatibility_mode: 0drop_tenant_time: -1status: TENANT_STATUS_NORMALin_recyclebin: 0
2 rows in set (0.093 sec)

MySQL [oceanbase]> exit
Bye

最后登录刚创建的租户

[admin@b587086e6368 ~]$ obclient -h 127.1 -uroot@obmysql#obce-single -P2883 -p -c -A test
Enter password: 
Welcome to the OceanBase.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.6.25 OceanBase 3.1.1 (r4-8c615943cbd25a6f7b8bdfd8677a13a21709a05e) (Built Oct 21 2021 10:52:05)

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 [test]> show databases;
+--------------------+
| Database           |
+--------------------+
| oceanbase          |
| information_schema |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.025 sec)

MySQL [test]>