Tutorial: Setting Up A Load-Balanced MySQL Cluster

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Threaded Mode | Linear Mode

Tutorial: Setting Up A Load-Balanced MySQL Cluster

04-24-2006, 07:30 AM,

Post: #1

mandy Offline

Administrator

Posts: 9,932
Likes Given: 0
Likes Received: 6 in 5 posts
Joined: Feb 2011
Reputation: 0

Tutorial: Setting Up A Load-Balanced MySQL Cluster

Quote:How To Set Up A Load-Balanced MySQL Cluster

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

In this document I use Debian Sarge for all nodes. Therefore the setup might differ a bit for other distributions. The MySQL version I use in this setup is 5.0.19. If you do not want to use MySQL 5, you can use MySQL 4.1 as well, although I haven't tested it...

full tutorial: http://www.howtoforge.com/loadbalanced_m...ter_debian

« Next Oldest | Next Newest »

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Using MySQL Tuner to Tune MySQL Performance	mandy	0	2,245	09-08-2008, 10:08 AM Last Post: mandy
	Sun Agrees to Acquire MySQL for $1 Billion	mandy	1	2,424	01-19-2008, 02:31 AM Last Post: regic
	Google to Contribute Code to MySQL 7.0	mandy	0	2,155	10-25-2007, 10:55 AM Last Post: mandy
	Backing up MySQL Data	mandy	0	2,281	05-30-2007, 10:34 AM Last Post: mandy
	Using OpenOffice to connect to MySQL and PostgreSQL Databases	mandy	0	2,166	05-07-2007, 09:23 AM Last Post: mandy
	Google Releases Improved MySQL Code	mandy	0	2,058	04-26-2007, 10:39 AM Last Post: mandy
	Database maker MySQL plans IPO as revenues top $50 million	mandy	0	2,282	04-26-2007, 08:19 AM Last Post: mandy
	Tips for Optimizing MySQL Queries	mandy	1	2,649	04-12-2007, 07:19 AM Last Post: misteroriginal
	Open Source Tools for Administering MySQL Databases	mandy	0	2,426	10-21-2006, 10:38 AM Last Post: mandy
	Using phpMyAdmin to manage your MySQL databases	mandy	0	2,263	08-11-2006, 12:01 PM Last Post: mandy

Forum Jump:

Users browsing this thread: 1 Guest(s)