Deploy highly available and scalable server clusters. If you run a MariaDB (MySQL) galera cluster over a WAN, deadlocks are an issue. A misbehaving program will crash your backend. One solution is to move caching off the database and into memory.
Clustered and HA db services:
Memory cache:
- Drupal redis
- Fewer backend connections- Twemproxy aka nutcracker (docs)