Hi All,

I am currently trying to setup the following system.

There are two sites, each with a MySQL cluster and two way replication to handle the communication between sites (data consistency handled by another service). Each cluster currently contains two machines each with an ndb storage node and a MySQL daemon, both running with no problems. The two way replication has been setup with one machine within each cluster being the designated master / slave for the other site.

The problem lies that if an SQL insert occurs on the non designated master / slave machine it is populated throughout the cluster but not replicated to the other site. I am presuming as it was not passed through the designated master/slave MySQL daemon.

I realise that replication throughout clusters is on the roadmap for MySQL 5.1 is replication between clusters however has anyone thought of an interim solution for the above scenario.

Cheers

mat