OceanBase 4.3.5社区版集群部署

systemctl stop firewalld.service 
systemctl disable firewalld.service

sed -i 's/^SELINUX=enforcing$/SELINUX=disabled/' /etc/selinux/config
setenforce 0
[reboot]

cat >> /etc/hosts <<EOF
10.10.10.201 db01
10.10.10.202 db02
10.10.10.203 db03
10.10.10.204 db04
10.10.10.205 db05
10.10.10.206 db06
EOF

cat /sys/kernel/mm/transparent_hugepage/enabled

#如果上面返回结果不是never则需要进行以下配置
cat >>/etc/rc.d/rc.local <<EOF
if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
fi
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
fi
EOF

chmod +x /etc/rc.d/rc.local
[reboot]

cat >> /etc/security/limits.conf <<EOF
root soft nofile 655350
root hard nofile 655350
* soft nofile 655350
* hard nofile 655350
* soft stack unlimited
* hard stack unlimited
* soft nproc 655360
* hard nproc 655360
* soft core unlimited
* hard core unlimited
EOF

cat >> /etc/sysctl.conf <<EOF
#for oceanbase
修改内核异步 I/O 限制
fs.aio-max-nr = 1048576

#网络优化
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_forward = 0 
net.ipv4.conf.default.rp_filter = 1 
net.ipv4.conf.default.accept_source_route = 0 
net.ipv4.tcp_syncookies = 1 
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_slow_start_after_idle = 0

vm.swappiness = 0
vm.min_free_kbytes = 2097152
vm.overcommit_memory = 0

fs.file-max = 6573688
fs.pipe-user-pages-soft = 0

#修改进程可以拥有的虚拟内存区域数量
vm.max_map_count = 655360

#此处为 OceanBase 数据库的 data 目录
kernel.core_pattern = /oceanbase/data/core-%e-%p-%t
EOF

sysctl -p

mkdir /iso
mount -r /dev/sr0 /iso
rm -rf /etc/yum.repo.d/*

cat > /etc/yum.repos.d/iso.repo <<EOF
[AppStream]
name=AppStream
baseurl=file:///iso/AppStream
gpgcheck=0
enabled=1

[BaseOS]
name=BaseOS
baseurl=file:///iso/BaseOS
gpgcheck=0
enabled=1
EOF

groupadd -g 2000 admin
useradd -g 2000 -G admin admin
echo"admin" | passwd --stdin admin

cat >> /etc/sudoers <<EOF
admin       ALL=(ALL)       NOPASSWD: ALL
EOF

pvcreate /dev/nvme0n2
vgcreate vgob /dev/nvme0n2
lvcreate -n lvob -l 100%FREE vgob
mkfs.xfs /dev/mapper/vgob-lvob

mkdir /oceanbase

cat >> /etc/fstab <<EOF
/dev/mapper/vgob-lvob /oceanbase xfs defaults 0 0
EOF
systemctl daemon-reload
mount /oceanbase

chown admin:admin -R /oceanbase

su - admin
mkdir /oceanbase/server
mkdir /oceanbase/data
mkdir /oceanbase/redo

su - admin
ssh-keygen -t rsa
ssh-copy-id -i ~/.ssh/id_rsa.pub admin@10.10.10.201
ssh-copy-id -i ~/.ssh/id_rsa.pub admin@10.10.10.202
ssh-copy-id -i ~/.ssh/id_rsa.pub admin@10.10.10.203
ssh-copy-id -i ~/.ssh/id_rsa.pub admin@10.10.10.204
ssh-copy-id -i ~/.ssh/id_rsa.pub admin@10.10.10.205

su - admin
tar -xvf oceanbase-all-in-one-4.3.5_bp4_20250910.el8.x86_64.tar.gz
cd oceanbase-all-in-one/bin/
./install.sh

source ~/.oceanbase-all-in-one/bin/env.sh
obd web

obd cluster list
obd cluster display yhw_cluster

obclient -h10.10.10.204 -P2881 -uroot@testdb -p