High Availability is one of the hottest topics for MySQL DBAs. As
a matter of fact, when we (SkySQL) are called by users and customers, the top
two questions for our PS team are:
- How can I make my MySQL database scalable?
- How can I make my MySQL database highly available
Since MySQL is the most used online database, these two questions
are totally appropriate. Although the two concepts walk together,
they should not be confused.
We refer to scalability when we define that a system must sustain
a specific workload, measured in different ways – response time,
latency, transactions or operations per second to name few, or a
combination of them. So, we define the level of scalability we
want to achieve and we design a system that can scale to that
level.
We refer to high availability when we define that a system must
be available, within …
[Read more]