Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
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? –  Felix Frank Jun 23 at 12:37

1 Answer 1

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.