MySQL vs MS SQL Server clustering

[Robert Castleman]

I've reviewed the custering whitepaper for MySQL and I need to be able to compare it to Microsoft. So I have a few questions.

It looks like the MySQL model puts all the data on a SAN and uses each database node to access it transparantly. This seems to imply that an end user can get access to the data through any server node. This is different from MS in that for SQL Server database access must always happen through the same server instance. So for any database, all connections must go through the same server. The MySQL model seems better since you can load balance connections across multiple servers. Also because of this architecture, with MySQL, all nodes in the cluster can be active, whereas in MS, you need to keep a node in reserve to fail over to in case of a problem.

Is all this correct or am I mistaken?

Also, what is the maximum number of nodes allowed in a MySQL cluster?

Thanks,

Bob Castleman
SuccessWare Software

Robert Castleman
SuccessWare Software



Edited 1 time(s). Last edit at 01/03/2006 10:50AM by Robert Castleman.