473,569 Members | 2,612 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4042
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.co mwrote 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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1075
by: Tomer Ben-David | last post by:
Hi Is mysql 4.1.x already ships with clustering capabilities? Do I need to build it up from source? or do the binaries already contain it ? Thanks Tomer
3
5155
by: Shabam | last post by:
When a web application becomes overloaded with traffic, one can offload it by load balancing and clustering the front end web servers. What happens when the back-end MSSQL database becomes overloaded? Does MYSQL offer load balancing and clustering?
1
2152
by: willie | last post by:
Hi all: I have a clustering SQL Server on Node1 and Node2, the Node1 has named Instance1 and Node2 has named Instance2, no default instance. We tested it that everthing is OK, then we decide to move to DR location. The relocation kept the same virtual and phusical server name, and we did not change SQL Server server network utility. But...
0
974
by: mia456789 | last post by:
I want to test the mysql clustering , do I need to donwload some rpm / package to setup it ? is it included in the mysql server ? thx
2
1972
by: CSN | last post by:
Just wondering - is there something similar to this (clustering) for PostgreSQL? If so, how does it compare? http://www.mysql.com/press/release_2003_30.html __________________________________ Do you Yahoo!?
3
8678
by: warwick.poole | last post by:
I am interested in finding out about Enterprise scale Postgres installations and clustering, especially on Linux. Essentially I would like to know the possibility that Postgres can store the database data in a central location (ex: on a SAN fiber array) and have a cluster of machines sharing processor/RAM/IO bandwidth to do the application...
2
2778
by: Jim Worke | last post by:
Hi list, My boss would like to convert from MySQL to PostgreSQL, but there are a few things that hold us back. We'd like to have the databases in several physical servers, with referential integrity between the tables. Reading from Oracle articles, their referential integrity can be done using their dblink and triggers. What I'd like...
11
730
by: chmmr | last post by:
Hi, I am currently in the process of gathering info/experiences for an incoming Linux DB2 clustering phase we actually know nothing about (since we are doing it for the first time ever), so I would really appreciate if you could share some of your experience here or recommend some additional websites/literature aside from IBM Developerworks...
3
1935
by: dejavue82 | last post by:
Hi, Does anybody know of a software package that allows for several servers, running asp.net 2.0 to be clustered, regardless of where they are located (ie. without a hardware load balancer). This way one could link two or more dedicated servers, perhaps even running on different hosts. Does something like this exist? Thank you for your...
0
7625
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8144
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7692
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6313
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5244
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3677
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3666
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2128
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
969
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.