Ö§³ÖMySqlÒ»°Ñ
ÒÔÏÂת×Ô Osss.cn Óʼþ£¬ÇëʹÓùý¡¢ÕýÔÚʹÓûòÕßÖ§³Ö¿ªÔ´µÄÅóÓÑÖ§³ÖÒ»ÏÂMySql£¬Ð»Ð»¡£
ҲϣÍû½ÌÓý²¿¡¢¿Æ¼¼²¿¸øÓèÖ±½ÓÖ§³Ö£¡
´ó¼ÒºÃ£º½ñÌì¿´µ½ÕâÔòÐÂÎÅ£¬Óë´ó¼Ò¹²Ïíһϣ¬MySQL´´Ê¼ÈËÏ£ÍûÖйúÉÌÎñ²¿ÄܽéÈëOracle&SunÊÕ¹º°¸£¬ºÃÏñ²¢Ã»ÓÐʵÖʽøÕ¹¡£¶ø¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÔÚÉÏÖÜÕ¹¿ªµ÷²é¡£Èç¹ûÐèÒªÉÌÎñ²¿ÊÜÀí´ËÊ£¬ÊÇ·ñÐèÒªÖйú¿ªÔ´Èí¼þÍÆ½øÁªÃ˰ïÖú?
¾Ý·͸ÉçÏûÏ¢£¬MySQL´´Ê¼ÈËMichael Widenius ÏÖÔÚÕýÔÚѰÇóÖйúºÍ¶íÂÞ˹Õþ¸®µÄ°ïÖú£¬ÒÔ·´¶ÔOracle
ÊÕ¹ºSun¹«Ë¾£¬Michael Widenius ֮ǰºôÓõÅ·ÃËÍ£Ö¹´ËÏî½»Ò×£¬µ«¸ù¾ÝÏÖÓеÄÇé¿öÀ´¿´£¬Å·ÃË»ò½«Åú×¼´ËÏî½»Òס£Îª´ËMichael
WideniusÕýÔÚѰÇóÖйúÕþ¸®µÄ°ïÖú£¬ËûÖ¸³öĿǰÔÚÈ«ÇòÖÐÓг¬¹ý3ÍòMySQLÓû§Ç©Ãû±íʾ·´¶Ô´ËÏî½»Ò×£¬Ï£ÍûÓиü¶àµÄÈ˲ÎÓë½øÀ´¡£ÍøÖ·ÊÇ
helpmysql.org¡£
WideniusÏÖÔÚÏ£ÍûÖйúÉÌÎñ²¿ºÍ¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÄܽéÈë´ËÊ£¬×èÖ¹½»Ò×ʼþ½øÒ»²½·¢Õ¹¡£“ËûÃǷdz£Ç¿´ó£¬×ÔÐźͿªÔ´ÓѺõĹú¼Ò£¬ËûÃÇÍêÈ«ÓÐȨÀûºÍ»ú»áÔÚÕâ¼þÊÂÉÏ×öµÄ±ÈÅ·Ã˸üºÃ”£¬Widenius˵¡£Ä¿Ç°¶íÂÞ˹Áª°î·´Â¢¶Ï»ú¹¹ÒѾ¾Í´ËʽéÈëµ÷²é¡£
À´Ô´£ºhttp://osss.cn/news/2010/01/19/mysql%E5%88%9B%E5%A7%8B%E4%BA%BA%EF%BC
%9A%E5%B8%8C%E6%9C%9B%E5%BE%97%E5%88%B0%E4%B8%AD%E5%9B%BD%E6%94%BF%E5%BA%9C%E7%9A%84%E5%B8%AE%E5%8A%A9/
·͸É籨µÀ£ºhttp://www.reuters.com/article/idUSTRE60G1Z120100117
Osss.cn ¿ªÔ´ÉçÇø
Http://osss.cn
Ïà¹ØÎĵµ£º
>>mysql:
1¡¢²é¿´ËùÓбíÃû£º
show tables [from db_name];
2¡¢²é¿´×Ö¶ÎÐÅÏ¢
SHOW FULL COLUMNS from db_name.table_name
»ñÈ¡ÒÔÏÂÐÅÏ¢
Field £º×Ö¶ÎÃû
Type£º×Ö¶ÎÀàÐÍ
Collation£º×Ö·û¼¯ £¨mysql 5.0ÒÔÉÏÓУ©
Null £ºÊÇ·ñ¿ÉÒÔΪNULL
Key£ºË÷Òý£¨PRI,unique,index)
Default£ºÈ±Ê¡Öµ
Extra£º¶îÍ⣨ÊÇ·ñ aut ......
Each MySQL Cluster host computer running an SQL node must have
installed on it a MySQL binary. For management nodes and data
nodes, it is not necessary to install the MySQL server binary, but
management nodes require the management server daemon
......
Starting the cluster is not very difficult after it has been configured. Each cluster node process must be started separately, and on the host where it resides. The management node should be started first, followed by the data nodes, and then finally by any SQL nodes:
On the management host, issu ......
GROUP_CONCAT ÊÇÒ»¸öºÏ²¢¶àÐеĺ¯Êý£¬Ò»°ãÓõÄÉÙ£¬ËùÒԺܶàÈ˶¼²»ÖªµÀ£¬ÎÒÒ²ÊÇÒ»¸ö£¬½ñÌìżȻ¿´µ½£¬¹Ê¼ÇÏ·½·¨£»
GROUP_CONCATµÄÓï·¨ÈçÏ£º
GROUP_CONCAT([DISTINCT] expr [,expr ...][ORDER BY {unsigned_integer | col_name | expr}[ASC | DESC] [,col_name ...]][SEPARATOR str_val])
ÏÂÃæÑÝʾһÏÂÕâ¸öº¯Êý£¬ÏȽ¨Á¢Ò ......