【产品名称】
oceanbase-ce-3.1.2-7fafba0fac1e90cbd1b5b7ae5fa129b64dc63aed
【产品版本】
3.1.2
【问题描述】
采用obd部署三台物理服务器,CPU 64core 内存128GB,三台物理服务器均配置完毕免密登录、防火墙、selinux、时钟同步,检查如下:
[admin@fompdb1 ~]$ ntpstat
synchronised to local net (127.127.1.0) at stratum 9
time correct to within 11 ms
polling server every 64 s
[admin@fompdb1 ~]$ ssh fompdb2 ntpstat
synchronised to NTP server (192.168.5.140) at stratum 10
time correct to within 45 ms
polling server every 1024 s
[admin@fompdb1 ~]$ ssh fompdb3 ntpstat
synchronised to NTP server (192.168.5.140) at stratum 10
time correct to within 39 ms
polling server every 1024 s
obd配置文件如下:
user:
username:admin
password:admin-.2022
oceanbase-ce:
servers:
- name: server1
Please don’t use hostname, only IP can be supported
ip: 192.168.5.140
- name: server2
Please don’t use hostname, only IP can be supported
ip: 192.168.5.141
- name: server3
Please don’t use hostname, only IP can be supported
ip: 192.168.5.142
global:
Please set devname as the network adaptor’s name whose ip is in the setting of severs.
if set severs as “127.0.0.1”, please set devname as “lo”
if current ip is 192.168.1.10, and the ip’s network adaptor’s name is “eth0”, please use “eth0”
devname: eno1
cluster_id: 1
please set memory limit to a suitable value which is matching resource.
memory_limit: 48G # The maximum running memory for an observer
system_memory: 4G # The reserved system memory. system_memory is reserved for general tenants. The default value is 30G.
__min_full_resource_pool_memory: 268435456
stack_size: 512K
cpu_count: 24
cache_wash_threshold: 1G
workers_per_cpu_quota: 10
schema_history_expire_time: 1d
The value of net_thread_count had better be same as cpu’s core number.
net_thread_count: 24
major_freeze_duty_time: Disable
minor_freeze_times: 10
enable_separate_sys_clog: 0
enable_merge_by_turn: FALSE
datafile_disk_percentage: 10 # The percentage of the data_dir space to the total disk space. This value takes effect only when datafile_size is 0. The default value is 90.
syslog_level: WARN # System log level. The default value is INFO.
enable_syslog_wf: false # Print system logs whose levels are higher than WARNING to a separate log file. The default value is true.
enable_syslog_recycle: true # Enable auto system log recycling or not. The default value is false.
max_syslog_file_count: 4 # The maximum number of reserved log files before enabling auto recycling. The default value is 0.
root_password: # root user password, can be empty
server1:
mysql_port: 2881 # External port for OceanBase Database. The default value is 2881. DO NOT change this value after the cluster is started.
rpc_port: 2882 # Internal port for OceanBase Database. The default value is 2882. DO NOT change this value after the cluster is started.
home_path: /home/admin
data_dir: /data
redo_dir: /redo
zone: zone1
server2:
mysql_port: 2881
rpc_port: 2882
home_path: /home/admin
data_dir: /data
redo_dir: /redo
zone: zone2
server3:
mysql_port: 2881
rpc_port: 2882
home_path: /home/admin
data_dir: /data
redo_dir: /redo
zone: zone3
obproxy:
depends:
- oceanbase-ce
servers:
- 192.168.5.140
- 192.168.5.141
- 192.168.5.142
global:
home_path: /home/admin/oceanbase
rs_list: 192.168.5.140:2881;192.168.5.141:2881;192.168.5.142:2881