http://www.mysqlkorea.co.kr
Çѱ۸Ŵº¾ó 5.0 , Çѱ۸Ŵº¾ó 5.1 , MySQL 5.1 HA , »ç¿ëÀڸŴº¾ó
°øÁö»çÇ×  
´º½º  
Áú¹®°ú ´äº¯
DBA
Developer
Cluster
ÅäÅ©¹Ú½º  
À̺¥Æ®  
¼­Æ÷Æ® ƼÄÏ  
ÃֽűÛ
foreign key ¼³Á¤¡¦
ÀÎÅØ½º Ãß°¡ µî¿¡¡¦
mysql master - s¡¦
´Ù´ë´Ù °ü°è¿¡¼­ ¡¦
mysql myÆÄÀϰú ¡¦
 
Áú¹®°ú ´äº¯ (Cluster) > Ä¿¹Â´ÏƼ Á¸ > Áú¹®°ú ´äº¯ (Cluster)
[RE]MySQL Cluster¿¡ ´ëÇØ ¹®Àǵ帳´Ï´Ù~
±Û¾´ÀÌ : µÑµÑ   ³¯Â¥ : 10-11-08 12:03   Á¶È¸¼ö : 5127
´äº¯ °¨»çÇÕ´Ï´Ù~~
 
´äº¯ ÇØÁֽг»¿ë Áß¿¡
 
mgm ÀÌ ºñÁ¤»óÀϰæ¿ì¿¡´Â µ¥ÀÌÅÍ ½ÌÅ© ±úÁú¼öÀÖ½À´Ï´Ù
 
ÀÌ ºÎºÐ¿¡ ´ëÇØ¼­ MySQL Cluster¿¡¼­ ½ÌÅ©¸¦ ¸ÂÃß¾î ÁÖ´Â ±â´ÉÀ» Çϰí ÀÖ´ÂÁö ±Ã±ÝÇÕ´Ï´Ù~~
 
¶Ç ÇѰ¡Áö ±Ã±ÝÇÑ °ÍÀÌ ÀÖ½À´Ï´Ù~
 
Connected to Management Server at: x.x.x.x:1186
Cluster Configuration
---------------------
[ndbd(NDB)]     2 node(s)
id=2    @x.x.x.x  (mysql-5.1.47 ndb-7.1.8, Nodegroup: 0, Master)
id=3    @x.x.x.x  (mysql-5.1.47 ndb-7.1.8, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1    @x.x.x.x  (mysql-5.1.47 ndb-7.1.8)
[mysqld(API)]   2 node(s)
id=4    @x.x.x.x  (mysql-5.1.47 ndb-7.1.8)
id=5    @x.x.x.x  (mysql-5.1.47 ndb-7.1.8)
 
ÀÌ·± ±¸¼ºÀÎ °æ¿ì mysqld(API) ³ëµå¿¡¼­ select ¿äûÀ» ÇÏ°Ô µÇ¸é
 
ndb 2°³ÀÇ ³ëµå¿¡¼­ º´·Ä·Î query °á°ú¸¦ ¹Þ°Ô µÇ´ÂÁö, ¾Æ´Ï¸é ÇѰ³ÀÇ ndb ³ëµå¿¡¼­ ¿äû ó¸® ÈÄ
 
°á°ú¸¦ ¹Þ°Ô µÇ´ÂÁö ±Ã±ÝÇÕ´Ï´Ù~
¹ÎÁ·
ÀÌ°É ¼³¸íÇÏ·Á¸é Ŭ·¯½ºÅÍ ±¸Á¶¸¦ ´Ù ¼³¸íÇØ¾ßµÇ´Âµ¥..

mgm ÀÌ ÀÖ¾î¾ßÁö µ¥ÀÌÅÍÀÇ master ¿Í ¼¼ÄÁµå¸®¸¦ ¾Ë¼ö ÀÖ½À´Ï´Ù.

mysqld ¿¡¼­ select ÇϰԵǸé.. ÇѰ³ÀÇ NDB ¿¡¼­ ó¸®ÇÏ°Ô µË´Ï´Ù.
ÀÌÀü±Û Procedure »ý¼º ¹®Á¦ 
´ÙÀ½±Û MySQL Cluster¿¡ ´ëÇØ ¹®Àǵ帳´Ï´Ù~ 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.