测试环境配置：
8C16G100G的虚拟机
系统是CentOS7.9
1、安装docker
安装所需要的系统工具
yum install -y yum-utils device-mapper-persistent-data lvm2
添加镜像源
yum-config-manager --add-repo http://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo
更新yum缓存
yum makecache fast
安装docker-ce
yum -y install docker-ce
启动docker服务
systemctl start docker
2、安装oceanbase-ce
查看oceanbase镜像
docker search oceanbase
拉取镜像
docker pull obpilot/oceanbase-ce:latest
运行
docker run -itd -m 12G --name oceanbase-ce obpilot/oceanbase-ce:latest
3、进入容器，OBD 命令完成OceanBase 集群部署
docker exec -it oceanbase-ce bash
查看集群信息
[admin@230e42a0206a ~]$ obd cluster list
+------------------------------------------------------------+
| Cluster List |
+--------+---------------------------------+-----------------+
| Name | Configuration Path | Status (Cached) |
+--------+---------------------------------+-----------------+
| obdemo | /home/admin/.obd/cluster/obdemo | deployed |
+--------+---------------------------------+-----------------+
启动
[admin@230e42a0206a ~]$ obd cluster start obdemo
Get local repositories ok
Search plugins ok
Open ssh connection ok
Load cluster param plugin ok
Check before start observer ok
[WARN] (127.0.0.1) clog and data use the same disk (/)
Check before start obproxy ok
Start observer ok
observer program health check ok
Connect to observer ok
Initialize cluster ok
Start obproxy ok
obproxy program health check ok
Connect to obproxy ok
Initialize cluster ok
Wait for observer init ok
+---------------------------------------------+
| observer |
+-----------+---------+------+-------+--------+
| ip | version | port | zone | status |
+-----------+---------+------+-------+--------+
| 127.0.0.1 | 4.0.0.0 | 2881 | zone1 | ACTIVE |
+-----------+---------+------+-------+--------+
obclient -h127.0.0.1 -P2881 -uroot -prootPWD123 -Doceanbase
+---------------------------------------------+
| obproxy |
+-----------+------+-----------------+--------+
| ip | port | prometheus_port | status |
+-----------+------+-----------------+--------+
| 127.0.0.1 | 2883 | 2884 | active |
+-----------+------+-----------------+--------+
obclient -h127.0.0.1 -P2883 -uroot -prootPWD123 -Doceanbase
obdemo running
4、通过obproxy连接ob，创建业务租户、数据库和表
obclient -h127.0.0.1 -P2883 -uroot -prootPWD123 -Doceanbase
创建资源单元 U2C4G 配置为 2 个 CPU，4G 内存，128- 个 IOPS，10G 日志盘
CREATE RESOURCE UNIT U2C4G MAX_CPU 2, MEMORY_SIZE '4G', MAX_IOPS 1280,LOG_DISK_SIZE '10G', MIN_IOPS=1024;
创建资源池时报错，内存不足
CREATE resource pool my_pool unit = 'U2C4G', unit_num = 1;
obclient [oceanbase]> CREATE resource pool my_pool unit = 'U2C4G', unit_num = 1;
ERROR 4733 (HY000): zone 'zone1' resource not enough to hold 1 unit. You can check resource info by views: DBA_OB_UNITS, GV$OB_UNITS, GV$OB_SERVERS.
server '"127.0.0.1:2882"' MEMORY resource not enough
将U2C4G调小为2G后重新创建资源池成功
Alter resource unit U2C4G MEMORY_SIZE '2G';
创建业务租户
create tenant obmysql resource_pool_list=('my_pool'), primary_zone='RANDOM',comment 'mysql tenant/instance', charset='utf8mb4' set ob_tcp_invited_nodes='%', ob_compatibility_mode='mysql';
登录obmysql租户，默认密码为空
obclient -h 127.1 -uroot@obmysql -P2883 -p -c
修改租户的root密码，下次登录后需要输入密码
ALTER USER root IDENTIFIED BY 'Hello123';
创建业务数据库和表
obclient [(none)]> create database testdb1;
Query OK, 1 row affected (0.035 sec)
obclient [(none)]> use testdb1;
Database changed
obclient [testdb1]> create table t1(id int,content varchar(10));
Query OK, 0 rows affected (0.076 sec)
obclient [testdb1]> insert into t1 values(1,'test');
Query OK, 1 row affected (0.020 sec)
obclient [testdb1]> select * from t1;
+------+---------+
| id | content |
+------+---------+
| 1 | test |
+------+---------+
1 row in set (0.003 sec)
