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

The environment can handle the load with all compared DB instance types.
No significant changes were observed comparing response times for CICO between two instance types db.r6g.xlarge and serverless.
In Aurora serverless DI duration better for larger DI files.
Serverless v2 (32 - 128 ACUs) DB instance type configuration performs better from the start than (0.5 - 128 ACUs) due to increased capacity and its performance closer to 8xlarge. But to cut costs it's better to use (0.5 - 128 ACUs) for DB reader instance role.
Aurora serverless RDS CPU didn't exceed 25% for any file size. Execution time or test duration has tendency to decreasing for bigger file size because of bigger ACUs.
Time duration of DI without CICO didn't change after task count: mod-inventory, mod-inventory-storage, mod-circulation, mod-circulation-storage x 4.

Results

The table includes test results from running on different database instance types Here we observe that RDS CPU utilization for db.r6g.xlarge has maximum values and test duration grows proportional to file size.

But after database was switched to Aurora serverless RDS CPU didn't exceed 25% for any file size. Execution time or test duration has tendency to decreasing for bigger file size because of bigger ACUs.

DI CICO Total results

Create
Job profile: Default - Create instance and SRS MARC Bib

RDS

db.r6g.8xlarge

RDS

db.r6g.xlarge

Serverless

Serverless v2 (0.5 - 128 ACUs)

Serverless

Serverless v2 (32 - 128 ACUs)

Users

File - Records

Duration (CICO)

Max CPU utilization

Duration

Max CPU utilization

Duration

Max CPU utilization

Duration

ACUs

Max CPU utilization

Duration

1

DI Create

10k

37

27

00:05:15

00:03:21

96

00:09:59

17

00:10:07

16

00:07:17 ↓ 28%

25k

45

30

00:10:04

00:08:08

96

00:18:19

24

00:13:43

22

00:11:44 ↓ 15%

50k

30

00:15:54

93

00:37:05

25

00:22:57

24

00:20:01 ↓ 11%

2

CICO + DI Create

20

10k

90 min

39

Browser not supported