Original use cases are in https://github.com/ManageIQ/manageiq/issues/42
Another use case is automatic database maintenance (e.g., re-indexing) without need for a DBA. A mirrored database can be taken offline for automated maintenance and then brought back online. This can be done round-robin with all the database instances participating in the mirroring.
Let’s use this forum to discuss the approach and come up with a design that we can implement.