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)
mysql Ŭ·¯½ºÅÍ ±¸¼ºÁß¿¡ ´Ù¸¥¼­¹ö¿¡¼­ API Á¢¼ÓÀ̾ȵǰí ÀÕ½À´Ï´Ù. ¤Ì.¤Ì
±Û¾´ÀÌ : ¹ÎÄɺñÄ¡   ³¯Â¥ : 13-04-03 11:38   Á¶È¸¼ö : 5894
ÇнÀ Â÷¿ø¿¡¼­ °¡»ó¼­¹ö µÎ´ë·Î ±¸¼ºÀ» ÇØº¸°í ÀÖ½À´Ï´Ù. (½ÇÁ¦¼­ºñ½º¿¡¼­´Â 2°³·Î ´Â ¾ÈÇØ¿ä^^) 
µÎ ¼­¹ö´Ù ¹°¸®Àû ¸Þ¸ð¸®°¡ 512 MB ÀÔ´Ï´Ù. 
A ¼­¹ö : MGM, NDB, MYSQL ±¸¼º 
B ¼­¹ö : MYSQL ±¸¼º 

ÀÏ´Ü MYSQL ¸¸ ÀÌÁßÈ­·Î ±¸¼ºÇغ¸·Á°í Çϴµ¥¿ä. 

¿¡·¯»çÇ×. 
A¼­¹ö¿¡¼­ MGM, NDB, MYSQL ±¸¼ºÀº ÀÌ»ó¾øÀÌ Àߵ˴ϴÙ. 
B¼­¹ö¿¡¼­ MYSQL Á¢¼ÓÇϸé NDB µ¥ÀÌÅ͸¦ ¿¬°áÇÏÁö ¸øÇÕ´Ï´Ù. 

MGM ·Î±× (¿¡·¯) 
2013-04-03 04:52:39 [MgmtSrvr] INFO    -- Node 5: mysqld --server-id=5 
2013-04-03 04:52:59 [MgmtSrvr] WARNING  -- Node 2: Releasing node id allocation for node 5 

B ¼­¹öÀÇ MYSQL ·Î±× 
Version: '5.5.27-ndb-7.2.8'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source distribution 
130403  4:53:39 [Warning] NDB : Tables not available after 30 seconds.  Consider increasing --ndb-wait-setup value 


########## A¼­¹ö config.ini ############ 
[NDBD DEFAULT] 
NoOfReplicas: 1 

# Data Memory, Index Memory, and String Memory 

DataMemory: 200M 
IndexMemory: 68M 
BackupMemory: 32M 

[MGM DEFAULT] 
PortNumber: 1186 

[NDB_MGMD] 
NodeId: 1 
HostName: 27.102.204.154 
ArbitrationRank: 1 
datadir=/MYSQL/MGM 

[NDBD] 
NodeId: 2 
HostName: 27.102.204.154 
datadir=/MYSQL/NDB 


# 
# Note: The following can be MySQLD connections or 
#      NDB API application connecting to the cluster 
# 

[API] 
NodeId: 5 
HostName: 27.102.204.155 
ArbitrationRank: 2 

[API] 
NodeId: 6 
HostName: 27.102.204.154 

########## B¼­¹ö my.cnf ############ 
[mysql_cluster] 
ndb-connectstring = 27.102.204.154 

[mysqld] 
ndbcluster 
ndb-nodeid=5 
server-id=5 
ndb-connectstring = 27.102.204.154 
port            = 3306 
socket          = /var/lib/mysql/mysql.sock 
skip-external-locking 
key_buffer_size = 16K 
max_allowed_packet = 1M 
table_open_cache = 4 
sort_buffer_size = 64K 
read_buffer_size = 256K 
read_rnd_buffer_size = 256K 
net_buffer_length = 2K 
thread_stack = 128K 

[mysqldump] 
quick 
max_allowed_packet = 16M 

[mysql] 
no-auto-rehash 
# Remove the next comment character if you are not familiar with SQL 
#safe-updates 

[myisamchk] 
key_buffer_size = 8M 
sort_buffer_size = 8M 

[mysqlhotcopy] 
interactive-timeout 


A¼­¹ö ¸Þ¸ð¸® ÇöȲ 
            total      used      free    shared    buffers    cached 
Mem:        509664    503472      6192          0      43968      29804 
-/+ buffers/cache:    429700      79964
ÀÌÀü±Û alter online ±¸¹® Áú¹®Á» µå¸±°Ô¿ä 
´ÙÀ½±Û primary Ű °ü·Ã Á¶È¸ ½Ã µ¥ÀÌÅͰ¡ ´©¶ôµÇ¾î Á¶È¸µË´Ï´Ù. 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.