MySQL clustering

[brian.mark]

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]

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]

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]

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]

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]

the Zeus web server.

[brian.mark]

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]

"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]

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]

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?

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.