0

I'd like to set up a MySQL Cluster for HA, but the client of the data cannot yet use ClusterJ.

I would like create 2 SQL Nodes and access only them from the client. i.e. No access to the NDB Data nodes.

Is this a valid configuration? Can I connect with either SQL node for reading and writing and assume that data is in sync?

1
  • The tags mysql-replication and mysql-cluster don't seem to agree. Are you using an NDB cluster or are you using MySQL servers using InnoDB or MyISAM and replication for HA? Jun 23, 2014 at 12:37

1 Answer 1

0

Yes you can. When you are writing/reading data through the SQL Nodes, they are actually written-to/read-from the data nodes in the cluster, to which these SQL nodes are connected to. You can use a normal Connector/J instead of Cluster/J to achieve this and it is completely valid.
For a better understanding of how the whole cluster works check this link : http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-overview.html

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .