Click here to get back home

Clustering mySQL
 Home | NewsGroups | Search | About
Login Password
Register Now! Lost Password?
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
Clustering mySQL Lion 08-06-2006
Get Chitika Premium
Posted by Lion on August 6, 2006, 4:16 am
Please log in for more thread options
 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.



Posted by Bill Karwin on August 6, 2006, 2:52 pm
Please log in for more thread options
 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.

Posted by Lion on August 6, 2006, 5:46 pm
Please log in for more thread options
Thanks for your help, I will follow your instructions.

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



Similar ThreadsPosted
Distributed MySQL Clustering/Replication February 14, 2006, 2:09 pm
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' January 12, 2006, 9:26 pm
Problem with accent Import to MySQL/Linux from MySQL Windows September 4, 2005, 1:54 am
MySQL variables, modifying Microsoft SQL sequence insert for use in mysql October 7, 2005, 10:54 am
I want to make transfer data between MySQL Server to MySQL Local . February 9, 2006, 1:25 am
restoring a 4.0.17 mysql server without a mysql dump file July 20, 2005, 12:12 pm
slow mysql "sending data" stage between mysql and php November 29, 2006, 12:23 pm
How to detect if a MySQL db table exists in MySQL 4.1+ March 16, 2006, 3:49 pm
Different results in mysql & mysql query browser? April 18, 2006, 9:05 am
Simple MySQL Search from MySQL beginner June 27, 2006, 6:51 am

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap