Probably consistency is not a huge issue for non-core databases; HA is more important. It can also serve as a production test for a future HA solution for mediawiki (T119626)
3 main problems:
- Automatic proxy failover, dbproxy1* (several options)
- How to handle long-running connections from many services
- Do we want to flip the read_only automatically? how?