裸机部署单副本 oceanbase-3.2.4.1 企业版(for ORACLE)集群

裸机部署单副本 oceanbase-3.2.4.1 企业版(for ORACLE)集群

OceanBase 也支持单副本部署，并且单副本 OceanBase 集群还可以扩容（增加节点），所以也称为集群。

裸机准备

配置:4cpu,12G内存,100G磁盘

[root@c7 ~]# cat /etc/redhat-release
CentOS Linux release 7.9.2009 (Core)


[root@c7 ~]# uname -r
3.10.0-1160.el7.x86_64


[root@c7 ~]# df -Th
Filesystem Type Size Used Avail Use% Mounted on
devtmpfs devtmpfs 5.8G 0 5.8G 0% /dev
tmpfs tmpfs 5.8G 0 5.8G 0% /dev/shm
tmpfs tmpfs 5.8G 8.9M 5.8G 1% /run
tmpfs tmpfs 5.8G 0 5.8G 0% /sys/fs/cgroup
/dev/mapper/centos-root xfs 99G 1.3G 98G 2% /
/dev/sda1 xfs 1014M 150M 865M 15% /boot
tmpfs tmpfs 1.2G 0 1.2G 0% /run/user/0


sudo yum install -y yum-utils wget net-tools tree
sudo yum-config-manager --add-repo https://mirrors.aliyun.com/oceanbase/OceanBase.repo


创建用户

useradd -U admin -d /home/admin -s /bin/bash
mkdir -p /home/admin
chown -R admin:admin /home/admin
mkdir -p /data
chown -R admin:admin /data


安装 oceanbase-3.2.4.1 企业版软件

https://www.oceanbase.com/softwarecenter-enterprise
填写相关信息，进行下载，安装

[root@c7 ~]# rpm -ivh oceanbase-3.2.4.1-101000052023010822.el7.x86_64.rpm
Preparing... ################################# [100%]
Updating / installing...
1:oceanbase-3.2.4.1-101000052023010################################# [100%]


初始化 OceanBase 目录

su - admin
export cluster_name=obdemo
echo $cluster_name
mkdir -p /data/1/$cluster_name/{etc3,sort_dir,sstable}
mkdir -p /data/log1/$cluster_name/{clog,etc2,ilog,slog,oob_clog}
mkdir -p /home/admin/oceanbase/store/$cluster_name
for t in {etc3,sort_dir,sstable};do ln -s /data/1/$cluster_name/$t /home/admin/oceanbase/store/$cluster_name/$t; done
for t in {clog,etc2,ilog,slog,oob_clog};do ln -s /data/log1/$cluster_name/$t /home/admin/oceanbase/store/$cluster_name/$t; done


目录验证:

cd /home/admin/oceanbase
tree store


[admin@c7 ~]$ cd /home/admin/oceanbase
[admin@c7 oceanbase]$ tree store
store
└── obdemo
├── clog -> /data/log1/obdemo/clog
├── etc2 -> /data/log1/obdemo/etc2
├── etc3 -> /data/1/obdemo/etc3
├── ilog -> /data/log1/obdemo/ilog
├── oob_clog -> /data/log1/obdemo/oob_clog
├── slog -> /data/log1/obdemo/slog
├── sort_dir -> /data/1/obdemo/sort_dir
└── sstable -> /data/1/obdemo/sstable


安装 OceanBase 客户端

sudo yum install -y obclient


初始化 OceanBase 集群

启动 observer 进程

su - admin
cd /home/admin/oceanbase && /home/admin/oceanbase/bin/observer -i ens192 -P 2882 -p 2881 -z zone1 -d /home/admin/oceanbase/store/obdemo -r '172.17.10.82:2882:2881' -c 10001 -n obdemo -o "__min_full_resource_pool_memory=268435456,system_memory=1G,datafile_size=50G,config_additional_dir=/data/1/obdemo/etc3;/data/log1/obdemo/etc2"


可通过 netstat -ntlp 命令查看 observer 进程是否启动成功。
如果监听到了 2881 与 2882 端口，则说明进程启动成功。

[admin@c7 ~]$ netstat -ntlp
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:2881 0.0.0.0:* LISTEN 17339/observer
tcp 0 0 0.0.0.0:2882 0.0.0.0:* LISTEN 17339/observer
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN -
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN -
tcp6 0 0 :::22 :::* LISTEN -
tcp6 0 0 ::1:25 :::* LISTEN -


集群 bootstrap 操作

通过 obclient 命令连接已启动的 observer 进程，密码为空。

obclient -h127.0.0.1 -uroot -P2881 -p
SET SESSION ob_query_timeout=1000000000;
ALTER SYSTEM BOOTSTRAP ZONE 'zone1' SERVER '172.17.10.82:2882'; # 耗时63s
SHOW DATABASES;
ALTER USER root IDENTIFIED BY '1'; # 修改密码


创建 OceanBase 租户

降低sys租户的资源

alter resource unit sys_unit_config min_cpu=1,max_cpu=1;
alter resource unit sys_unit_config min_memory='1G',max_memory='1G';


创建资源单元规格

资源单元仅仅是规格定义，不实际分配资源。

CREATE RESOURCE UNIT unit001
MAX_CPU 0.1,MAX_MEMORY '256M',MAX_IOPS 128,MAX_DISK_SIZE '512M',MAX_SESSION_NUM 64,
MIN_CPU 0.1,MIN_MEMORY '256M',MIN_IOPS 128;


创建资源池

资源池会实际创建 unit，按规格定义分配资源。

CREATE RESOURCE POOL pool001
UNIT='unit001',UNIT_NUM=1,ZONE_LIST=('zone1');


创建租户

将资源池分配给对应的租户
创建 Oracle 兼容模式租户

CREATE TENANT IF NOT EXISTS oracle001
CHARSET='utf8mb4',
PRIMARY_ZONE='zone1',
RESOURCE_POOL_LIST=('pool001')
SET ob_tcp_invited_nodes='%',ob_compatibility_mode='oracle';


设置管理员用户密码

使用 SQL 语句创建的租户，租户管理员用户密码为空。使用前请先设置密码。
– 登录sys用户,oracle001租户

obclient -h127.0.0.1 -P2881 -usys@oracle001 -p -A
SET PASSWORD = PASSWORD(1);


开始体验

SELECT to_char(SYSDATE,'yyyy.mm.dd HH24:mi:ss') FROM DUAL;


– 查看所有数据库用户

SELECT * FROM all_users;
+------------+------------------+-----------+
| USERNAME | USERID | CREATED |
+------------+------------------+-----------+
| LBACSYS | 1100611139403783 | 18-JUN-24 |
| ORAAUDITOR | 1100611139403784 | 18-JUN-24 |
| PUBLIC | 1100611139403781 | 18-JUN-24 |
| SYS | 1100611139403782 | 18-JUN-24 |
+------------+------------------+-----------+


– 查看当前连接数据库用户

SHOW PROCESSLIST;


– 通过 SQL 修改用户密码

ALTER USER SYS IDENTIFIED BY "1";


Have fun!