Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

mysql+phpÎÞ·¨Á¬½Ósql£¨Òѽâ¾ö£©

¸ãÁ˺ܾᣡ£ÖÕÓÚ·¢ÏÖÔ­À´ÊÇȨÏÞÎÊÌâ¡£¡£
2ÐÐÃüÁî¸ã¶¨
grant all privileges on rogue.* to admin@localhost identified by 'admin' with grant option
grant all privileges on rogue.* to admin@'%' identified by 'admin' with grant option
¾­µäÁË¡£¡£¡£
ħÁ¦Ë½·þÍøÒ³¶Ë¸ã¶¨¿©~~ ......

MySQL5.1ÄÚ±íתµ½MS SQL£¬±í½á¹¹Ó¦ÈçºÎÉèÖã¿

# MySQL-Front 5.1  (Build 4.2)
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */ ......

mySqlÖÐÈçºÎÅúÁ¿¸üмÆÊýÆ÷


¼ÙÈçÎÒÃǵÄmysqlÓÐÒ»¸ö¼ÆÊýÆ÷£¬¶øÕâ¸ö¼ÆÊýÆ÷ÐèÒªÎÒÃÇÖØÐÂͳ¼Æ£¬Ôõô°ìÄØ£¿
Ó¦Óó¡¾°£¬±ÈÈç˵ÓÐÒ»¸öÉ̳¡£¬Ã¿ÂôÒ»¸ö²úÆ·¶¼²úÉúÒ»¸öÁ÷Ë®£¬È»ºóÎÒÃÇÐèÒªÖªµÀÿ±ÊÁ÷Ë®ÊǸòúÆ·µÚ¼¸´Î³öÊ۵ģ¬ÕâÑù˵¿ÉÄܲ»Ã÷°×£¬ÎÒÄÃÒ»¸öÏêϸµÄÊý¾Ý
¾ÙÀý°É¡£
recordID,productID,productType,sellDate,counter
1, 1, 1, '2010-1-15 15:20:10 ......

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ºÅ