OceanBase 开源版V3.1.1压力测试情况
1. 测试方案
使用 OBD 部署 OceanBase 数据库,集群部署规模为1:1:1,OBProxy、OBClient 以及 TPC-C 与 TPC-H 测试工具部署在另一台服务器上, 作为客户端的压力测试服务器,分别进行 TPC-C 与 TPC-H 测试。测试集群拓扑示意图如下:
2. 测试环境
2.1. 硬件配置
测试祼金属服务器四台,硬件配置如下:
2.2. 软件环境
安装主要软件及其版本如下:
1.进程打开文件参数优化
2.网络参数优化
2.4. OceanBase 安装配置
distribute.yml 完整配置如下:
user:username: adminkey_file: /home/admin/.ssh/id_rsaport: 48539
oceanbase-ce:servers:- name: server1ip: 10.30.30.11- name: server2ip: 10.30.30.12- name: server3ip: 10.30.30.13global:devname: eth3memory_limit: 128Gsystem_memory: 30Gdatafile_disk_percentage: 20syslog_level: INFOenable_syslog_wf: falseenable_syslog_recycle: truemax_syslog_file_count: 4skip_proxy_sys_private_check: trueserver1:mysql_port: 2881rpc_port: 2882home_path: /opt/oceanBase_data/admindata_dir: /opt/oceanBase_data/dataredo_dir: /opt/oceanBase_data/repozone: zone1server2:mysql_port: 2881rpc_port: 2882home_path: /opt/oceanBase_data/admindata_dir: /opt/oceanBase_data/dataredo_dir: /opt/oceanBase_data/repozone: zone2server3:mysql_port: 2881rpc_port: 2882home_path: /opt/oceanBase_data/admindata_dir: /opt/oceanBase_data/dataredo_dir: /opt/oceanBase_data/repozone: zone3
obproxy:depends:- oceanbase-ceservers:
- 10.30.10.27global:listen_port: 2883prometheus_listen_port: 2884home_path: /home/admin/oceanBase/proxy/enable_cluster_checkout: falseskip_proxy_sys_private_check: true
相关文章