469,927 Members | 1,549 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

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.
Aug 6 '06 #1
2 3854
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.
Aug 6 '06 #2
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.

Aug 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Tomer Ben-David | last post: by
3 posts views Thread by Shabam | last post: by
reply views Thread by mia456789 | last post: by
2 posts views Thread by CSN | last post: by
3 posts views Thread by warwick.poole | last post: by
11 posts views Thread by chmmr | last post: by
3 posts views Thread by dejavue82 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.