¤ªÀ¤ÏäˤʤäƤª¤ê¤Þ¤¹¡£
SHOW¤Î·ë²Ì¤ò˺¤ì¤Æ¤¤¤Þ¤·¤¿¤Î¤Ç¥á¡¼¥ë¤òÁ÷¤ê¤Þ¤¹¡£
¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¡£
[ndbd(NDB)] 2 node(s)
id=2    @192.168.116.129 (mysql-5.1.30 ndb-6.30.20, Nodegroup:0,Master)
id=3    @192.168.116.131 (mysql-5.1.30 ndb-6.30.20, Nodegroup:0)

[ndb_mgmd(MGM)] 1 node(s)
id=1    @192.168.116.128 (mysql-5.1.30 ndb-6.30.20)

[mysqld(API) 4node(s)
id=4 (not connected,accepting connect from 192.168.116.132)
id=5 (not connected,accepting connect from 192.168.116.133)
id=6 (not connected,accepting connect from any host)
id=7 (not connected,accepting connect from any host)
---------- žÁ÷¥á¥Ã¥»¡¼¥¸ ----------
From: Hiroyuki Ogawa <eng16danbo@gmail.com>
ÆüÉÕ: 2009/02/23 12:45
·ï̾: Re: [mysql 14736] Re: Fwd: Re: Fwd: Re: [mysql cluster]sql¥Î¡¼¥É¤Î¹½ÃÛ
To: ml@mysql.gr.jp


¤ªÀ¤ÏäˤʤäƤ¤¤Þ¤¹¡£
³Æ¼ï¥Õ¥¡¥¤¥ë¤ÎÀßÄê¤Ï°Ê²¼¤ÎÄ̤ê¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
¢£config.ini¤ÎÆâÍƤˤĤ¤¤Æ
[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 80M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512

[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster

[ndb_mgmd]
Id=1
HostName= 192.168.116.128

[ndbd]
Id= 2
HostName= 192.168.116.129

[ndbd]
Id= 3
HostName= 192.168.116.131

[mysqld]
Id= 4
HostName= 192.168.116.132

[mysqld]
Id= 5
HostName= 192.168.116.133

[mysqld]
Id= 6

[mysqld]
Id= 7

¢£sql¥Î¡¼¥É¤Îmy.cnf¤ÎÀßÄê¤Ë¤Ä¤¤¤Æ
­¡/usr/share/doc/my-large.cnf¤ò/etc/my.cnf¤Ë¥³¥Ô¡¼
­¢my.cnf¤Î[mysqld]¤Ë°Ê²¼¤òÄɲÃ
ndbcluster
ndb-connectstring = 192.168.116.128

¢£¥¨¥é¡¼¥í¥°¤Ë¤Ä¤¤¤Æ
¡Ê¥Û¥¹¥È̾).err¤Ï°Ê²¼¤ÎÄ̤ê¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¡£
090223 12:03:06 [Note] /usr/sbin/mysqld: Normal shutdown

090223 12:03:06 [Note] Event Scheduler: Purging the queue. 0 events
090223 12:03:06  InnoDB: Starting shutdown...
090223 12:03:07  InnoDB: Shutdown completed; log sequence number 0 46409
090223 12:03:07 [Note] /usr/sbin/mysqld: Shutdown complete

090223 12:03:07 mysqld_safe mysqld from pid file /var/lib/mysql/als803.pid ended
090223 12:03:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
090223 12:03:39  InnoDB: Started; log sequence number 0 46409
090223 12:03:39 [Note] Event Scheduler: Loaded 0 events
090223 12:03:39 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.30-ndb-6.3.20-cluster-gpl'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Cluster Server (GPL)

°Ê¾å¡¢²óÅú¤¬ÃÙ¤¯¤Ê¤Ã¤Æ¤·¤Þ¤¤¡¢¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¤¬¤è¤í¤·¤¯¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£
2009/02/23 10:27 Mikiya Okuno <Mikiya.Okuno@sun.com>:

¤ª¤Ï¤è¤¦¤´¤¶¤¤¤Þ¤¹¡£

config.ini
my.cnf
SHOW¤Î½ÐÎÏ
¥¨¥é¡¼¥í¥°

¤¢¤¿¤ê¤Ï¤É¤¦¤Ê¤Ã¤Æ¤¤¤Þ¤¹¤«¡©
--
Mikiya Okuno, MySQL Support Engineer
Sun Microsystems KK, Tokyo, Japan
On 20/02/2009, at 7:50 PM, Hiroyuki Ogawa wrote:

> ´ÉÍý¥Î¡¼¥É¤È¥Ç¡¼¥¿¥Î¡¼¥É¡¢¤ª¤è¤ÓSQL¥Î¡¼¥É¤Ï°Ê²¼¤Î¥µ¥¤¥È¤ò»²¹Í¤·¤Þ¤·¤¿¡£
> http://blog.technology-knowledge.jp/2008/04/16/120/
> http://blog.technology-knowledge.jp/2008/04/16/122/
> http://blog.technology-knowledge.jp/2008/04/16/124/
>
> ndb_mgm>show¤ò¼Â¹Ô¤·¤¿¤È¤­¡¢¥¹¥Æ¡¼¥¿¥¹¤ò³Îǧ¤¹¤ë¤È
> ´ÉÍý¥Î¡¼¥É¤È¥Ç¡¼¥¿¥Î¡¼¥É¤ÎÀßÄê¤Ï¤¢¤Ã¤Æ¤¤¤ë¤è¤¦¤Ë»×¤¨¤Þ¤¹¡£
>
> ʳƮ¤·¤Æ¤¤¤Þ¤¹¤¬SQL¥Î¡¼¥É¤ÎÀßÄê¼ê½ç¤¬¤ï¤«¤ê¤Þ¤»¤ó¡£
> ¾Ò²ð¤·¤Æ¤¤¤¿¤À¤¤¤¿¥µ¥¤¥È¤ò»²¹Í¤Ë¤·¤Æ¤â¾õ¶·¤ÏÊѤï¤ê¤Þ¤»¤ó¡£
> ¤É¤Ê¤¿¤«¡¢ÀßÄê¼ê½ç¤Ë¤Ä¤¤¤Æ¤´¶µ¼ø´ê¤¤¤Þ¤¹¡£
> ---------- žÁ÷¥á¥Ã¥»¡¼¥¸ ----------
> From: Mikiya Okuno <Mikiya.Okuno@sun.com>
> ÆüÉÕ: 2009/02/20 18:56
> ·ï̾: [mysql 14734] Re: Fwd: Re: [mysql cluster]sql¥Î¡¼¥É¤Î¹½ÃÛ
> To: ml@mysql.gr.jp
>
>
> ¤³¤ó¤Ð¤ó¤Ï¡£
>
> ¤½¤Î¼ê½ç¤À¤È¡¢´ÉÍý¥Î¡¼¥É¤ä¥Ç¡¼¥¿¥Î¡¼¥É¤ÎÀßÄ꤬¤Þ¤À¤Ê¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£
> ÀßÄê¤Î¼ê½ç¤ò°ÊÁ°ThinkIT¤ËÅê¹Æ¤·¤¿¤Î¤Ç¤³¤ÎÊÕ¤òÆɤó¤ÇÀßÄꤷ¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£
> http://www.thinkit.co.jp/article/95/
>
> > ¤³¤ì¤é¤ÏMySQL Server¤Î¥Ñ¥Ã¥±¡¼¥¸¤È¥Ñ¥Õ¥©¡¼¥Þ¥ó¥¹¤Ï
> > Ʊ¤¸¤Ê¤Î¤Ç¤·¤ç¤¦¤«¡£
>
> MySQL Cluster¤¬Æþ¤Ã¤Æ¤¤¤ë°Ê³°¤ÏƱ¤¸¤Ç¤¹¡£
>
> ¤Ç¤ÏÎɤ¤½µËö¤ò¡ª
> --
> ±üÌî ´´Ìé
> MySQL¥µ¥Ý¡¼¥È¥¨¥ó¥¸¥Ë¥¢
> ¥µ¥ó¡¦¥Þ¥¤¥¯¥í¥·¥¹¥Æ¥à¥º³ô¼°²ñ¼Ò
> http://www-jp.mysql.com/
>
> MySQL¥Ö¥í¥°½¸Ìó¥µ¥¤¥È¡ÖPlanet MySQL¡×ÆüËܸìÈÇ¥ª¡¼¥×¥ó¡ª
> http://jp.planetmysql.org/
>
>
>