Çë½Ìmysql¼¯ÈºÊ±Óöµ½µÄÎÊÌ⣡£¡
ÒÔÏÂÊǹÜÀí½ÚµãµÄÅäÖÃ
[NDBD DEFAULT]
NoOfReplicas=2
[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]
[NDB_MGMD] # ¹ÜÀí½Úµã
HostName=192.168.1.10
[NDBD] # ´æ´¢½Úµã 1
# ±¾»ú£¨¹ÜÀí½Úµã£©µÄ IP µØÖ·
HostName=192.168.1.13
DataDir=/var/lib/mysql-cluster
BackupDataDir=/var/lib/mysql-cluster/backup
[NDBD] # ´æ´¢½Úµã 2
HostName=192.168.1.14
DataDir=/var/lib/mysql-cluster
BackupDataDir=/var/lib/mysql-cluster/backup
# Óм¸¸ö´æ´¢½Úµã£¬¾Íд¼¸ÐÐ[MYSQLD]
[MYSQLD]
[MYSQLD]
ÒÔÏÂÊÇÊý¾Ý¿â½ÚµãµÄÅäÖÃ
[client]
socket = /var/run/mysqld/mysqld.sock
port = 3306
[mysqld]
ndbcluster
ndb-connectstring=192.168.1.10
# ¹ÜÀí½ÚµãµÄ IP µØÖ·
default-storage-engine=NDBCLUSTER
[mysql_cluster]
ndb-connectstring=192.168.1.10 # ¹ÜÀí½ÚµãµÄ IP µØÖ·
°´Àí˵ÅäÖÃÍêºóÎÒÔÚ¹ÜÀí½Úµã¿ÉÒÔ¿´µÃµ½µÄÊÇ
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.1.13 (Version: 5.0.51, Nodegroup: 0)
id=3 @192.168.1.14 (Version: 5.0.51, Nodegroup:
Ïà¹ØÎÊ´ð£º
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í:
You can't specify target table 'a_table' for update in from clause
ÍêÕûSQLÓï¾äÊÇ
UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......