MySQL data distribution across nodes

Discussion in 'HOWTO-Related Questions' started by martijnHoekstra, Oct 29, 2006.

  1. martijnHoekstra

    martijnHoekstra New Member

    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?
  2. falko

    falko Super Moderator ISPConfig Developer

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

    sysconfig New Member

    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.

Share This Page