ͬ²½Æô¶¯Ñ¡Ïî(mysql ͬ²½)
²»¹ÜÊÇmaster»¹ÊÇslave£¬¶¼ÒªÉ趨 server-id Ñ¡ÏîÀ´È·¶¨Ê¹ËüÃǶ¼Óи÷×ÔΨһµÄͬ²½ID¡£±ØÐëÑ¡Ôñ 1 µ½ 2^32-1 Ö®¼äµÄÕýÕûÊý¡£ÀýÈ磺 server-id=3¡£
¹ØÓÚmaster·þÎñÆ÷ÉÏ¿ÉÓÃÓÚ¿ØÖƶþ½øÖÆÈÕÖ¾¼Ç¼µÄÑ¡ÏîÏêϸÃèÊöÇë¿´"5.9.4 The Binary Log"¡£
ϱíÃèÊöÁËslaveͬ²½¿ÉÓõÄÑ¡Ï¿ÉÒÔÔÚÃüÁîÐлòÕßÅäÖÃÎļþÖÐÉ趨ËüÃÇ¡£
һЩslaveͬ²½Ñ¡ÏîÒÔÌØ¶¨µÄ·½Ê½À´´¦Àí£¬ÔÚslaveÆô¶¯Ê±£¬Èç¹û´æÔÚ `master.info` Îļþ²¢ÇÒ°üº¬ÕâЩѡÏÄÇôslave½«ÂÔ¹ýËüÃÇ¡£ÕâЩѡÏîÈçÏ£º
--master-host
--master-user
--master-password
--master-port
--master-connect-retry
´ÓMySQL 4.1.1¿ªÊ¼£¬Ò»ÏÂÑ¡ÏîÒ²°´ÕÕÉÏÊö·½Ê½ÌØÊâ´¦Àí£º
--master-ssl
--master-ssl-ca
--master-ssl-capath
--master-ssl-cert
--master-ssl-cipher
--master-ssl-key
ÔÚMySQL 4.1.1ÖУ¬ `master.info` ÎļþµÄ¸ñʽ¸Ä±äÁËÒÔ°üº¬ÏàÓ¦µÄSSLÑ¡Ïî¡£ÁíÍ⣬MySQL 4.1.1Îļþ¸ñʽ»¹°üÀ¨ÁËÔÚµÚÒ»ÐÐÖеÄÎļþ×ÜÐÐÊý¡£Èç¹û´Ó¾É°æ±¾Éý¼¶µ½4.1.1£¬ÄÇô·þÎñÆ÷Æô¶¯Ê±»á×Ô¶¯Éý¼¶ `master.info` Ϊеĸñʽ¡£²»¹ý£¬Èç¹ûÊÇ´Ó4.1.1½µ¼¶µ½¾É°æ±¾£¬¾ÍÐèÒªÔÚϵͳµÚÒ»´ÎÆô¶¯Ê±ÊÖ¹¤É¾³ýÎļþµÄµÚÒ»ÐС£×¢Ò⣬ÕâÖÖÇé¿öÏ£¬±»½µ¼¶µÄ·þÎñÆ÷¾Í²»ÄÜÔÙʹÓÃSSLÑ¡ÏîÁ¬½Óµ½masterÁË¡£
slaveÆô¶¯Ê±Èç¹û²»´æÔÚ `master.info` Îļþ£¬Ëü¾ÍʹÓÃÔÚÃüÁîÐлòÕßÅäÖÃÎļþÖÐÖ¸¶¨µÄ²ÎÊýÖµÀ´Æô¶¯¡£ÕâÔÚÿ´ÎµÚÒ»´ÎÆô¶¯slave·þÎñÆ÷ʱ¶¼ÊÇÕâÑù£¬»òÕßÖ´ÐÐ RESET SLAVE Óï¾ä¹Ø±ÕÇÒÖØÆôslaveÖ®ºó¡£
slaveÆô¶¯Ê±Èç¹û´æÔÚ `master.info` Îļþ£¬ÄÇôËü¾ÍÂÔ¹ýÕâЩѡÏ¶øÊÇÖ±½Ó¶ÁÈ¡ `master.info` ÎļþÖеÄÖµ¡£
Èç¹ûÖØÆôsalveʱʹÓõÄÑ¡ÏîÖµºÍ `master.info` ÖеIJ»Ò»Ñù£¬ÄÇôÕâ¸öеÄÖµ²»»áÉúЧ£¬ÒòΪslave·þÎñÆ÷»¹ÊÇÕÕÑùÖ»¶ÁÈ¡ `master.info` Îļþ¡£ÏëҪʹÓò»Í¬µÄÑ¡ÏîÖµ£¬¿ÉÒÔÔÚɾ³ý `master.info` ºóÖØÆôslave»òÕßʹÓà CHANGE MASTER TO Óï¾ä(ÍÆ¼ö)ÖØÖÃÑ¡ÏîÖµ¡£
¼Ù¶¨ÔÚ `my.cnf` É趨ÁËÒÔÏÂÑ¡ÏîÖµ£º
[mysqld]
master-host=some_host
µÚÒ»´ÎÆô¶¯slaveµÄʱºò£¬Ëü´Ó `my.cnf` ÖжÁȡѡÏîÖµ£¬È»ºóÔÙ°ÑËüÃDZ£´æÔÚ `master.info` ÖС£Ï´ÎÖØÆôslaveʱ£¬Ëü¾ÍÖ»¶ÁÈ¡ `master.info` µÄÄÚÈݶøÂÔ¹ý `my.cnf` ÖеÄÑ¡ÏîÖµÁË¡£ÆóͼÐÞ¸Ä `my.cnf` À´¸Ä±äͬ²½Ñ¡ÏîÊDz»¿ÉÐе쬲»¹ý¿ÉÒÔͨ¹ýÖ´ÐÐ CHANGE MASTER TO Óï¾äÀ´ÊµÏÖ£º
ÓÉÓÚ·þÎñÆ÷ÈÏΪ `master.info` µÄÓÅÏȼ¶±ÈÅäÖÃÎļþ¸ß£¬Òò´Ë½¨Òé¸ù±¾²»ÒªÔÚÆô¶¯Ê±¸½¼Óͬ²½Ñ¡Ï¶øÖ»Óà CHANGE MASTER TO Óï¾ä¡£Ïê
Ïà¹ØÎĵµ£º
×Ö¶ÎpageNum
1£¬6£¬9£¬11
Ï£ÍûÅÅÐò˳ÐòΪ1£¬6£¬9£¬11
µ«ÊÇʵ¼ÊÅÅÐòΪ1£¬11£¬6£¬9
ºóÀ´·¢ÏÖÊÇÒòΪpageNumÕâ¸ö×Ö¶ÎÊÇvarcharÀàÐ͵IJ»ÊÇintÐÍ£¬ËùÒÔÅÅÐò»á³öÎÊÌâ¡£
ÍøÉϵĽâ¾ö·½·¨Îª
order by pageNum+0
order by pageNum×1
²»ÖªµÀΪʲôorder by pageNum×1 Êý¾Ý¿âͨ²»¹ý
µ«ÊÇpageNum+0ÊǺÃÓÃµÄ ......
½øÈëcmd
===================
1.µ¼³öÊý¾Ý¿â£¨sql½Å±¾£©
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u root -p db_name > test_db.sql
¡¡¡¡2.mysqlµ¼³öÊý¾Ý¿âÒ ......
1. ÓÃcmd½øÈëmysql/binĿ¼
2. ÊäÈëmysqld-nt --skip-grant-tables
3. ÐÂÆôcmd ÊäÈëmysqladmin -u root flush-privileges password root
4. mysqladmin -u root -p shutdown
5. ÊäÈëеÄÃÜÂ룺XXX
6.ÐÞ¸ÄÃÜÂë³É¹¦ ......
ÔÚmysqlÖÐÖ´ÐÐsqlÎļþ£¨Èçtest.sql£©µÄ³£Ó÷½·¨
ΪÁË·½±ã£¬¿ÉÒÔ½«mysqlµÄ°²×°Â·¾¶ÏÂbinĿ¼µÄµØÖ··Åµ½»·¾³±äÁ¿PATHÖУ¬Èç;C:\Program Files\MySQL\MySQL Server 5.0\bin¡£ÕâÑùÔÚÈÎÒâλÖôò¿ªµÄÃüÁîÐгÌÐò¶¼ÄÜÕÒµ½mysql.exe¡£
¿ÉÒÔ´ò¿ªmysqlÃüÁîÐУ¬Ò²¿ÉÒÔÔÚÃüÁîÐÐÖÐͨ¹ýmysql -u r ......
THREAD_CACHE MySQLÀïÃæÎªÁËÌá¸ß¿Í»§¶ËÇëÇó´´½¨Á¬½Ó¹ý³ÌµÄÐÔÄÜ,ÌṩÁËÒ»¸öÁ¬½Ó³ØÒ²¾ÍÊÇThread_Cache³Ø,½«¿ÕÏеÄÁ¬½ÓÏ̷߳ÅÔÚÁ¬½Ó³ØÖÐ,¶ø²»ÊÇÁ¢¼´Ïú»Ù.ÕâÑùµÄºÃ´¦¾ÍÊÇ,µ±ÓÖÓÐÒ»¸öеÄÇëÇóµÄʱºò,mysql²»»áÁ¢¼´È¥´´½¨Á¬½ÓÏß³Ì,¶øÊÇÏÈÈ¥Thread_CacheÖÐÈ¥²éÕÒ¿ÕÏеÄÁ¬½ÓÏß³Ì,Èç¹û´æÔÚÔòÖ±½ÓʹÓÃ,²»´æÔڲŴ´½¨ÐµÄÁ¬½ÓÏß³Ì. ÓÐ ......