Scope database rights

Lock 12
HTTP/2HTTP/2SQLSQLUsers1,000 req/sUsers50 req/sNode API2 vCPU · 1 GBNode API1 vCPU · 1 GBPostgres4 vCPU · 1 GB
HTTP/2HTTP/2SQLSQLUsers1,000 req/sUsers50 req/sNode API2 vCPU · 1 GBNode API1 vCPU · 1 GBPostgres4 vCPU · 1 GB

Fix the board. Turn every goal green.

Traffic
Reports50 req/s · reads onlyOrders1,000 req/s · 50% reads
Limit
Node API answers about 500 req/s
Bill
  • Node API8 USD/mo
  • Node API4 USD/mo
  • Postgres16 USD/mo
28 of 60 USD/mo

Goals

Not tested yet

The share of requests that fail or get no answer.The share of requests that fail or get no answer.99 of 100 requests finish faster than this.What the servers and services cost each month.

At 0:20 an attacker takes over the report service and deletes orders through its database link. Orders take 1,000 requests/s and reports read 50/s. Keep both under 1 percent errors and orders p99 under 50 ms. No order row may change. Use at most 3 edits.

00:21 Audit alert: the report service runs DELETE on the orders table. 100 rows changed each second.

A wait for a person needs its own queueTap or press Space to turn the approval queue on or off

One queue · 60 of 64 workers wait for a person · safe updates wait