I would say you did misunderstand the features...
the cluster is itself a seperate storange engine than the mysql server you connect to. so,
to the clients, you are only connecting to a mysql server, which then connects to the
cluster. so the cluster will be a single database to the clients, and it also
automatically handles interaction with the mysql server you set up as an API of the
cluster. which is another benefit...
you may specify any number (up to hundreds, I believe) of API nodes, which are typical
mysql servers configured to use the cluster as their storage engine rather than their
typical data files. in this way, you can have multiple mysql servers accepting
connections and processing queries and all will have the same data. so you may
round-robin or use some other method to balance your client connections to these servers
and not worry about data consistency - it is handled by the cluster storage engine.
the mysql APIs will spread THEIR requests to the cluster over all the nodes, since the
data is segmented and stored on the different nodes, which is a little built-in,
I hope that answers some of your doubts...but Mikael can probably explain much better than
> -----Original Message-----
> From: Roberto Melo Cavalcante [mailto:zerok@stripped]
> Sent: Tuesday, August 24, 2004 10:40 AM
> To: cluster@stripped
> Subject: Doubts about cluster features
> Hi everybody,
> I'm new in this list and never used mysql on a production
> Currently I'm an oracle database adminstrator that works for
> a brazilian
> government institution who seeks to get rid of it.
> I read part of the documentation available for MySQL Cluster
> but I still
> didn't know if it is possible make the database nodes to respond
> requests as a single datababe and if is there any kind of
> load balance
> mechanism that sends a given request to a less overload database node.
> I also searched on the archives of this list from august and july. I
> guess I misunderstood its features, if so, please be patient.
> Roberto Melo Cavlacante
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe: