- 目录
=====
2. OceanBase Docker 体验
2.1. 主机环境
IP
192.168.122.1
Os
CentOS Linux release 7.9.2009 (Core)
内存
16g
Cpu
4core
2.2. Docker环境检查
查看docker版本(若docker未安装，则进行下面的docker安装)
[root@localhost ~]# docker --version
Docker version 1.13.1, build 7d71120/1.13.1
安装docker
yum install docker -y
启动docker服务
systemctl start docker
设置docker开机启动
systemctl enable docker
[root@localhost ~]# systemctl enable docker
Created symlink from /etc/systemd/system/multi-user.target.wants/docker.service to /usr/lib/systemd/system/docker.service.
[root@localhost ~]#
检查docker进程
systemctl status docker
查看docker版本
[root@localhost ~]# docker --version
Docker version 1.13.1, build 7d71120/1.13.1
2.3. 使用Docker镜像安装OceanBase
2.3.1.查询可用oceanbase的可用镜像
执行命令：docker search oceanbase
docker search oceanbase
2.3.2.下载镜像
下载docker镜像 obpilot/oceanbase-ce 也可以下载oceanbase/obce-mini
执行命令：docker images 查看当前本地可用镜像（无任何可用镜像）
docker pull obpilot/oceanbase-ce
2.3.3.查看镜像
docker images
2.3.4.运行容器
docker run -itd -m 8G -p 2881:2881 -p 2883:2883 --name obcluster obpilot/oceanbase-ce:latest
2.3.5.查看进程
docker ps
2.3.6.进入容器
docker exec -it obcluster bash
2.4. OBD 命令部署OB集群
2.4.1.启动OB服务
obd cluster list
obd cluster start obdemo
2.4.2.查看OB集群运行状态
obd cluster display obdemo
2.5. OceanBase初体验
2.5.1.连接OceanBase集群
集群名obce-single可以从ob配置文件获取
obclient -h127.1 -uroot@sys#obce-single -P2883 -prootPWD123 -c -A oceanbase
2.5.2.查看集群资源
SELECT * FROM __all_server\G; – 查看集群状态
SELECT svr_ip,svr_port, cpu_total, mem_total/1024/1024/1024,
disk_total/1024/1024/1024, zone FROM __all_virtual_server_stat;
– 查询系统总计资源
– 查询租户已分配资源：
SELECT sum(c.max_cpu), sum(c.max_memory)/1024/1024/1024 FROM __all_resource_pool as a, __all_unit_config AS c
WHERE a.unit_config_id=c.unit_config_id;
Note：资源池cpu共14c/4g 租户已用 5c/1G 新建租户最大可用为 9c/3g（超分会报错）
2.5.3.资源分配
CREATE RESOURCE UNIT u1 max_cpu = 4, max_memory = ‘1G’, min_memory = ‘1G’, max_iops = 10000, min_iops = 10000, max_session_num = 30000, max_disk_size = ‘4G’; --创建资源单元(4c/1G 硬盘大小为4G)
SELECT * FROM __all_unit_config; – 查看资源规格
CREATE RESOURCE POOL pool1 UNIT = ‘u1’, UNIT_NUM = 1,ZONE_LIST = (‘zone1’); – 创建资源池
CREATE TENANT IF NOT EXISTS obtest charset=‘utf8mb4’, replica_num=1, zone_list=(‘zone1’), primary_zone=‘zone1’, resource_pool_list=(‘pool1’); – 创建租户
select tenant_id,tenant_name,primary_zone from __all_tenant; – 查看租户
2.5.4.登录业务租户创建业务用户
登录新建租户，创建用户
obclient -h127.1 -uroot@obtest#obce-single -P2883 -c -A oceanbase
CREATE USER ‘obuser1’ IDENTIFIED BY ‘abc123’;
grant all on *.* to ‘obuser1’ WITH GRANT OPTION;
2.5.5.业用户登录OB集群创建业务表
obclient -h127.1 -u obuser1@obtest#obce-single -P2883 -pabc123 -c -A
MySQL [(none)]> create database demo;
Query OK, 1 row affected (0.064 sec)
MySQL [(none)]> use demo;
Database changed
MySQL [demo]> create table t1(id int(4) primary key, name varchar(20));
Query OK, 0 rows affected (0.100 sec)
MySQL [demo]> insert into t1 select 1,‘tom’;
Query OK, 1 row affected (0.025 sec)
MySQL [demo]> select * from t1;
±—±-----+
| id | name |
±—±-----+
| 1 | tom |
±—±-----+
1 row in set (0.009 sec)
