You have heard about MySQL Cluster, but you were always afraid to get into it because ?Cluster? seems to be a magic and complicated topic? Then this article is for you. In a couple of minutes, you can run your own Cluster.
Sometimes, I need to demonstrate how MySQL cluster works. I usually set up a single machine cluster which of course won?t make sense in production scenarios, but for an introduction into MySQL cluster it?s fine. And it?s very easy to deploy the system on multiple machines later.
This article will show you how you can set up your own Cluster. All you need is a UNIX machine and the mysql-max package (version 4.1 or 5.0) which is downloadable from the MySQL website.
Run ?SHOW ENGINES? to see that the cluster storage engine is included in your installation. If it says ?DISABLED? or ?YES? …
[Read more]