MySQL Cluster for PHP session data

Hi all,

My employer is in the planning phases of a High Availability upgrade
to our server infrastructure. Among other things, we've been taking a
look at MySQL Cluster.

Our primary database servers run MSSQL; the only thing we're currently
storing in MySQL is the PHP session data for our various web
applications. In order to meet the goals of the High Availability
project, we've decided that we no longer want to rely on a single
machine running mysqld. At first glance, MySQL Cluster seems perfect.

However, there are concerns in my department that the management node
in the cluster - the one running ndb_mgmd - would introduce a single
point of failure and negate the benefit of having the cluster. That
can't be correct, but thus far I've been unable to gather enough
information to explain why.

From the documentation and HOWTOs I've read, I understand that while
it is recommended to keep ndb_mgmd running at all times, it is only
_required_ to be running when the cluster's data nodes are started.
This makes me somewhat unclear as to the management node's role in
managing the cluster.

Suppose that the management node goes down (e.g. hardware failure) in
the middle of the night; what happens? How does the cluster retain
state information, stay synchronized, etc?

I am acting under the impression that ndb_mgmd is responsible for
ensuring that the various data nodes are kept synchronized, and for
routing queries from the SQL node to the appropriate data node. Am I
way off base?

Thanks!

--
(to email, remove .ape)
*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com ***

Re: MySQL Cluster for PHP session data

s wrote:
> Hi all,
>
> My employer is in the planning phases of a High Availability upgrade
> to our server infrastructure. Among other things, we've been taking a
> look at MySQL Cluster.

I think you will have a lot better chance of getting a good reply if you ask
your question at the official MySQL forum, where you have the developers who
can give you the proper answer.

Forum:
http://forums.mysql.com/

MySQL Cluster:
http://forums.mysql.com/list.php?25


//Aho

Re: MySQL Cluster for PHP session data

On Thu, 02 Mar 2006 08:36:39 +0100, "J.O. Aho"
wrote:

>I think you will have a lot better chance of getting a good reply if you ask
>your question at the official MySQL forum, where you have the developers who
>can give you the proper answer.
>
>Forum:
>http://forums.mysql.com/
>
>MySQL Cluster:
>http://forums.mysql.com/list.php?25

Thanks Aho, I have posted the question to the MySQL forums.


--
(to email, remove .ape)
Apologies for the ad below.
--

*** Free account sponsored by SecureIX.com ***
*** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com ***