When we explore strategies to scale our MySQL-based database
layer, we realize that there are many different options. As
opposed to proprietary solutions, open-source products nourish
themselves from their communities and novel architectures or
enhanced versions are generated, often incorporating other open
source technologies. MySQL is not an exception.
Other players build completely different engines aiming to
mitigate some of MySQL well-known weaknesses, but still support
its wire protocol, with the challenge of sacrificing as little
compatibility as possible.
In this white paper, we briefly discuss the scale-up
vs scale-out dilemma, to then review the different scale-out
strategies. We are also going to go over some of the most common
MySQL architectures and products with horizontal scaling in mind.
Finally, we will share some guidelines to …[Read more]