Clustering mySQL

[Lion]

Hi All,

I'm new to mySQL. Is it possible to cluster mySQL on a Windows 2003
cluster. I need to create HI reliability mySQL database that IIS connects
to , so I created Windows 2003 Cluster with clustered IIS but I'm now stuck
on how to cluster mySQL. If clustering is not an option can I install mySQL
on both nodes and have data base on the shared drive then use script to
determine which node is active and connect to database file.

Please help.
Lion.

[Bill Karwin]

Lion wrote:

Hi All,

I'm new to mySQL. Is it possible to cluster mySQL on a Windows 2003
cluster.

I have no experience with Windows 2003 Cluster, but MySQL has its own
clustering solution for high availability and scalability. I don't have
any experience with it, so all I can do is point you to the docs:
http://dev.mysql.com/doc/refman/5.0/...l-cluster.html

Be sure to download the latest MySQL 5.0.24, which just came out a
couple of days ago. The change logs suggest it includes many minor
bugfixes related to clustering.

If clustering is not an option can I install mySQL
on both nodes and have data base on the shared drive then use script to
determine which node is active and connect to database file.

No, don't do that. Always make MySQL read its data from local files.

Regards,
Bill K.

[Lion]

Thanks for your help, I will follow your instructions.

"Bill Karwin" <bi**@karwin.comwrote in message
news:eb********@enews4.newsguy.com...

Lion wrote:

>Hi All,

I'm new to mySQL. Is it possible to cluster mySQL on a Windows 2003
cluster.

I have no experience with Windows 2003 Cluster, but MySQL has its own
clustering solution for high availability and scalability. I don't have
any experience with it, so all I can do is point you to the docs:
http://dev.mysql.com/doc/refman/5.0/...l-cluster.html

Be sure to download the latest MySQL 5.0.24, which just came out a couple
of days ago. The change logs suggest it includes many minor bugfixes
related to clustering.

>If clustering is not an option can I install mySQL on both nodes and have
data base on the shared drive then use script to determine which node is
active and connect to database file.

No, don't do that. Always make MySQL read its data from local files.

Regards,
Bill K.