1、OceanBase社区版下载:
(1)官网下载
https://open.oceanbase.com/softwareCenter/community(2)GitHub下载
https://github.com/oceanbase/oceanbase/releases/(3)阿里云Yum源
https://mirrors.aliyun.com/oceanbase/OceanBase.repo设置阿里云Yum源的方法如下:
yum install -y yum-utils
yum-config-manager --add-repo https://mirrors.aliyun.com/oceanbase/OceanBase.repo
2、OceanBase部署模式
(1)Docker部署(用于学习,笔记本可部署)
(2)手动部署
- 单副本集群:observer(N) + obproxy(可选)
- 三副本集群:observer(N:N:N) + obproxy(必选)
(3)自动部署OBD(OceanBase Deployer 简称 OBD,是快速部署oceanbase的工具)
- 单副本集群:obd + observer(N) + obproxy(可选)
- 三副本集群:obd + observer(N:N:N) + obproxy(必选)

3、OceanBase Docker体验
(1)Docker软件安装准备:
- 内存不小于12GB的笔记本
- Docker下载地址 https://docs.docker.com/get-docker/
- 调整可用资源,内存>=10GB
(2)下载OB镜像
docker pull oceanbase/obce-mini(3)启动容器
docker run -p 2881:2881 --name obce-mini -d \-e OB_HOME_PATH="/root/obce/" \
-e OB_TENANT_NAME="obmysql" oceanbase/obce-mini
注:启动容器的过程,包括初始化OB,需要等待大约3分钟时间
(4)进入容器
docker exec -it obce-mini bash(5)查看OBD部署配置
obd cluster listobd cluster display mini-ce
(6)开始使用OceanBase单副本集群
ob-mysql sysob-mysql root
ob-mysql test
(7)查看集群资源情况
select a.zone,concat(a.svr_ip,':',a.svr_port) observer,cpu_total,(cpu_total-cpu_assigned) cpu_free,
round(mem_total/1024/1024/1024) mem_total_gb, round((mem_toal-mem_assigned)/1024/1024/1024) mem_free_gb,
round(a.disk_total/1024/1024/1024) disk_total_gb, usec_to_time(b.last_offline_time) last_offline_time,
usdc_to_time(b.start_service_time) start_service_time, b.status, usec_to_time(b.stop_time) stop_time,
b.build_version from __all_virtual_server_stat a join __all_server b
on (a.svr_ip=b.svr_ip and a.svr_port=b.svr_port) order by a.zone, a.svr_ip\G
(8)设置资源规格
create resource unit my_unit_config max_cpu=4, min_cpu=4, max_memory='2G', min_memory='2G', max_iops=10000, min_iops=1000, max_session_num=1000000, max_disk_size='1024G';
(9)设置资源池
create resource pool my_pool unit='my_unit_config', unit_num=1;(10)创建业务租户
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';(11)查看租户情况
use oceanbase;select * from __all_tenant;