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 Cluster Å×½ºÆ®Áß¿¡ ºÒ±ÔÄ¢ÀûÀ¸·Î µ¥ÀÌÅͳëµå¿¡ ¹®Á¦°¡ ¹ß»ýÇÕ´Ï´Ù.
±Û¾´ÀÌ : Á¤Èñ¼º   ³¯Â¥ : 10-07-21 16:20   Á¶È¸¼ö : 7591
1. µ¥ÀÌÅÍ ³ëµå°¡ ¸ðµÎ µ¿½Ã¿¡ ³»·Á°¡´Â ¹®Á¦ÀÖ½À´Ï´Ù.
2. µ¥ÀÌÅÍ ³ëµå°¡ 1°³ ³»·Á°¡¸é ÀÚµ¿À¸·Î ¿Ã¶ó¿ÀÁö ¾Ê°í ¼öµ¿À¸·Î ¿Ã¸®´Âµ¥ ¾à 40ºÐ °¡±îÀÌ °É¸³´Ï´Ù.
  (¿ø·¡ µ¥ÀÌÅÍ ³ëµå´Â ÀÚµ¿À¸·Î ¿Ã¶ó¿Í¾ß µÇ´Â°Å ¾Æ´Ñ°¡¿ä? ¿Ã¶ó¿Ã¶§ ÀÌ·¸°Ô ¿À·¡ °É¸®³ª¿ä?)
 
Á¶¾ð ºÎʵ叮°Ú½À´Ï´Ù.T.T
==========================================================================================
 
// ¼­¹ö »ç¾çÀº   ÀÎÅÚ Á¦¿Â µà¾ó CPU ¿¡ 10G ¸Þ¸ð¸®·Î ±¸¼ºµÇ¾î ÀÖ½À´Ï´Ù.
 
// ¼­¹ö ±¸¼ºÀÔ´Ï´Ù.
 
[ndbd(NDB)]     4 node(s)
id=3    @XXX.XXX.52.211  (mysql-5.1.44 ndb-7.1.4, Nodegroup: 0, Master)
id=4    @XXX.XXX.52.212  (mysql-5.1.44 ndb-7.1.4, Nodegroup: 0)
id=7    @XXX.XXX.52.204  (mysql-5.1.44 ndb-7.1.4, Nodegroup: 0)
id=8    @XXX.XXX.52.205  (mysql-5.1.44 ndb-7.1.4, Nodegroup: 0)
[ndb_mgmd(MGM)] 2 node(s)
id=1    @XXX.XXX.52.207  (mysql-5.1.44 ndb-7.1.4)
id=2    @XXX.XXX.52.208  (mysql-5.1.44 ndb-7.1.4)
[mysqld(API)]   2 node(s)
id=5    @XXX.XXX.52.211  (mysql-5.1.44 ndb-7.1.4)
id=6    @XXX.XXX.52.212  (mysql-5.1.44 ndb-7.1.4)
 
 
// MGM  Config ³»¿ëÀÔ´Ï´Ù.

[ndbd default]
NoOfReplicas=4
DataMemory=2048M
IndexMemory=320M
MaxNoOfOrderedIndexes = 10000
MaxNoOfUniqueHashIndexes = 15000
MaxNoOfAttributes = 20000
 
[tcp default]
portnumber=2202       
[ndb_mgmd]
Id=1
hostname=XXX.XXX.52.207         
datadir=/var/lib/mysql-cluster 
 
[ndb_mgmd]
Id=2
hostname=XXX.XXX.52.208        
datadir=/var/lib/mysql-cluster  
 
[ndbd]
Id=3
# (one [ndbd] section per data node)
hostname=XXX.XXX.52.211        
datadir=/usr/local/mysql/data  
MaxNoOfConcurrentOperations=500000
 
[ndbd]
Id=4
hostname=XXX.XXX.52.212         
datadir=/usr/local/mysql/data  
MaxNoOfConcurrentOperations=500000
 
[ndbd]
Id=7
# (one [ndbd] section per data node)
hostname=XXX.XXX.52.204         
datadir=/usr/local/mysql/data  
MaxNoOfConcurrentOperations=500000
 
[ndbd]
Id=8
hostname=XXX.XXX.52.205         
datadir=/usr/local/mysql/data  
MaxNoOfConcurrentOperations=500000
 
[mysqld]
nodeId=5
hostname=XXX.XXX.52.211 

[mysqld]
nodeId=6
hostname=XXX.XXX.52.212 
 
// Data ³ëµå°¡ µ¿½Ã¿¡ ³»·Á°¬À»¶§ mgm LOG ³»¿ë ÀÔ´Ï´Ù.
 
2010-07-20 14:52:08 [MgmtSrvr] INFO     -- Node 3: Local checkpoint 34 completed
2010-07-20 14:52:10 [MgmtSrvr] INFO     -- Node 3: Local checkpoint 35 started. Keep GCI = 17012 oldest restorable GCI = 17098
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 4: Transporter to node 7 reported error 0x16: The send buffer was full, but sleeping for a while solved
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 4: Transporter to node 7 reported error 0x16: The send buffer was full, but sleeping for a while solved - Repeated 2 times
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 4: Transporter to node 3 reported error 0x16: The send buffer was full, but sleeping for a while solved
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 4: Transporter to node 3 reported error 0x16: The send buffer was full, but sleeping for a while solved - Repeated 2 times
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 7: Transporter to node 4 reported error 0x16: The send buffer was full, but sleeping for a while solved
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 8: Transporter to node 7 reported error 0x16: The send buffer was full, but sleeping for a while solved
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 7: Transporter to node 4 reported error 0x16: The send buffer was full, but sleeping for a while solved
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 4: Transporter to node 8 reported error 0x16: The send buffer was full, but sleeping for a while solved
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 8: Transporter to node 7 reported error 0x16: The send buffer was full, but sleeping for a while solved
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 3: Transporter to node 8 reported error 0x16: The send buffer was full, but sleeping for a while solved
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 8: Transporter to node 7 reported error 0x16: The send buffer was full, but sleeping for a while solved
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 3: Transporter to node 8 reported error 0x16: The send buffer was full, but sleeping for a while solved
2010-07-20 14:57:18 [MgmtSrvr] WARNING  -- Node 3: Transporter to node 8 reported error 0x16: The send buffer was full, but sleeping for a while solved
2010-07-20 14:57:20 [MgmtSrvr] ALERT    -- Node 7: Forced node shutdown completed. Caused by error 2300: 'Generic error(Restart error). Temporary error, restart node'.
2010-07-20 14:57:20 [MgmtSrvr] ALERT    -- Node 4: Node 7 Disconnected
2010-07-20 14:57:20 [MgmtSrvr] ALERT    -- Node 1: Node 7 Disconnected
2010-07-20 14:57:21 [MgmtSrvr] ALERT    -- Node 8: Forced node shutdown completed. Caused by error 2300: 'Generic error(Restart error). Temporary error, restart node'.
2010-07-20 14:57:21 [MgmtSrvr] ALERT    -- Node 4: Node 8 Disconnected
2010-07-20 14:57:21 [MgmtSrvr] ALERT    -- Node 1: Node 8 Disconnected
2010-07-20 14:57:21 [MgmtSrvr] ALERT    -- Node 3: Forced node shutdown completed. Caused by error 2300: 'Generic error(Restart error). Temporary error, restart node'.
2010-07-20 14:57:21 [MgmtSrvr] ALERT    -- Node 4: Node 3 Disconnected
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: Communication to Node 3 closed
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: Communication to Node 7 closed
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: Communication to Node 8 closed
2010-07-20 14:57:21 [MgmtSrvr] ALERT    -- Node 4: Network partitioning - arbitration required
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: President restarts arbitration thread [state=7]
2010-07-20 14:57:21 [MgmtSrvr] ALERT    -- Node 1: Node 3 Disconnected
2010-07-20 14:57:21 [MgmtSrvr] ALERT    -- Node 4: Arbitration won - positive reply from node 1
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: GCP Take over started
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: Node 4 taking over as DICT master
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: GCP Take over completed
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: kk: 17293/17 2 0
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: LCP Take over started
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: ParticipatingDIH = 0000000000000010
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: ParticipatingLQH = 0000000000000010
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: m_LCP_COMPLETE_REP_Counter_DIH = [SignalCounter: m_count=0 0000000000000000]
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: m_LCP_COMPLETE_REP_Counter_LQH = [SignalCounter: m_count=1 0000000000000010]
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: m_LAST_LCP_FRAG_ORD = [SignalCounter: m_count=0 0000000000000000]
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: m_LCP_COMPLETE_REP_From_Master_Received = 0
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: LCP Take over completed (state = 5)
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: ParticipatingDIH = 0000000000000010
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: ParticipatingLQH = 0000000000000010
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: m_LCP_COMPLETE_REP_Counter_DIH = [SignalCounter: m_count=1 0000000000000010]
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: m_LCP_COMPLETE_REP_Counter_LQH = [SignalCounter: m_count=1 0000000000000010]
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: m_LAST_LCP_FRAG_ORD = [SignalCounter: m_count=1 0000000000000010]
2010-07-20 14:57:21 [MgmtSrvr] INFO     -- Node 4: m_LCP_COMPLETE_REP_From_Master_Received = 0
2010-07-20 14:57:22 [MgmtSrvr] INFO     -- Node 4: Started arbitrator node 1 [ticket=73090002b209c881]
2010-07-20 14:57:32 [MgmtSrvr] ALERT    -- Node 4: Forced node shutdown completed. Caused by error 2303: 'System error, node killed during node restart by other node(Internal error, programming error or missing error message, please report a bug). Temporary error, restart node'.
2010-07-20 14:57:32 [MgmtSrvr] ALERT    -- Node 1: Node 4 Disconnected
 

 

 
¹ÎÁ·
¾È³çÇϼ¼¿ä~ Ŭ·¯½ºÅÍ 4ÁßÈ­ ÇÏ¼Ì³×¿ä ¤Ñ0¤Ñ;;

µ¥ÀÌÅÍ »çÀÌÁî´Â ÀÛÀ¸½Å´ë.. »ó´çÈ÷ Áß¿äÇÑ ½Ã½ºÅÛ ÀΰŠ°°½À´Ï´Ù.

Ȥ½Ã À§ Áõ»óÀÌ ¾î¶²¶§¿¡ ¹ß»ýµÇ¾ú´ÂÁö.. ¾Ë¼ö ÀÖÀ»±î¿©?

±×¸®°í config.ini ÆÄÀÏ À§¿¡¼³Á¤ÀÌ ³¡Àΰ¡¿ä??

±×¸®°í Ŭ·¯½ºÅÍ ¹öÁ¯µµ ¾Ë·ÁÁֽñ⠹ٶø´Ï´Ù.

±×¸®°í ndb out log µµ Àû¾îÁÖ½Ã¸é °¨»ç ÇϰڽÀ´Ï´Ù.
Ŭ·¯½ºÅÍ
À§ Áõ»ó 
¼­¹ö¿¡  Web, WebStage ¶ó´Â 2°³ÀÇ DB °¡ Á¸Àç ÇÕ´Ï´Ù.
Å×½ºÆ®¸¦ À§ÇÏ¿© Web DBÀÇ Å×ÀÌºí ¸ðµÎ¸¦ -> WebStage  ¿¡ ¿Å±â´Â ¸í·É¾î¸¦ ¼öÇàÇϰí
ÇØ´ç ¿¡·¯°¡ ¹ß»ý ÇÏ¿´½À´Ï´Ù.
SQLYOG(MYSQL GUI TOOL) ¿¡¼­  Copy Database to Different  ¸í·ÉÀ¸·Î Å×À̺í Àüü¸¦ ´Ù¸¥ Å×ÀÌÅͺ£À̽º·Î À̵¿Çϸ鼭 ¹ß»ý)

config.ini ÆÄÀÏÀº À§ÀÇ ³»¿ëÀÌ ÀüºÎ ÀÔ´Ï´Ù.
========================================
mgm out log
========================================
stop checker 0
==CONFIRMED==
Node 3 failed
Node 4 failed
Node 7 failed
Node 8 failed

=========================================
master Data Node  Error log
=========================================
100720 14:40:23 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/adminEventList
100720 14:40:24 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/adminMainTagList
100720 14:40:24 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/adminStatMember
100720 14:40:25 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/adminStatPagora
100720 14:40:26 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/adminStatPointUse
100720 14:40:27 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/adminStatTogme
100720 14:40:27 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/banner
100720 14:40:28 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/billing
100720 14:40:29 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/blogBlackList
100720 14:40:30 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/blogComment
100720 14:41:43 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/blogManage
100720 14:42:02 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/blogPost
100720 14:43:34 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/blogPostMeta
100720 14:54:35 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/notice
100720 14:55:04 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/noticeCategory
100720 14:55:05 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/noticeCategoryComment
100720 14:55:06 [Note] NDB Binlog: CREATE TABLE Event: REPL$WebStage/pointLog
100720 14:57:17 [ERROR] Got error 4028 when reading table './Web/em_smt_tran'
100720 14:57:17 [ERROR] Got error 4028 when reading table './Web/em_mmt_tran'
100720 14:57:17 [ERROR] Got error 4028 when reading table './Web/em_smt_tran'
100720 14:57:17 [ERROR] /usr/local/mysql/bin/mysqld: Sort aborted
100720 14:57:17 [ERROR] /usr/local/mysql/bin/mysqld: Sort aborted
100720 14:57:17 [ERROR] /usr/local/mysql/bin/mysqld: Sort aborted
100720 14:57:17 [ERROR] Got error 4028 when reading table './Web/blogPost'
100720 14:57:17 [ERROR] Got error 4010 when reading table './Web/users'
100720 14:57:28 [ERROR] Got error 4002 when reading table './Web/em_smt_tran'
100720 14:57:28 [Note] NDB Binlog: Node: 3, down, Subscriber bitmask 00
100720 14:57:28 [Note] NDB Binlog: Node: 4, down, Subscriber bitmask 00
100720 14:57:28 [Note] NDB Binlog: Node: 7, down, Subscriber bitmask 00
100720 14:57:28 [Note] NDB Binlog: Node: 8, down, Subscriber bitmask 00
100720 14:57:28 [ERROR] /usr/local/mysql/bin/mysqld: Sort aborted
100720 14:57:28 [Note] NDB Binlog: cluster failure for ./mysql/ndb_schema at epoch 17294/0.
100720 14:57:28 [ERROR] /usr/local/mysql/bin/mysqld: Sort aborted
100720 14:57:28 [ERROR] Got error 4028 when reading table './Web/togMyLine'
100720 14:57:28 [ERROR] Got error 157 when reading table './Web/users'
100720 14:57:28 [ERROR] /usr/local/mysql/bin/mysqld: Sort aborted
¹ÎÁ·
ndb_nodeid_error.log  Á¤º¸Á» ºÎʵ右´Ï´Ù.

Ŭ·¯½ºÅÍ ¹öÁ¯ Á¤º¸µµ È®ÀÎ ºÎʵ右´Ï´Ù.

ÇöÀç NDB ¸¦ À§ÇÑ ¼³Á¤°ªÀÌ ºÎÁ·Çؼ­ ¸®¼Ò½º ºÎÁ·À¸·Î ÀÎÇÏ¿© À§ Áõ»óÀÌ ³ªÅ¸³­°Å °°½À´Ï´Ù.

¿ì¼± À§¿¡ ¿¡·¯ ·Î±× ¿Í ¹öÁ¯ Á¤º¸ È®ÀÎ ºÎʵ右´Ï´Ù.
Ŭ·¯½ºÅÍ
64ºñÆ® Cent OS 5.3 ¿¡¼­ mysql-cluster-gpl-7.1.4b-linux-x86_64-glibc23  »ç¿ëÇÕ´Ï´Ù.

=================================================================================
ndb_nodeid_error.log  ³»¿ëÀÔ´Ï´Ù.
=================================================================================

Current byte-offset of file-pointer is: 1067


Time: Tuesday 20 July 2010 - 14:57:15
Status: Temporary error, restart node
Message: Generic error (Restart error)
Error: 2300
Error data: Out of SendBufferMemory in sendSignal
Error object:
Program: /usr/local/mysql/bin/ndbmtd
Pid: 27805 thr: 2
Version: mysql-5.1.44 ndb-7.1.4b
Trace: /usr/local/mysql/data/ndb_3_trace.log.1 /usr/local/mysql/data/ndb_3_trace.log.1_t1 /usr/local/mysql/data/ndb_3_trace.log.1_t2 /usr/local/mysql/data/ndb_3_trace.log.1_t3
***EOM***

Time: Tuesday 20 July 2010 - 14:57:15
Status: Permanent error, external action needed
Message: Signal lost, out of send buffer memory, please increase SendBufferMemory or lower the load (Resource configuration error)
Error: 6052
Error data: Remote node id 8.
Error object: TransporterCallback.cpp
Program: /usr/local/mysql/bin/ndbmtd
Pid: 27805 thr: 3
Version: mysql-5.1.44 ndb-7.1.4b
Trace: /usr/local/mysql/data/ndb_3_trace.log.1 /usr/local/mysql/data/ndb_3_trace.log.1_t1 /usr/local/mysql/data/n
¹ÎÁ·
SendBufferMemory=32M  config.ini ÆÄÀÏ¿¡ Ãß°¡ ÇϽÅÈÄ µðºñ ¸®½ºÅ¸Æ® ÇØº¸½Ã±â ¹Ù¶ø´Ï´Ù.

ÇöÀç Çѹø¿¡ ¸¹Àº ºÎÇϰ¡ »ý°Ü¼­ NDB ¸Þ¸ð¸® ºÎÁ·À¸·Î ÀÎÇÏ¿© Á×Àº°ÍÀ¸·Î ¿¹»ó µË´Ï´Ù.
ÀÌÀü±Û °¢ µ¥ÀÌÅÍ ³ëµåº° ndb_out.log ÆÄÀÏÀ» º¸¸é ¾Æ·¡¿Í °°Àº ·Î±×°¡ Çѹø¾¿ ½×À̴µ¥ 
´ÙÀ½±Û Cluster¿¡ °üÇÑ ¹®ÀÇ »çÇ×ÀÔ´Ï´Ù. 
MySQL Korea »çÀÌÆ®ÀÇ ÄÁÅÙÃ÷ ¼ÒÀ¯±ÇÀº (ÁÖ)»ó»óÀ̺ñÁî¿¡ ÀÖÀ¸¹Ç·Î ¹«´ÜÀüÀ縦 ±ÝÇÕ´Ï´Ù.
Copyright ¨Ï ssebiz All Rights Reserved.