Re: Cluster replication, sql node stops if rep master stopped

[Jonathan Stephens]

> I have a cluster with 2 sql nodes. One node (SQL1) is a replication master, and
> there is a replication slave outside the cluster.

Then you have only one SQL node, not two. An SQL node is a MySQL server participating in a Cluster. SQL2 is not participating in the cluster; therefore, it's a MySQL server, but not a Cluster SQL node.

Just add another SQL node to the cluster (e.g. SQL3). Then if SQL1 goes down, you still have access to Cluster data using SQL3.

Also, have you read the Cluster Replication material in the MySQL Manual?

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication.html

In particular you may find this section to be of interest:

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-failover.html

See also the Cluster replication Known Issues section (especially the first item):

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-replication-issues.html

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle