Oceanbase学习之—docker下oceanbase部署体验

一、操作系统及配置

[root@localhost ~]# cat /etc/redhat-release

CentOS Linux release 7.9.2009 (Core)

[root@localhost ~]# free -g

total used free shared buff/cache available

Mem: 15 3 7 0 3 11

Swap: 0 0 0

[root@localhost ~]# cat /proc/cpuinfo | grep processor

processor : 0

processor : 1

processor : 2

processor : 3

processor : 4

processor : 5

processor : 6

processor : 7

二、安装docker

yum install -y yum-utils

sudo yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo

yum install docker-ce docker-ce-cli containerd.io

三、、安装oceanbase-ce

拉取镜像并运行

# 拉取镜像 oceanbase-ce

docker pull oceanbase/oceanbase-ce

# 运行oceanbase实例

docker run -p 2881:2881 --name obstandalone -e MINI_MODE=0 -d oceanbase/oceanbase-ce

检查

docker ps |grep obstandalone

[root@localhost ~]# docker ps |grep obstandalone

a37616f86ec9 oceanbase/oceanbase-ce "/bin/sh -c _boot" 43 hours ago Up 43 hours 0.0.0.0:2881->2881/tcp, :::2881->2881/tcp obstandalone

执行以下命令，如果返回 boot success!，则表示启动成功

[root@localhost ~]# docker logs obstandalone | tail -1

boot success!

检查集群状态

进入到容器内部-bash

docker exec -it obstandalone bash

然后执行

[root@a37616f86ec9 ~]# obd cluster list

+------------------------------------------------------------+

| Cluster List |

+-----------+------------------------------+-----------------+

| Name | Configuration Path | Status (Cached) |

+-----------+------------------------------+-----------------+

| obcluster | /root/.obd/cluster/obcluster | running |

+-----------+------------------------------+-----------------+

Trace ID: f3c46414-967a-11ee-9519-0242ac110002

If you want to view detailed obd logs, please run: obd display-trace f3c46414-967a-11ee-9519-0242ac110002

获取集群详细信息

[root@a37616f86ec9 ~]# obd cluster display obcluster

Get local repositories and plugins ok

Open ssh connection ok

Cluster status check ok

Connect to observer 127.0.0.1:2881 ok

Wait for observer init ok

+---------------------------------------------+

| observer |

+-----------+---------+------+-------+--------+

+-----------+---------+------+-------+--------+

| 127.0.0.1 | 4.2.1.1 | 2881 | zone1 | ACTIVE |

+-----------+---------+------+-------+--------+

obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A

Connect to Obagent ok

+---------------------------------------------------------------+

| obagent |

+------------+--------------------+--------------------+--------+

+------------+--------------------+--------------------+--------+

| 172.17.0.2 | 8089 | 8088 | active |

+------------+--------------------+--------------------+--------+

Trace ID: 1dd3b6c4-967b-11ee-b637-0242ac110002

If you want to view detailed obd logs, please run: obd display-trace 1dd3b6c4-967b-11ee-b637-0242ac110002

方法1

docker exec -it obstandalone bash ---进入到容器内部-bash

obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A ---登录数据库

[root@localhost ~]# docker exec -it obstandalone bash

[root@a37616f86ec9 ~]# obclient -h127.0.0.1 -P2881 -uroot -Doceanbase -A

Welcome to the OceanBase. Commands end with ; or \g.

Your OceanBase connection id is 3221631204

Server version: OceanBase_CE 4.2.1.1 (r101010012023111012-2f6924cd5a576f09d6e7f212fac83f1a15ff531a) (Built Nov 10 2023 12:13:59)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient [oceanbase]>

方法2

[root@localhost ~]# docker exec -it obstandalone ob-mysql sys

Command is: obclient -h127.1 -uroot@sys -A -Doceanbase -P2881

Welcome to the OceanBase. Commands end with ; or \g.

Your OceanBase connection id is 3221631147

Server version: OceanBase_CE 4.2.1.1 (r101010012023111012-2f6924cd5a576f09d6e7f212fac83f1a15ff531a) (Built Nov 10 2023 12:13:59)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient [oceanbase]>

# 查看数据库版本信息

obclient [oceanbase]> select version();

+------------------------------+

| version() |

+------------------------------+

| 5.7.25-OceanBase_CE-v4.2.1.1 |

+------------------------------+

1 row in set (0.001 sec)

四、创建租户

docker镜像起来后会自动创建一个test_pool资源池，自动占用了除sys_pool cpu之外的所有cpu这里查资料后删除了test账户和test_pool

（创建时的报错信息MEMORY resource not enough、CPU resource not enough）

select * from DBA_OB_TENANTS;-- 查看所有租户

drop tenant test force;

select * from DBA_OB_RESOURCE_POOLS;--查看所有资源池

drop resource pool test_pool;

# 创建resource unit

CREATE RESOURCE UNIT unit1 MAX_CPU 1, MIN_CPU 1, MEMORY_SIZE '2G',MAX_IOPS 1024, MIN_IOPS 1024, IOPS_WEIGHT 0, LOG_DISK_SIZE '2G';

创建resource pool

CREATE RESOURCE POOL pool1 UNIT='unit1',UNIT_NUM=1,ZONE_LIST=('zone1');

# 创建租户

create tenant ob_mysql resource_pool_list=('pool1'), primary_zone='RANDOM',comment 'mysql tenant/instance', charset='utf8' set ob_tcp_invited_nodes='%', ob_compatibility_mode='mysql';

命令过程

obclient [oceanbase]> CREATE RESOURCE POOL pool1 UNIT='unit1',UNIT_NUM=1,ZONE_LIST=('zone1');

Query OK, 0 rows affected (0.013 sec)

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

Query OK, 0 rows affected (26.092 sec)

五、创建用户及测试数据

obclient [oceanbase]> create database banjin;

Query OK, 1 row affected (0.033 sec)

obclient [oceanbase]> use banjin

Database changed

obclient [banjin]>

obclient [banjin]> show tables

-> ;

Empty set (0.003 sec)

obclient [banjin]> create table t1(id int,name varchar(10),primary key (id));

Query OK, 0 rows affected (0.097 sec)