Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 29th October 2006, 19:26
martijnHoekstra martijnHoekstra is offline
Junior Member
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Question MySQL data distribution across nodes

There is a very good how-to on a load balancing HA MySQL Cluster system, but nothing on how to devide a database across multiple nodes. I have a total of 6 low-end machines on a lan, And I want to build a load balancing sytem with four machines running data, and the other two running all other tasks.
How do I cluster the data, and how do I let my management node know what runs where?
Reply With Quote
Sponsored Links
Old 30th October 2006, 15:18
falko falko is offline
Super Moderator
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,749 Times in 2,579 Posts

In a MySQL cluster, the data is always on all cluster nodes.
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Old 8th November 2006, 08:35
sysconfig sysconfig is offline
Junior Member
Join Date: Nov 2006
Location: (.)
Posts: 20
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to sysconfig

From MySQL.com
Data node: Stores and replicates data. Data node functionality is handled by an instance of the NDB data node process ndbd.

SQL node: This is simply an instance of MySQL Server (mysqld) that is built with support for the NDB Cluster storage engine and started with the --ndb-cluster option to enable the engine.

Management node (MGM node): Provides management services for the cluster as a whole, including startup, shutdown, backups, and configuration data for the other nodes. The management node server is implemented as the application ndb_mgmd; the management client used to control MySQL Cluster via the MGM node is ndb_mgm.
A MySQL Cluster has both a physical and logical organization or data. If you want to your database tables in clustered environment you need to add ENGINE=NDBCLUSTER; at the last of create table syntax.
Linux Web Administrator
Optimize, secure and performance tunning for Apache || MySQL5.1 Cluster How To
The visionary conceives the impossible, The missionary makes it possible. ...Gita.
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 18:37
activate load data local on mySQL with ISP config tgip Installation/Configuration 7 28th September 2006 17:04
import mysql data - specifiy charset adam Installation/Configuration 1 17th September 2006 00:30
MySQL Data Base cybereatl Installation/Configuration 1 15th February 2006 19:51
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04

All times are GMT +2. The time now is 09:48.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.