Add failover capability

[altmannmarcelo]

Description

When a primary database goes does, one of the secondaries will take over and be promoted to the primary.

Readyset should be able to adjust to the new primary, by changing the url string it is connected to and also allow for pointing to the new Binary Log File and Position (MySQL) or WAL (PostgreSQL).

Change in user-visible behavior

Requires documentation change