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
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://ginew.blog.163.com/
½ñÌìÔĶÁ wordpress´úÂëʱ£¬·¢ÏÖÒ»¸öMYSQLµÄ¹Ø¼ü´Ê SQL_CALC_FOUND_ROWS ²é¿´ÊÖ²áºó·¢Ïִ˹ؼü´ÊµÄ×÷ÓÃÊÇÔÚ²éѯʱͳ¼ÆÂú×ã¹ýÂËÌõ¼þºóµÄ½á¹ûµÄ×ÜÊý£¨²»ÊÜ Limit µÄÏÞÖÆ£©
ÀýÈ磺 SELECT SQL_CALC_FOUND_ROWS tid from cdb_threads WHERE fid=14 LIMIT 1,10;
¼ÙÉèÂú×ãÌõ¼þµÄÓÐ1000Ìõ£¬Õâ ......
¸ãÁ˺ܾᣡ£ÖÕÓÚ·¢ÏÖÔÀ´ÊÇȨÏÞÎÊÌâ¡£¡£
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
¾µäÁË¡£¡£¡£
ħÁ¦Ë½·þÍøÒ³¶Ë¸ã¶¨¿©~~ ......
1. °²×°mysqlµÄʱºòÑ¡Ôñ×Ö·û¼¯utf8
2. °²×°½áÊøºóÐÞ¸Ämy.ini,ÓÐÁ½¸öµØ·½ÒªÐ޸ģ¬
[mysql] default-character-set=gbk
# The default character set that will be used when a new schema or table is
# created and no character set ......
ÓÉMySQLÌṩµÄģʽƥÅäµÄÆäËûÀàÐÍÊÇʹÓÃÀ©Õ¹ÕýÔò±í´ïʽ¡£µ±Äã¶ÔÕâÀàģʽ½øÐÐÆ¥Åä²âÊÔʱ£¬Ê¹ÓÃREGEXPºÍNOT REGEXP²Ù×÷·û(»òRLIKEºÍNOT RLIKE£¬ËüÃÇÊÇͬÒå´Ê)¡£ À©Õ¹ÕýÔò±í´ïʽµÄһЩ×Ö·ûÊÇ£º
“.”Æ¥ÅäÈκε¥¸öµÄ×Ö·û¡£
Ò»¸ö×Ö·ûÀà“[...]”Æ¥ÅäÔÚ·½À¨ºÅÄÚµÄÈκÎ×Ö·û¡£ÀýÈ磬“[abc]”ƥŠ......
ÐÞ¸ÄMySQL 5.1 dataÎļþ¼Ð·¾¶
ÎÒ°²×°µÄÕâ¸ö°æ±¾µÄMYSQLûÓÐdataÎļþ¼Ð£¬µ«ÊÇ¿ÉÒÔÕý³£Ê¹Ó㬲»ÖªµÀÄãÃǵÄÓÐûÓÐÄØ£¿Ôõô²Å¿ÉÒÔ³öÏÖdataÎļþ¼ÐÄØ£¬Ã»ÓÐdataÎļþ¼Ð£¬ÄÇÎÒµÄÊý¾Ý¿âÎļþ´æ·ÅÔÚʲôµØ·½ÁËÄØ£¿ÎÒËÑË÷ÁËÕû¸öµçÄÔ¶¼Ã»ÓÐÕÒµ½¡£
ºÃÐĵÄÅóÓÑ£¬¿ì¸æËßÎÒÔõô»ØÊ£¿¸ÃÔõô½â¾ö£¿
ллÁË£¡£¡£¡
====================== ......