MySQL clustering

**brian.mark** · #1 (**permalink**) 11-05-2005, 11:32 PM

Has anyone had any experience with clustering MySQL servers? We're looking into some blade servers for redundancy on the web server side of things, but how would I go about doing the same thing for the database without having syncronization issues?

I noticed that MySQL 5.0 has added this statement: "Reduced hardware costs by incrementally adding several low-cost commodity systems vs. upgrading high-cost mainframe-class systems". I haven't read a whole lot on 5.0, but that makes it sound like I should look into it a little deeper.

Anyone tried this with the 4 line? Downtime is getting to be pretty costly for us, so I need to start looking at something with a safety net. Any suggestions would be appreciated.

Brian.

kgun · #2 (**permalink**) 11-29-2005, 12:57 AM

http://www.sitepoint.com/forums/forumdisplay.php?f=182

E.g. in this
http://www.sitepoint.com/forums/showthread.php?t=313377 post?

Longneck that post there may be the right person to contact. Is the links he give to the http://dev.mysql.com site of any relevance?

**brian.mark** · #3 (**permalink**) 11-29-2005, 01:08 AM

That's all performance tuning. What I am looking for is clustered servers so that one crashing / rebooting / whatever doesn't take the web site down. I suppose clustering isn't the correct term, but it's related.

Redundancy is what I'm after more than performance. Our Quad processor machine is more than enough hardware wise, 4 GB of RAM is overkill for a simple database, but downtime is still a killer when I need to reboot for security updates / etc.

Brian.

kgun · #4 (**permalink**) 11-29-2005, 01:18 AM

clustering, redundancy and load balancing (Raidxx)?

Zeus is a scalable, secure, and high performance web server. What makes Zeus so popular is that it uses a small number of single-threaded I/O processes, wich are capable of handling tens of thousands of simultaneous connections.

In that respect, Zeus may be better than the front-runner Apache.

**brian.mark** · #5 (**permalink**) 11-29-2005, 01:22 AM

We're running RAID. However, if I have to reboot that machine, I have no database to query. That's the type of redundancy I need.

Speed is not the concern - stability is the goal here.

Brian.

kgun · #6 (**permalink**) 11-29-2005, 01:26 AM

the Zeus web server.

**brian.mark** · #7 (**permalink**) 11-29-2005, 01:32 AM

Apache is handled... BigIP takes care of that. I'm asking about database servers here, not http servers. We're talking apples and oranges here.

Brian.

kgun · #8 (**permalink**) 11-29-2005, 01:36 AM

"But to handle the kind of I/O processing that Zeus offers you need either very fast equipment or a good cluster of servers. Fortunately, Zeus comes native with web server clustering support enabling a set of web servers to act as a single web server for the end user and allowing the load of serving web pages to be balanced across a set of different computers and (assuming your website has the bandwith) multiple connections."
Source: Janice Reynolds. "The complete E-Commerce book" page 117.

kgun · #9 (**permalink**) 11-29-2005, 01:41 AM

and you shall use MySQL? Then go to the http://www.mysql.com/ site or a MySQL forum and ask is my last proposal.

If you have money, is there a better (more secure / stable) database server than Oracle?

**brian.mark** · #10 (**permalink**) 11-29-2005, 01:44 AM

So, how do I query a Zeus server to get a set of results? I don't. It's a http server, not a database server. BigIP and Apache works fine for me. I'm talking about databases and you're telling me to dump apache. Ugh.

If my car has a flat, does it matter what engine is in it?

Quote:

Originally Posted by kgun

and you shall use MySQL? Then go to the http://www.mysql.com/ site or a MySQL forum and ask is my last proposal.

I believe I asked this in the "Database discussion forum". That sounds like it's got to be at least partially MySQL.

Brian.