Overview

This page is created to investigate Aurora serverless performance by comparing DB xlarge, 8xlarge and Aurora serverless instance types under load running Data Import (DI) with Check-in Check-out (CICO) running as background.

Summary

Tests

Job profiles - PTF - Create 2, PTF - Updates Success - 1

Scenario
DI Create 25K, DI Update 25K
DI Create 25K, DI Update 25K with CICO 20 users in parallel
CICO 20 users

Each scenario was tested on next configurations:

DB configuration
RDS	db.r6g.xlarge
RDS	db.r6g.8xlarge
Serverless	Serverless v2 (0.5 - 128 ACUs)
Serverless	Serverless v2 (32 - 128 ACUs)

Results

Process/request	RDS		Serverless
Process/request	xlarge	8xlarge	0.5-128 ACU	32-128 ACU
DI Create	18 min	9 min	11 min (-7 min)	14 min (+5 min)
DI Update	17 min	10 min	16 min (-1 min)	11 min (+1 min)
DI Create (with CICO in parallel)	22 min	9 min	20 min (-2 min)	11 min (+2 min)
DI Update (with CICO in parallel)	22 min, error	12 min	25 min, error* (+3 min)	12 min (0 min)
CI, 95%	0.68	0.718	0.806 (+0.126 sec)	0.794 (+0.076 sec)
CO, 95%	1.247	1.251	1.393 (+0.146 sec)	1.312 (+0.061 sec)
CI (with DI Update in parallel), 95%	1.36	1.193	1.277 (-0.083 sec)	1.11 (-0.083 sec)
CO (with DI Update in parallel), 95%	2.335	2.062	2.321 (-0.014 sec)	1.963 (-0.099 sec)