This article contains my notes and detailed instructions on
setting up a MySQL cluster. After reading it, you should have a
good understanding of what a MySQL cluster is capable of, how and
why it works, and how to set one of these bad boys up. Note that
I'm primarily a developer, with an interest in systems
administration but I think that every developer should be able to
understand and set up a MySQL cluster, at least to make the dev
environment more robust.
Notes
In short, a MySQL cluster allows a user to set up a MySQL
database shared between a number of machines. Here are some
benefits:
- High availability. If one or some of the machines go down,
the cluster will stay up, as long as there is at least one copy
of all data still present. The more redundant copies of data
there are, the more machines you can afford to lose.
- Scalability. Distributed architecture allows for load
balancing. If your MySQL …
[Read more]