AWS RDS Simulating Outages – Several Methods

All of these are commonly refered to as SQL Injection Faults

Fault Injection – Reader or Writer Crash

ALTER SYSTEM CRASH
[ INSTANCE I DISPATCHER | NODE ];
	Instance = DB instance (default crash type)
	Dispatcher = writes updates to the cluster volume
	Node = Instance + Dispatcher

Fault Injection – Replica Failure

ALTER SYSTEM SIMULATE
percentage_of_failure PERCENT READ REPLICA FAILURE [ TO ALL I TO "replica name" ]
FOR INTERVAL quantity
{ YEAR I QUARTER | MONTH | WEEK | DAY | HOUR MINUTE I SECOND };

percentage_of_failure - % of requests to block
TO ALL / TO = simulate failure of all or a specific replica

Fault Injection Disk Failure

ALTER SYSTEM SIMULATE
percentage_of_failure PERCENT DISK FAILURE [ IN DISK index | NODE index ]
FOR INTERVAL quantity
{ YEAR I QUARTER | MONTH | WEEK | DAY | HOUR MINUTE I SECOND };

percentage_of_failure = % of the disk to mark as faulting DISK index = simulate failure of a specific logical block of data NODE index = simulate failure of a specific storage node

Leave a Comment

Scroll to Top