实践练习二：手动部署 OceanBase 集群

实验环境

Linux version 3.10.0-1160.45.1.el7.x86_64 

硬件配置

处理器4核、内存16GB   200G硬盘

单节点集群安装

角色	机器	ZONE	端口
observer	10.106.0.70	zone1	2881,2882
obproxy	10.106.0.70		2883,2884

1.安装前操作系统参数设置准备

修改系统参数

vi /etc/security/limits.conf

* soft nofile 655350

* hard nofile 655350

* soft stack 20480

* hard stack 20480

* soft nproc 655360

* hard nproc 655360

* soft core unlimited

* hard core unlimited

退出登陆，检查设置生效

内核参数配置

[root@dba_mysql8 software]#  vi /etc/sysctl.conf

fs.aio-max-nr = 65536

net.core.somaxconn = 2048

net.core.netdev_max_backlog = 10000

net.core.rmem_default = 16777216

net.core.wmem_default = 16777216

net.core.rmem_max = 16777216

net.core.wmem_max = 16777216

net.ipv4.ip_local_port_range = 3500 65535

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

net.ipv4.tcp_syncookies = 0

net.ipv4.tcp_rmem = 4096 87380 16777216

net.ipv4.tcp_wmem = 4096 65536 16777216

net.ipv4.tcp_max_syn_backlog = 16384

net.ipv4.tcp_fin_timeout = 15

net.ipv4.tcp_max_syn_backlog = 16384

net.ipv4.tcp_tw_reuse = 1

net.ipv4.tcp_tw_recycle = 1

net.ipv4.tcp_slow_start_after_idle=0

vm.swappiness = 0

fs.aio-max-nr=1048576

vm.min_free_kbytes = 2097152

vm.max_map_count=655360

关闭防火墙和Selinux

[root@dba_mysql8 software]#  systemctl stop  firewalld

[root@dba_mysql8 software]# vi /etc/selinux/config

立即生效：

setenforce 0

2.安装OB数据库准备

上传安装包到该服务器

-rw-r--r--  1 root root  101M Mar 14 19:00 oceanbase-ce-4.2.2.1-101000012024030709.el7.x86_64.rpm

-rw-r--r--  1 root root  121M Mar 14 19:00 obproxy-ce-4.2.3.0-3.el7.x86_64.rpm

-rw-r--r--  1 root root  155K Mar 14 19:00 oceanbase-ce-libs-4.2.2.1-101000012024030709.el7.x86_64.rpm

-rw-r--r--  1 root root   12M Mar 14 19:00 obclient-2.2.3-1.el7.x86_64.rpm

-rw-r--r--  1 root root  1.4M Mar 14 19:00 libobclient-2.2.3-1.el7.x86_64.rpm

新建账号admin  

groupadd admin

useradd -d /home/admin -s /bin/bash -m admin

sudo chown -R admin:admin /home/admin

设置密码。

passwd admin

授权admin有root权限

1.chmod u+w /etc/sudoers

2.vim /etc/sudoers

在root ALL=(ALL) ALL

此行下面加入 admin ALL=(ALL) ALL

3.chmod u-w /etc/sudoers

[root@dba_mysql8 ~]# cat  /etc/sudoers

安装目录和软件

安装oceanbase数据库rpm包

Oceanbase数据库软件会安装在目录 下，使用admin用户安装

[root@dba_mysql8 ~]# su - admin
Last login: Thu Mar 14 22:29:44 CST 2024 on pts/0
[admin@dba_mysql8 ~]$ sudo yum install oceanbase-ce* -y