OceanBase集群配置指南

集群安装步骤

1. 系统环境准备

# 设置时钟同步
sudo timedatectl set-ntp true

# 修改内核参数
sudo tee /etc/sysctl.d/90-oceanbase.conf <<EOF
fs.aio-max-nr = 1048576
fs.file-max = 6815744
net.core.somaxconn = 2048
EOF

sudo sysctl -p

2. 安装软件包

# 添加YUM源
sudo curl -o /etc/yum.repos.d/OceanBase.repo \
https://mirrors.aliyun.com/oceanbase/OceanBase.repo

# 安装主程序
sudo yum install -y \
    oceanbase-ce \
    oceanbase-ce-libs \
    obproxy \
    oceanbase-ce-utils

配置文件修改

📌 配置文件路径：/etc/oceanbase/observer.conf

基础配置

# 集群节点配置
cluster_id = 1
zone = zone1

# 网络配置
devname = eth0
mysql_port = 2881
rpc_port = 2882

# 资源限制
memory_limit = 64G
cpu_count = 16

存储配置

# 数据存储路径
datafile_size = 256G
datafile_disk_percentage = 80
log_disk_size = 128G

[storage]
data_dir = /data/ob/data
redo_dir = /data/ob/redo
sstable_dir = /data/ob/sstable
⚠️ 注意：修改配置后需要重启服务生效
sudo systemctl restart oceanbase

高级配置示例

OBProxy 配置

# 配置文件路径：/etc/obproxy/obproxy.yaml

server:
  port: 2883
  prometheus_port: 2884

observer:
  cluster_name: obcluster
  rs_list: 
    - 192.168.1.101:2882
    - 192.168.1.102:2882
    - 192.168.1.103:2882

log:
  level: INFO
  dir: /var/log/obproxy

参数优化

# 连接池配置
max_connections = 2000
connection_idle_timeout = 300s

# 日志配置
syslog_level = INFO
enable_syslog_recycle = true
max_syslog_file_count = 10

# 性能优化
enable_merge = true
enable_rebalance = true