Sysbench benchmark report of OceanBase Database

Test environment (Alibaba Cloud ECS)

• Hardware configurations

  Service type	ECS type	Number of instances	Number of CPU cores	Memory
  OceanBase Database	ecs.g7.8xlarge	3	32 cores	128 GB Each server has a built-in 300 GB system disk and two attached 400 GB cloud disks as the clog disk and data disk respectively. The disk performance level is PL1.
  Sysbench	ecs.c7.4xlarge	1	16 cores	32 GB
  OceanBase Database Proxy (ODP)	ecs.c7.16xlarge	1	64 cores	128 GB

• Tenant specifications:

  CREATE RESOURCE UNIT sysbench_unit max_cpu 26, memory_size '100g'
  CREATE RESOURCE POOL sysbench_pool unit = 'sysbench_unit', unit_num = 1, zone_list=('zone1','zone2','zone3');
  CREATE TENANT sysbench_tenant resource_pool_list=('sysbench_pool'),  zone_list('zone1', 'zone2', 'zone3'), primary_zone=RANDOM, locality='F@zone1,F@zone2,F@zone3' set variables ob_compatibility_mode='mysql', ob_tcp_invited_nodes='%';
  

• Software versions

  Service type	Software version
  OceanBase Database	OceanBase Database Enterprise Edition V4.2.2.0 OceanBase Database Community Edition V4.2.2.0
  ODP	V4.2.1
  Sysbench	1.0.20
  OS	CentOS Linux release 7.9.2009 (Core)

Test plan

1. Use OceanBase Deployer (obd) to deploy an OceanBase cluster. Deploy ODP on a separate server.

2. Deploy the cluster in the 1-1-1 architecture, where the cluster has three zones and each zone has one OBServer node. After successful deployment, create the tenant and user required for running the Sysbench benchmark. The sys tenant is a built-in system tenant used for managing the cluster. Do not use the sys tenant to run the benchmark. Set the value of the primary_zone to RANDOM for the tenant, which indicates that the leader of the new table partitions is randomly assigned to one of the three OBServer nodes.

3. Launch the Sysbench client, and run the POINT_SELECT, READ_WRITE, READ_ONLY, and WRITE_ONLY tests.

4. Set the time parameter to 60s for each round of test. The number of threads can be 32, 64, 128, 256, 512, or 1024.

Test specifications

--mysql-db=test 
--table_size=1000000 
--tables=30 
--threads=32/64/128/256/512/1024 
--report-interval=10
--time=60
--db-ps-mode=disable
--rand-type=uniform

Results

POINT_SELECT performance

READ_ONLY performance

WRITE_ONLY performance

READ_WRITE performance