How to Set up a Load-Balanced MySQL Cluster

Linked by Thom Holwerda on Sun 23rd Apr 2006 14:41 UTC, submitted by Falko Timme

"This tutorial shows how to configure a MySQL 5 cluster with three nodes: two storage nodes and one management node. This cluster is load-balanced by a high-availability load balancer that in fact has two nodes that use the Ultra Monkey package which provides heartbeat (for checking if the other node is still alive) and ldirectord (to split up the requests to the nodes of the MySQL cluster)."

1 8 Comment(s)

Post a Comment

Thank you

by Joe User (0.88) on Sun 23rd Apr 2006 15:01 UTC

Member since:
2005-06-29
Fans: 1

I want more articles like that. A lot better than the neverending kde vs. gnome or linux vs. *bsd flame wars...

Reply Permalink Bookmark Score: 5

RE: Thank you

by Slapo (1.72) on Sun 23rd Apr 2006 20:16 UTC in reply to "Thank you"

Member since:
2005-07-06
Fans: 0

Just wait 'till someone starts ranting about other SQL database servers
Although I wish it didn't happen, one can't help it much :.

Reply Permalink Bookmark Score: 1

migration

by Babi Asu (0.56) on Sun 23rd Apr 2006 23:35 UTC

Member since:
2006-02-11
Fans: 1

Is it safe to migrate from 4.1 to 5.0? I need to use View.

Reply Permalink Bookmark Score: 1

RE: migration

by jondoor (2.16) on Mon 24th Apr 2006 03:11 UTC in reply to "migration"

Member since:
2005-06-30
Fans: 0

5.0.x is marked as production ready so it should be fine. I have read that 5.x performance can be lower then 4.1 if used without stored procedures, but I haven't run any benchmarks myself.

Reply Permalink Bookmark Score: 1

RE[2]: migration

by agentj (1.72) on Mon 24th Apr 2006 06:34 UTC in reply to "RE: migration"

Member since:
2005-08-19
Fans: 0

Instead of running benchmarks maybe it would be better to test it on real-world applications.

Reply Permalink Bookmark Score: 1

RE[3]: migration

by Babi Asu (0.56) on Mon 24th Apr 2006 07:55 UTC in reply to "RE: migration"

Member since:
2006-02-11
Fans: 1

The migration issue for me is not about performance, but about compatibility. I don't want the migration break many applications.

Reply Permalink Bookmark Score: 1

D.O.A

by what (1.48) on Mon 24th Apr 2006 06:22 UTC

Member since:
2006-01-04
Fans: 0

All data has to be stored on RAM !!
I won't start using it until MySQL can use shared disk storage and clustering file systems like GFS or OCFS2.
Too bad.

Edited 2006-04-24 06:23

Reply Permalink Bookmark Score: 2

Mysql Web interface tools List here

by david23 (2) on Tue 25th Apr 2006 16:19 UTC

Member since:
2006-04-25
Fans: 0

most of the users like to use web interface tools for mysql database http://www.debianhelp.co.uk/mysqlweb.htm

Edited 2006-04-25 16:20

Reply Permalink Bookmark Score: 1

OSNews