Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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ÓÃPHPµ¼ÈëMysQLÊý¾Ý¿â

ÎÒÃÇÖªµÀÓÃpowerdesignerµ¼³öµÄsqlÎļþºó׺Ϊ'.sql'£»ÓÃphpmyadminºÜÈÝÒ×µ¼ÈëMysQLÊý¾Ý¿â£¬µ«ÊÇÓÃPHPÔõôµ¼ÈëÊý¾Ý¿âÄØ?
ÎÒÓÃpowerdesignerÉè¼ÆÒ»¸öÊý¾Ý¿âºóµ¼³ösqlÎļþ£¨Ò»¸öͶƱϵͳ£©Îª'vote.sql'£»
ÎļþÄÚÈÝΪ£¨Ò»Ð©sqlÓï¾äºÍ×¢ÊÍ£©£º
        
/*======================= ......

javaÁ¬½ÓmysqlÊý¾Ý¿â

Ê×ÏÈ£¬ÒªÏÂÔØÒ»¸öÁ¬½ÓmysqlÊý¾Ý¿âµÄÇý¶¯³ÌÐò: mysql-connector-java-3.0.15-ga-bin.jar, Õâ¸öÇý¶¯³ÌÐò²»ÐèÒª×öÆäËüÅäÖÃ,Ò²¾ÍÊÇ˵£¬¶ÔÓÚmysqlÊý¾Ý¿â£¬²»±ØÏñaccess»òÕßoracleÒª½¨Á¢odbcÊý¾ÝÔ´¡£
 
Æä´Î£¬½«ÉÏÃæµÄ.jarÎļþ¼ÓÈëµ½classpath»·¾³±äÁ¿ÖС£
×îºó£¬¾ÍÊÇд´úÂë½øÐвâÊÔÁË¡£
 
Ö÷Òª´úÂëÈçÏ£º
  ......

mysql ±¸·ÝºÍ»Ö¸´²ßÂÔ

mysql ±¸·ÝºÍ»Ö¸´²ßÂÔ
ÎÄÕ·ÖÀà:Êý¾Ý¿â
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£±¾ÎÄÖ÷Òª¶ÔMyISAM±í×ö±¸·Ý»Ö¸´¡£
 
±¸·Ý²ßÂÔÒ»£ºÖ±½Ó¿½±´Êý¾Ý¿âÎļþ£¨²»ÍƼö£©
±¸·Ý²ßÂÔ¶þ£ºÊ¹ÓÃmysqlhotcopy±¸·ÝÊý¾Ý¿â£ ......

Mysql Explain Ïê½â

Òý×Ô 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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ