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