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

MySQL Master Slave Replication

MySQL±¾ÉíûÓÐÌṩreplication failoverµÄ½â¾ö·½°¸(¼ûHow can I use replication to provide redundancy or high availability?)
ÈçºÎʹReplication·½°¸¾ßÓÐHA£¿
´ð°¸ÊÇMMM(MySQL Master-Master Replication Manager)
MMM¶ÔMySQL Master-Slave Replication¾ø¶ÔÊÇÒ»¸öºÜÓÐÒæµÄ²¹³ä!
ÒýÑÔ
Master-SlaveµÄÊý¾Ý¿â»ú¹¹½â¾öÁ˺ܶàÎÊÌâ£¬ÌØ±ðÊÇread/write±È½Ï¸ßµÄweb2.0Ó¦Óãº
1¡¢Ð´²Ù×÷È«²¿ÔÚMaster½áµãÖ´ÐУ¬²¢ÓÉSlaveÊý¾Ý¿â½áµã¶¨Ê±(ĬÈÏ60s)¶ÁÈ¡MasterµÄbin-log
2¡¢½«ÖÚ¶àµÄÓû§¶ÁÇëÇó·ÖÉ¢µ½¸ü¶àµÄÊý¾Ý¿â½Úµã£¬´Ó¶ø¼õÇáÁ˵¥µãµÄѹÁ¦
ÕâÊǶÔReplicationµÄ×î»ù±¾³ÂÊö£¬ÕâÖÖģʽµÄÔÚϵͳScale-out·½°¸ÖкÜÓÐÒýÁ¦(ÈçÓбØÒª£¬Êý¾Ý¿ÉÒÔÏȽøÐÐSharding£¬ÔÙʹÓÃreplication)¡£
ËüµÄȱµãÊÇ£º
1¡¢SlaveʵʱÐԵı£ÕÏ£¬¶ÔÓÚʵʱÐԺܸߵij¡ºÏ¿ÉÄÜÐèÒª×öһЩ´¦Àí
2¡¢¸ß¿ÉÓÃÐÔÎÊÌ⣬Master¾ÍÊÇÄǸöÖÂÃüµã([url="http://en.wikipedia.org/wiki/Single_point_of_failure "]SPOF:Single point of failure[/url])
±¾ÎÄÖ÷ÒªÌÖÂÛµÄÊÇÈçºÎ½â¾öµÚ2¸öȱµã¡£
DBµÄÉè¼Æ¶Ô´ó¹æÄ£¡¢¸ß¸ºÔصÄϵͳÊǼ«ÆäÖØÒªµÄ¡£¸ß¿ÉÓÃÐÔ([url="http://en.wikipedia.org/wiki/High_availability "]High availability[/url])ÔÚÖØÒªµÄϵͳ(critical System)ÊÇÐèÒª¼Ü¹¹Ê¦ÊÂÏÈ¿¼Âǵġ£´æÔÚ[url="http://en.wikipedia.org/wiki/Single_point_of_failure "]SPOF:Single point of failure[/url]µÄÉè¼ÆÔÚÖØÒªÏµÍ³ÖÐÊÇΣÏյġ£
Master-Master Replication
1¡¢Ê¹ÓÃÁ½¸öMySQLÊý¾Ý¿âdb01,db02£¬»¥ÎªMasterºÍSlave£¬¼´£º
Ò»±ßdb01×÷Ϊdb02µÄmaster£¬Ò»µ©ÓÐÊý¾ÝдÏòdb01ʱ£¬db02¶¨Ê±´Ódb01¸üÐÂ
ÁíÒ»±ßdb02Ò²×÷Ϊdb01µÄmaster£¬Ò»µ©ÓÐÊý¾ÝдÏòdb02ʱ£¬db01Ò²¶¨Ê±´Ódb02»ñµÃ¸üÐÂ
(Õâ²»»áµ¼ÖÂÑ­»·£¬MySQL SlaveĬÈϲ»»á¼Ç¼Masterͬ²½¹ýÀ´µÄ±ä»¯)
2¡¢µ«´ÓAppServerµÄ½Ç¶ÈÀ´Ëµ£¬Í¬Ê±Ö»ÓÐÒ»¸ö½áµãdb01°çÑÝMaster£¬ÁíÍâÒ»¸ö½áµãdb02°çÑÝSlave£¬²»ÄÜͬʱÁ½¸ö½áµã°çÑÝMaster¡£¼´AppSever×ÜÊǰÑwrite²Ù×÷·ÖÅäij¸öÊý¾Ý¿â(db01)£¬³ý·Çdb01 failed£¬±»Çл»¡£
3¡¢Èç¹û°çÑÝSlaveµÄÊý¾Ý¿â½áµãdb02 FailedÁË£º
a)´ËʱappServerÒªÄܹ»°ÑËùÓеÄread,write·ÖÅ䏸db01£¬read²Ù×÷²»ÔÙÖ¸Ïòdb02
b)Ò»µ©db02»Ö¸´¹ýÀ´ºó£¬¼ÌÐø³äµ±Slave½ÇÉ«£¬²¢¸æËßAppServer¿ÉÒÔ½«read·ÖÅ䏸ËüÁË
4¡¢Èç¹û°çÑÝMasterµÄÊý¾Ý¿â½áµãdb01 FailedÁË
a)´ËʱappServerÒªÄܹ»°ÑËùÓеÄд²Ù×÷´Ódb01Çл»·ÖÅ䏸db02£¬Ò²¾ÍÊÇ


Ïà¹ØÎĵµ£º

MySQLÊý¾Ý¿âÈÕÖ¾

MySQLÊý¾Ý¿âÈÕÖ¾
selectÈÕÖ¾
slow selectÈÕÖ¾
±ä¸üÈÕÖ¾
¶þ½øÖƱä¸üÈÕÖ¾(binlog)
¸æ¾¯ÈÕÖ¾
´íÎóÈÕÖ¾¡£
¿ÉÒÔÔÚmy.cnfÖÐÅäÖÃ
²ÎÊý
˵Ã÷
log
Îı¾selectÈÕÖ¾£¬¼ÇÏÂËùÓеÄMySQLµÄÃüÁî²Ù×÷£¬
log-update
Îı¾±ä¸üÈÕÖ¾
log-bin
Õâ¸ö¶¼ÖªµÀÁË£¬Êý¾Ý¿â¸´ÖƵÄʱºò±Ø±¸
binlog_cache_size
ÁÙʱ´æ·Åij´ÎÊÂÎñµÄSQL ......

MySQLÊý¾Ý¿ârootȨÏÞ¶ªÊ§½â¾ö·½°¸

MySQLÊý¾Ý¿ârootȨÏÞ¶ªÊ§½â¾ö·½°¸
Ò»Ì첻СÐİÑROOTµÄȨÏ޸ĵ½×îСÁË(Ö»ÄܵǼ,ʲô¶¼×ö²»ÁË),Õâ¿É¼±ËÀÎÒÁË.֨װµÄ»°Ì«Âé·³£¬¶øÇÒÀïÃæÓкܶàµÄÓû§£¬Ò»¸ö¸öÖØÐÂŪ²»ÖªµÀµ½Ê²Ã´Ê±ºò¡£
ºóÀ´ÎÒÏëÁËÒ»¸ö°ì·¨£¬ÏȰѵ±Ç°·þÎñÆ÷µÄMySQL·þÎñÍ£Ö¹£¬°ÑMySQL DATaĿ¼ÏµÄmysqlĿ¼¸ÄÃûΪmysql_OLD,µ½ÁíÒ»¸ö·þÎñÆ÷ϰÑmysqlĿ¼ÏµÄ/ ......

¸ßÐÔÄÜMySQLѧϰ±Ê¼Ç(¶þ)

 Ç°×ºË÷Òý
(1)Èç¹ûÒÔ¶à¸ö×Ö¶Î×÷ΪË÷Òý£¨a,b£¬c)×÷Ϊһ¸ökey,ÔÚ²éѯʱ·Ö¸ù¾ÝÆ¥ÅäÇé¿öÊÇ·ñʹÓÃË÷Òý£¬ËùÒÔ£¬a/ a,b/ a,b,cÕâÑùµÄ²éѯ¶¼ÄÜʹÓõ½£¬µ«ÊÇb,a/a,c/c,aµÈ²»·û֪ǰ׺ƥÅä¾Í²»ÄÜʹÓã¬ËùÒÔÔÚдsqlʱÐèҪעÒâ
(2)¶ÔÓںܳ¤µÄ×Ö·û´®ÐèÒªÉú³Ékeyʱ£¬¿ÉÒÔÕÒ³ö×ʹÓõÄ×Ö·û´®µÄ×î³£¼ûǰ׺(ǰN¸ö×ÖÌõ×÷Ϊkey,¶ø²»Êǽ ......

ÔÚmysqlÊý¾Ý¿âÖÐÐÞ¸ÄrootµÄÃÜÂë

ÏÂÃæÎÒ¸ø´ó¼Ò½éÉܼ¸ÖÖÔÚmysqlÊý¾Ý¿âÖÐÐÞ¸ÄrootÃÜÂëµÄ·½·¨
·½·¨Ò»£º
ԭʼÃÜÂëÊÇ ckh
mysql -uroot -pckh
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.22-community-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
my ......

phpÁ¬½Ómysql²âÊÔºÍÅäÖÃ


phpÁ¬½Ómysql²âÊÔ´úÂ룺
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "ʧ°Ü!";
else echo "³É¹¦!";
mysql_close();
?>
ÔËÐдúÂë³öÏÖ£ºCall   to   undefined   function   'mysql_connect()'… ʧ°Ü
°Ù¶ÈÕÒµ½½á¹ûÊÇPHP+MYSQL »·¾³Ã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ