Clustering mySQL

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.

Re: Clustering mySQL

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/en/mysql-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.

Re: Clustering mySQL

Thanks for your help, I will follow your instructions.

"Bill Karwin" wrote in message
news:eb5do50rl7@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/en/mysql-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.