ΪpowerdesignerÌí¼ÓmysqlµÄ×Ö·û¼¯Ö§³Ö
Ò»°ã½¨Ä£¿ÉÄܶ¼»áÓõ½£ºpowerdesigner
µ«ÊÇ£¬ÔÚ½¨±íµÄʱºò£¬ÎÒһֱûÓÐÕÒµ½£º
DEFAULT CHARACTER SET
COLLATE
Á½¸öÑ¡Ïî¡£Òò´Ë£¬ÏëÁ˸ö·½·¨£¬µã»÷£º¹¤¾ßÀ¸-¡·database-¡·edit current DBMS
È»ºó£¬Ñ¡ÖУºMYSQL50::Script\Objects\Table\Options
ÔÚoptionsĩβÌí¼Ó£º
ENGINE = %s : list = BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM, default = MYISAM
DEFAULT CHARACTER SET = %s : list = utf8 | gbk, default = utf8
COLLATE = %s : list = utf8_bin | utf8_general_ci | gbk_bin | gbk_chinese_ci, default = utf8_bin
µÚÒ»¸ö£º´æ´¢ÒýÇæ
µÚ¶þ¸ö£º×Ö·û¼¯
µÚÈý¸ö£º´øbinÊÇÇø·Ö´óСд£¬ci²»Çø·Ö
µã»÷ok±£´æ£¬»Øµ½¹¤×÷Çø£¬Ë«»÷ij±í£¬ÔÚ£º
Physicial OptionsÖУ¬¿ÉÒÔ¿´µ½¸Õ¸ÕÌí¼ÓµÄÑ¡ÏÕâÑù¾Í¿ÉÒÔ°´ÕÕ×Ô¼ºµÄ·½Ê½À´²Ù×÷ÁË¡£
Ïà¹ØÎĵµ£º
query result(14 records)
id
uid
gid
1
11
502
2
107
502
3
100
503
4
110
501
5
112
501
6
104
502
7
100
502
8
100
501
9
102
501
10
104
502
11
100
502
12
100
501
13
102
501
14
110
501
µÚÆßÌõÓëµÚʮһÌõÖØ¸´µÈ
·½·¨Ò»
mysql> create temporary table tmp_wrap ......
A) Shutdown management node and data node
devmysql3# ndb_mgm -e shutdown
devmysql4# ndb_mgm -e shutdown
B) Shutdown MySQL proccess
devmysql3# mysqladmin shutdown
devmysql4# mysqladmin shutdown
devmysql3 ip: 10.130.30.217
devmysql4 ip: 10.130.30.218
rpm -ivh MySQL-Cluster-gpl-storage ......
MySQL¼¯ÈºÊÇÒ»ÖÖÔÚÎÞ¹²Ïí¼Ü¹¹ÏµÍ³ÀïÓ¦ÓÃÄÚ´æÊý¾Ý¿â¼¯ÈºµÄ¼¼Êõ¡£ÕâÖÖÎÞ¹²ÏíµÄ¼Ü¹¹¿ÉÒÔʹµÃϵͳʹÓ÷dz£±ãÒ˵IJ¢ÇÒÊÇ×îСÅäÖõÄÓ²¼þ¡£
MySQL¼¯ÈºÊÇÒ»ÖÖ·Ö²¼Ê½Éè¼Æ£¬Ä¿±êÊÇÒª´ïµ½Ã»ÓÐÈκε¥µã¹ÊÕϵ㡣Òò´Ë£¬ÈκÎ×é³É²¿·Ö¶¼Ó¦¸ÃÓµÓÐ×Ô¼ºµÄÄÚ´æºÍ´ÅÅÌ¡£Èκι²Ïí´æ´¢·½°¸ÈçÍøÂç¹²Ïí£¬ÍøÂçÎļþϵͳºÍSANÉ豸ÊDz»ÍƼö»ò²»Ö ......
ÒýÑÔ
¡¡¡¡Êý¾Ý¿âµÄÉè¼Æ·¶Ê½ÊÇÊý¾Ý¿âÉè¼ÆËùÐèÒªÂú×ãµÄ¹æ·¶£¬Âú×ãÕâЩ¹æ·¶µÄÊý¾Ý¿âÊǼò½àµÄ¡¢½á¹¹Ã÷ÎúµÄ£¬Í¬Ê±£¬²»»á·¢Éú²åÈ루insert£©¡¢É¾³ý£¨delete£©ºÍ¸üУ¨update£©²Ù×÷Òì³£¡£·´Ö®ÔòÊÇÂÒÆß°ËÔ㣬²»½ö¸øÊý¾Ý¿âµÄ±à³ÌÈËÔ±ÖÆÔìÂé·³£¬¶øÇÒÃæÄ¿¿ÉÔ÷£¬¿ÉÄÜ´æ´¢ÁË´óÁ¿²»ÐèÒªµÄÈßÓàÐÅÏ¢¡£
¡¡¡¡Éè¼Æ·¶Ê½ÊDz»ÊǺÜÄѶ®ÄØ£¿·ÇÒ² ......