「OceanBase 征文」在虚拟机上1分钟快速部署“小鱼”

题记：
2023年3月25日在OceanBase开发者大会, OceanBase的CTO杨传辉表示，未来的数据库系统应该是单机和分布式整合一起，形成一种新的单机分布式一体化架构，并表示单机分布式一体化是数据库的未来，OceanBase的单机分布式一体化数据库，不仅仅是降成本，更是空中换发动机，能帮助客户更好地实现降本增效。

一、小鱼介绍

小鱼是我国自主研发的原生分布式数据库OceanBase发布4.0版本，推出业内唯一单机分布式一体化数据库，这是中国在数据库领域实现的又一技术突破。

OceanBase 4.0，打破了分布式技术的不可能，推出业内首个单机分布式一体化数据库。它的特点是既可以像单机数据库一样使用，又拥有分布式数据库无限水平扩展的能力。这种架构让它可以适应从个人小站点到银行核心系统、大型电商网站等各种规模的业务。企业选用后，可以在业务发展不同阶段根据自身特点，灵活满足性价比和高可用的要求。

二、小鱼部署

1、实操环境

虚拟机环境：

操作系统： centos7.9  内存：9G  硬盘：23G 
    OceanBase 4.0 mini

2、安装软件

（1）下载并安装 all-in-one package，OceanBase 4.0 提供了统一的安装包  
wget https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/oceanbase-all-in-one/7/x86\_64/oceanbase-all-in-one-4.0.0.0-100120230113164218.el7.x86\_64.tar.gz  
（2）解压
tar -xvf  oceanbase-all-in-one-4.0.0.0-100120230113164218.el7.x86\_64.tar.gz
（3）安装软件
cd oceanbase-all-in-one/bin
./install.sh   
（4）设置环境变量
source ~/.oceanbase-all-in-one/bin/env.sh  

3、规划observer、redo和data目录，要求目录最少20G

mkdir /data/obdata  
mkdir /data/obredo
mkdir /data/observer

4、编辑小鱼安装的的配置文件

cd oceanbase-all-in-one/conf  

5、使用obd工具进行部署和数据库初始化，整个过程需要1分钟

[root@k8s-node2 conf]# obd cluster deploy obmini -c mini-local-example.yaml  
install oceanbase-ce-4.0.0.0 for local ok  
+--------------------------------------------------------------------------------------------+  
| Packages |  
+--------------+---------+------------------------+------------------------------------------+  
| Repository | Version | Release | Md5 |  
+--------------+---------+------------------------+------------------------------------------+  
| oceanbase-ce | 4.0.0.0 | 103000022023011215.el7 | 1d56dc742f5f05a2d15797d291b51a94019e728d |  
+--------------+---------+------------------------+------------------------------------------+  
Repository integrity check ok  
Parameter check ok  
Open ssh connection ok  
Cluster status check ok  
Initializes observer work home ok  
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-	1d56dc742f5f05a2d15797d291b51a94019e728d repository install ok  
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-	1d56dc742f5f05a2d15797d291b51a94019e728d repository lib check !!  
Try to get lib-repository  
install oceanbase-ce-libs-4.0.0.0 for local ok  
Remote oceanbase-ce-libs-4.0.0.0-103000022023011215.el7-	ef48cff7633e3dbc39f5c0abdcd72348213e09a2 repository install ok  
Remote oceanbase-ce-4.0.0.0-103000022023011215.el7-1d56dc742f5f05a2d15797d291b51a94019e728d repository lib check ok  
obmini deployed  
[root@k8s-node2 conf]# obd cluster start obmini  
Get local repositories ok  
Search plugins ok  
Open ssh connection ok  
Load cluster param plugin ok  
Check before start observer ok  
[WARN] (192.168.10.4) clog and data use the same disk (/data)  

Start observer ok  
observer program health check ok  
Connect to observer ok  
Initialize cluster ok  
Wait for observer init ok  
+------------------------------------------------+  
| observer |  
+--------------+---------+------+-------+--------+  
| ip | version | port | zone | status |  
+--------------+---------+------+-------+--------+  
| 192.168.10.4 | 4.0.0.0 | 2881 | zone1 | ACTIVE |  
+--------------+---------+------+-------+--------+  
obmini running  
查看集群状态
[root@k8s-node2 conf]# obd cluster list  
+------------------------------------------------------+  
| Cluster List |  
+--------+---------------------------+-----------------+  
| Name | Configuration Path | Status (Cached) |  
+--------+---------------------------+-----------------+   
| obmini | /root/.obd/cluster/obmini | running |  
+--------+---------------------------+-----------------+ 
查询集群对应的节点
root@k8s-node2 conf]# obd cluster display  obmini
Get local repositories and plugins ok
Open ssh connection ok
Cluster status check ok
Connect to observer ok
Wait for observer init ok
+------------------------------------------------+
|                    observer                    |
+--------------+---------+------+-------+--------+
| ip           | version | port | zone  | status |
+--------------+---------+------+-------+--------+
| 192.168.10.4 | 4.0.0.0 | 2881 | zone1 | ACTIVE |
+--------------+---------+------+-------+--------+
登录验证
[root@k8s-node2 conf]# obclient -h192.168.10.4 -P2881 -uroot -Doceanbase  
Reading table information for completion of table and column names  
You can turn off this feature to get a quicker startup with -A  

Welcome to the OceanBase. Commands end with ; or \\g.  
Your OceanBase connection id is 3221487617  
Server version: OceanBase\_CE 4.0.0.0 (r103000022023011215-05bbad0279302d7274e1b5ab79323a2c915c1981) (Built Jan 12 2023 15:28:27)  

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.  

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

obclient \[oceanbase\]> show databases;  
+--------------------+  
| Database |  
+--------------------+  
| information\_schema |  
| LBACSYS |  
| mysql |  
| oceanbase |  
| ORAAUDITOR |  
| SYS |  
| test |  
+--------------------+  
7 rows in set (0.008 sec)  

三、总结

OceanBase部署速度太惊人，部署仅仅需要一分钟全程无报错，在我的影响中国产的分布式数据库普遍存在难部署而且部署过程中错误不断，记得当年部署TIDB和巨杉数据库部署了好几个小时，甚至因为部署难选择放弃。
最后引用OceanBase CEO杨冰的一句话“OceanBase的一小步，将是数据库行业的重要一步”，让数据库运维更简单。中国基础软件行业已经有能力进行“根创新”，坚持长期投入，数据库行业终将迎来爆发。