Benchmark

RDS AlwaysOn/Geo-Replicate Benchmarks

View performance benchmark statistics on various replication scenarios.

benchmark toolsAWS RDS HA Read-Replicas
(54 tables in database)

Benchmark Scenario:

  • Number of Databases: 1
  • Number of tables in the Database: 54
  • Volume of Changes: ~100 records per table inserted concurrently first into 4 tables, and later into all 54 tables

BenchmarkAWS Cross-Region Replication
(100 databases)

Benchmark Scenario:

  • Number of Databases: 100
  • Number of tables in the Database: 800
  • Volume of Changes: 1000s of updates/inserts/deletes per minute in 4 tables at a time in 20% of the databases

BenchmarkAWS Cross-Region Replication
(High Volume Changes)

Benchmark Scenario:

  • Moderate ~300,000 inserts per minute into 4 tables in a database hosted on an AWS Virginia based RDS R3.Xlarge instance, geo-replicated asynchronously to an AWS Oregon based smaller RDS R3.Large server.
  • Database size: ~400GB
  • Database size increment: ~150MB/min (~200GB/day)

benchmark toolsAWS-RDS to Azure-SQL Replication (Intercloud)

Benchmark Scenario:

  • Moderate ~100,000 inserts per minute into 4 tables, each with 500+ million records, into a database (size ~200GB) hosted on an AWS Virginia based RDS R3.2Xlarge instance, geo-replicated asynchronously to Azure SQL type P1. Data in transit is encrypted.
  • Database size: ~200GB
  • Database size increment: ~50MB/min (~70GB/day)