There is a very good how-to on a load balancing HA MySQL Cluster system, but nothing on how to devide a database across multiple nodes. I have a total of 6 low-end machines on a lan, And I want to build a load balancing sytem with four machines running data, and the other two running all other tasks. How do I cluster the data, and how do I let my management node know what runs where?
From MySQL.com A MySQL Cluster has both a physical and logical organization or data. If you want to your database tables in clustered environment you need to add ENGINE=NDBCLUSTER; at the last of create table syntax.
