Clustering mySQL

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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.


Re: Clustering mySQL

Lion wrote:
Quoted text here. Click to load it

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:

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.

Quoted text here. Click to load it

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

Bill K.

Re: Clustering mySQL

Thanks for your help, I will follow your instructions.

Quoted text here. Click to load it

Site Timeline