At the moment, any host going down won't page, they will just send an IRC alert.
While this might be ok for the rest of the infra, if a primary database master goes down, that means that all the wikis on it will automatically go on read-only (apart from replication getting broken on the slaves).
In some cases, replication broken alerts can take up to 15 minutes to actually send an SMS - we should page for a master going down at it needs immediate action.
We should also discuss whether we want ALL databases to page if going down
Related incident: https://wikitech.wikimedia.org/wiki/Incident_documentation/2019-09-23_s3_primary_db_master_crash