MySQL cluster±¸·Ý»Ö¸´
±¸×¢£ºÈç¹ûÄãÓÐʱ¼äÄãÓ¦¸ÃÔĶÁÕâ¸ö±¸×¢£¬Èç¹ûûÓÐʱ¼äÄã¸üÒªÔĶÁÒÔϱ¸×¢¡£ ÔÚÍøÂçÉÏÕÒÁ˺ܶàÏà¹Ø±¸·ÝºÍ»¹ÔµÄ½Ì³Ì£¬´ó¶à¶¼ÊÇ»¥Ïà³Ï®£¬°´ÕÕËûÃǵĽ̳ÌÄܹ»³É¹¦±¸·Ý£¬»¹Ô¾ÍºÜÈÃÈ˾¾ÐÄÁË¡£Ì¸Ì¸Ë¼Â·ºÍ×¢Òâµã°É¡£ Ê×ÏÈ£¬µÚÒ»²½²»ÓÃ˵£¬¿Ï¶¨ÊDZ¸·ÝÊý¾Ý¿â¡£×î¼òµ¥£¬´ò¿ª¹ÜÀí½ÚµãµÄndb_mgm¿ØÖÆÌ¨£¬ÊäÈëstart backup backupID£¨backupidÓÃÈÎÒâÊý×Ö£¬±ÈÈçÈÕÆÚ20100106£¬×¢Ò⣬²»ÄܺÍÒÔǰµÄ±¸·ÝIDÏàͬ£©¡£ÔÚÄãµÄËùÓд洢½ÚµãµÄ$datadir/BACKUPÏ»áÉú³ÉÏàÓ¦±¸·ÝĿ¼BACKUP-backupid µÚ¶þ²½£¬ndb_mgmÖÐÊäÈëshutdownÀ´¹Ø±ÕËùÓеĴ洢½ÚµãºÍËùÓеĹÜÀí½Úµã£¨°üÀ¨Ëü±¾Éí£©¡£ µÚÈý²½£¬ÔÚËùÓеÄsql½ÚµãÖÐɾ³ýÊý¾Ý¿â£¬ÁôÏÂϵͳ×Ô´øµÄ //±¸×¢£¬µÚÈý²½ÊDz»ÊÇÒ»¶¨ÐèÒª×öÄØ£¬Ä¿Ç°»¹Ã»²âÊÔ¹ý£¬²»¹ýÖÁÉÙÖÆÔìÁËÒ»¸öÊý¾Ý¶ªÊ§µÄÏÖÏó µÚËIJ½£¬°´Ë³ÐòÆô¶¯mysql¼¯Èº£¬ËùÓйÜÀí½Úµã£¬È»ºóËùÓд洢½Úµã£¨Æô¶¯Ê±ºòÐèÒª¼ÓÉϲÎÊý--initial£©£¬×îºóËùÓÐsql½Úµã¡£ µÚÎå²½£¬ÔÚ´æ´¢½ÚµãMaster£¨192.168.16.10£©ÉÏÖ´ÐÐndb_restore»¹ÔÃüÁî/usr/local/mysql/bin/ndb_restore -n11 -b20100106 -r -m --backup_path=/opt/mydata/BACKUP/BACKUP-20100106/ --ndb-connectstring=nodeid=27,192.168.16.8,192.168.16.9 MasterÈçÏ¡££¨id=11£© id=11 @192.168.16.10 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0, Master) id=12 @192.168.16.11 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0) id=13 @192.168.16.12 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0) id=14 @192.168.16.13 (mysql-5.1.39 ndb-7.0.9, Nodegroup: 0) ÃüÁî½âÊÍ£º/usr/local/mysql/bin/ndb_restore »¹ÔÃüÁî -n µ±Ç°´æ´¢½ÚµãµÄnodeid -b Òª»¹ÔµÄbackupid -r Êý¾Ý¿ª¹Ø£¬Ò²¾ÍÊÇ»¹ÔÊý¾ÝÁË -m »¹Ô±í½á¹¹ --ndb-connectstring=nodeid=27,192.168.16.8,192.168.16.9 192.168.16.8£¬192.168.16.9ÊÇÁ½¸ö¹ÜÀí½ÚµãµÄip£¬27ÊÇÊ²Ã´ÄØ£¬¿´¿´¹ÜÀí½ÚµãµÄconfig.iniÄÚµÄmysqldÅäÖã¬ÆäÖÐÓÐÒ»¶ÎÈçÏ£º [mysqld] HostName=192.168.16.24 Id= 25 [mysqld] HostName=192.168.16.25 Id= 26 [mysqld] [mysqld] ±ØÐëÁôÁ½¸ö¿ÕÓàµÄ[mysqld]£¬×îºóÒ»¸öÓÐÖ¸¶¨HostNameµÄmysqld ID=26£¬ÄÇôÏÂÒ»¸ö¿Õ°×µÄmysqldµÄIDĬÈϾÍÊÇ27ÁË¡£Õâ¸öÇ°Ãænodeid=27Ò²¾ÍÊÇÕâôÀ´µÄ£¬Æäʵ¸Ä³Énodeid=28Ò²ÊÇ¿ÉÒԵġ£ µÚÁù²½£¬ÔÚ´æ´¢½Úµãslave£¨³ý192.168.16.10ÒÔÍ⣩ÉÏÖ´ÐÐndb_restore»¹ÔÃüÁî/usr/local/mysql/bin/ndb_restore -n12 -b20100106 -r -d --backu
Ïà¹ØÎĵµ£º
ÎÒÃÇÖªµÀÓÃpowerdesignerµ¼³öµÄsqlÎļþºó׺Ϊ'.sql'£»ÓÃphpmyadminºÜÈÝÒ×µ¼ÈëMysQLÊý¾Ý¿â£¬µ«ÊÇÓÃPHPÔõôµ¼ÈëÊý¾Ý¿âÄØ?
ÎÒÓÃpowerdesignerÉè¼ÆÒ»¸öÊý¾Ý¿âºóµ¼³ösqlÎļþ£¨Ò»¸öͶƱϵͳ£©Îª'vote.sql'£»
ÎļþÄÚÈÝΪ£¨Ò»Ð©sqlÓï¾äºÍ×¢ÊÍ£©£º
/*======================= ......
Ê×ÏÈ£¬ÒªÏÂÔØÒ»¸öÁ¬½ÓmysqlÊý¾Ý¿âµÄÇý¶¯³ÌÐò: mysql-connector-java-3.0.15-ga-bin.jar, Õâ¸öÇý¶¯³ÌÐò²»ÐèÒª×öÆäËüÅäÖÃ,Ò²¾ÍÊÇ˵£¬¶ÔÓÚmysqlÊý¾Ý¿â£¬²»±ØÏñaccess»òÕßoracleÒª½¨Á¢odbcÊý¾ÝÔ´¡£
Æä´Î£¬½«ÉÏÃæµÄ.jarÎļþ¼ÓÈëµ½classpath»·¾³±äÁ¿ÖС£
×îºó£¬¾ÍÊÇд´úÂë½øÐвâÊÔÁË¡£
Ö÷Òª´úÂëÈçÏ£º
......
mysql ±¸·ÝºÍ»Ö¸´²ßÂÔ
ÎÄÕ·ÖÀà:Êý¾Ý¿â
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£±¾ÎÄÖ÷Òª¶ÔMyISAM±í×ö±¸·Ý»Ö¸´¡£
±¸·Ý²ßÂÔÒ»£ºÖ±½Ó¿½±´Êý¾Ý¿âÎļþ£¨²»ÍƼö£©
±¸·Ý²ßÂÔ¶þ£ºÊ¹ÓÃmysqlhotcopy±¸·ÝÊý¾Ý¿â£ ......
Òý×Ô http://www.itpub.net/thread-1034410-1-1.html
Mysql Explain Ïê½â
Ò».Óï·¨
explain < table_name >
ÀýÈç: explain select * from t3 where id=3952602;
¶þ.explainÊä³ö½âÊÍ
+----+-------------+-------+-------+-------------------+---------+---------+-------+------+-------+
| id | select_type ......