MySQL ClusterÅäÖÃstep by step
MySQL ClusterÅäÖÃstep by step
À´Ô´£ºhttp://space.itpub.net/15415488/viewspace-620903
¹«Ë¾ÓиöÏîÄ¿ÊDzâÊÔdistributed DB£¬ÆäÖÐÒ»ÏîÊÇÕë¶ÔMySQL ClusterµÄ²âÊÔ¡£
ÓÚÊÇ»¨ÁËÁ½Ììʱ¼ä×°»úÆ÷ºÍÅäÖÃMySQL Cluster¡£Õû¸ö¹ý³Ì»¹ÊDZȽÏ˳ÀûµÄ£¬µ±È»Èç¹û¶ÔMySQL³£ÓÃÃüÁî±È½ÏÊìϤµÄ»°»á¸ü˳Àû¡£
ÁôÏÂstep by stepÅäÖ÷½°¸£¬ÒÔ·ÀÍü¼Ç¡£
MySQL ClusterÊÇÒ»ÖÖshare nothingµÄ»úÖÆ£¬¸úOracleµÄRACÐèÒª¹²Ïí´æ´¢·½°¸ÊDz»Ò»ÑùµÄ¡£
Ëû°üº¬ÈýÖֽڵ㣨node£©£º
Data node£ºÓÃÀ´´æ·ÅÊý¾ÝµÄ½Úµã£¬Êý¾ÝÀàÐÍÊÇNDB Cluster£¬·ÅÔڸýڵãµÄÄÚ´æÀï¡£
SQL node£ºmysql·þÎñÆ÷/¿Í»§¶Ë½Úµã¡£
MGM node£º¹ÜÀí½Úµã£¬×ݹÛÈ«¾ÖµÄÒ»¸öÅäÖýڵ㡣
ËùνµÄ½Úµã£¬ÆäʵҲ¾ÍÊÇÏàÓ¦µÄ½ø³Ì¶øÒÑ£¬ËùÒÔÎÒÃÇ¿ÉÒÔ½«²»Í¬½Úµã·ÅÔÚͬһ¸ö»úÆ÷ÉÏ¡£ËùÒÔÀíÂÛÉÏ£¬ÎÒÃÇÖ»ÐèҪһ̨ÎïÀí»úÆ÷¾Í¿ÉÒÔÍæMySQL ClusterÁË¡£
ÉÔ΢Á˽âÁËÒ»µãÀíÂÛ֪ʶ£¬¾Í¿ÉÒÔÇáËÉÅäÖúÃÒ»¸öCluster»·¾³£¬µ«ÆäËû֪ʶÐèÒªÔÚÒÔºóµÄÔËάºÍ²âÊÔ¹ý³ÌÖÐ×Ô¼º·¢¾ò¡£MySQLÒ²ÊÇÒ»¸öºÜÅÓ´óµÄ֪ʶÌåϵ£¬²»Ñ·ÓÚOracle¡£
½ÓÏÂÀ´Step by Step½²½âÈçºÎÅäÖÃMySQL Cluster£¬¼´Ê¹ÄãÖ»ÓÐ0»ù´¡£¬ÏàÐÅÒ²Äܹ»ºÜÇáËɵÄÅäÖá£
1. ×¼±¸Ó²¼þ×ÊÔ´
ÎÒÄõ½ÁËËĄ̈ÆÕͨPC»ú×÷Ϊ²âÊÔ»ú£¬²¢È«²¿×°ºÃRedHat EL5²Ù×÷ϵͳ¡£
ËĄ̈»úÆ÷È«²¿Í¨¹ýDHCP»ñµÃ4¸öÍⲿIPµØÖ·¡£µ«ÎªÁ˽ڵãÖ®¼äÄÚ²¿Îȶ¨£¬ÓÖ¸øÿ̨»úÆ÷É趨ÁËÒ»¸ö×ÓÍø¾²Ì¬IPµØÖ·£¬½ÚµãÖ®¼äµÄͨОͿÉÒÔͨ¹ýÕâ¸ö¾²Ì¬µØÖ·ÁªÏµÁË¡£
ÕâËĄ̈»úÆ÷hostnameÈ¡ÃûΪmysql1/2/3/4£¬¾²Ì¬µØַΪ£º
mysql1
192.168.123.1
mysql2
192.168.123.2
mysql3
192.168.123.3
mysql4
192.168.123.4
2. ²¿Êð½Úµã
ÎÒÃDzÉÓÃ1¸öMGM node£¬2¸öSQL node£¬2¸ödata nodeµÄ·Ö²¼·½Ê½¡£
ÆäÖÐÓÉÓÚ×ÊÔ´ÏÞÖÆ£¬MGM nodeºÍÒ»¸öSQL node²¿ÊðÔÚͬһ̨»úÆ÷ÉÏ¡£
²¿ÊðÈçÏ£º
½ÚµãÀàÐÍ
ËùÔÚÎïÀí»úÆ÷
MGM node
mysql4
SQL node 1
mysql3
SQL node 2
mysql4
Data node 1
mysql1
Data node 2
mysql2
3. °²×°MySQLÈí¼þ
ÔÚËùÓнڵãÉÏ°²×°mysql-5.0.88-linux-i686-icc-glibc23.tar.gz
ÏÂÔصØÖ·£º
http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.88-l
Ïà¹ØÎĵµ£º
MySQL Cluster
is a technology that enables
clustering of in-memory databases in a shared-nothing system. The
shared-nothing architecture allows the system to work with very
inexpensive hardware, and with a minimum of specific requirements
for hardware or software.
......
NDBCLUSTER
(also known as NDB
) is an in-memory
storage engine offering high-availability and data-persistence
features.
The NDBCLUSTER
storage engine can be
configured with a range of failover and load-balancing options,
but it is easiest t ......
½ñÔçÊÕµ½ÁËMySQLµÄÓʼþ£¬È«ÎÄÈçÏ£º
Ç×°®µÄÕü¾ÈMySQLµÄÖйúÇ©ÃûÖ§³ÖÕߣ¬
Å·ÃË¿ÉÄÜÎÞ·¨Õü¾ÈMySQL,ÖйúºÍ¶íÂÞ˹¿ÉÄÜÊÇÕü¾ÈMySQLµÄÏ£ÍûÖ®ËùÔÚ¡£ÖйúÓµÓÐÇ¿´ó¡¢¶ÀÁ¢ÒÔ¼°×ÔÐŵķ´Â¢¶ÏÖ÷¹Ü»ú¹Ø£¬Òò´Ë£¬ÎÒ±¾ÈËÔÚ´ËÇëÇóÄúµÄ°ïÖú¡£¶ÔÓÚÄúÔÚhttp://www.helpmysql.org/ru/petitionµÄÇ©Ãû£¬ÎÒÃÇÉî±í¸Ðл¡£Èç¹û¿ÉÒԵĻ°£¬ÎÒÃÇÐèÒªÄúµ ......
http://dev.mysql.com/doc/refman/5.1/zh/index.html
(MySql 5.1 ÖÐÎIJο¼ÊÖ²á)
*------------------------------------------------------------------------------------------
show databases; ÏÔʾÊý¾Ý¿â
drop database Êý¾Ý¿âÃû;ɾ³ýÊý¾Ý¿â
set names 'utf8';ÉèÖÃÊý¾Ý¿â±àÂëΪutf-8
source x:\Êý¾Ý¿âÃû.sql;µ¼È ......
To support MySQL Cluster, you will need to update
my.cnf
as shown in the following example.
You may also specify these parameters on the command line when
invoking the executables.
Note
The options shown here should not be confused with thos ......