Test Method

This section describes performance testing of GeminiDB DynamoDB instances, including the test environment, procedure, and results.

Test Environment

Region: CN North-Beijing4
AZ: AZ1
Elastic Cloud Server (ECS): h3.4xlarge.2 with 16 vCPUs, 32 GB of memory, and CentOS 7.5 64-bit image
Pressure test data model: The size of each line is 1 KB.
Average CPU load in the pressure test: 50%.

Instance specifications: All specifications described in Table 1

**Table 1** Instance specifications
No.	Specifications
Cluster 1	4 vCPUs \| 16 GB
Cluster 2	8 vCPUs \| 32 GB
Cluster 3	16 vCPUs \| 64 GB
Cluster 4	32 vCPUs \| 128 GB

Test Tool

YCSB is an open-source tool for testing performance of databases. In this test, YCSB 0.17.0 is used. For details about the load balancing policy, see the provided load balancing plug-in.

For details on how to use this tool, see YCSB.

Test Metrics

Operations per Second (OPS): operations executed by a database per second

Test Procedure

Configure the workload file.
Set values for fields readproportion, insertproportion, updateproportion, scanproportion, and readmodifywriteproportion in the file by referring to Table 2.

Set a value for field recordcount in the file by referring to Table 3.

Use workload-insert-mostly as an example. Run the following command to prepare test data:

nohup ./bin/ycsb load dynamodb -s -P workloads/workload-insert-mostly -P dynamodb.properties -p operationcount=400000000 -p recordcount=400000000 -threads ${thread} -p maxexecutiontime=${maxexecutiontime} -s 1> data_load.log 2>&1 &

Use workload-insert-mostly as an example. Run the following command to test performance:

nohup ./bin/ycsb run dynamodb -s -P workloads/workload-insert-mostly -P dynamodb.properties -p operationcount=9000000 -p recordcount=9000000 -threads ${thread} -s 1> workload-insert-mostly_run.log 2>&1 &