MySQL data distribution across nodes

[martijnHoekstra]

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?

[falko]

In a MySQL cluster, the data is always on all cluster nodes.

[sysconfig]

From MySQL.com

Data node: Stores and replicates data. Data node functionality is handled by an instance of the NDB data node process ndbd.

SQL node: This is simply an instance of MySQL Server (mysqld) that is built with support for the NDB Cluster storage engine and started with the --ndb-cluster option to enable the engine.

Management node (MGM node): Provides management services for the cluster as a whole, including startup, shutdown, backups, and configuration data for the other nodes. The management node server is implemented as the application ndb_mgmd; the management client used to control MySQL Cluster via the MGM node is ndb_mgm.

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.