In MySQL Cluster tables are spread among all nodes by default.
It is possible to specify a table to only reside on a subset of
the node groups by either setting the number of partitions or
by setting PARTITION_BALANCE (in 7.5). It is not intended to use
this for geographic replication.
It is not possible to specify exactly on which node group these
partitions will reside (at least I don't think, there was some
work in 5.1 to provide NODEGROUP when creating partitions, but
this is not fully supported, so a bit unsure what works here and
For geographic replication MySQL Cluster supports replication from
one cluster to another cluster. This is using MySQL Replication and
can thus be done selective for certain tables. It is possible to
replicate different tables to different clusters by using multiple
MySQL replication servers inside one MySQL Cluster.