Five 9s or 99.999% availability is a popular term describing the level service up-time in a year; 5 9s is the highest practical level of availability for most organizations. It’s very hard to achieve five 9s with legacy MySQL, and doing so has required plenty of manual intervention and hand-holding. But Schooner’s approach and its replication flexibility bring 5 9s to any datacenter than needs it, with no hassle.
We published a white paper called “Achieving Five 9s with SchoonerSQL”. This paper describes the architecture of SchoonerSQL™, a full HA build of MySQL and its standard InnoDB storage engine. This paper then explains how to use the flexible synchronous and asynchronous replication modes in SchoonerSQL to get five nines availability. The paper then describes the recommended HA hardware setup for using SchoonerSQL.
You can download the white paper from:
https://www.schoonerinfotech.com/resources/white_papers
