MySQLÊý¾Ý¿â¸´ÖÆMaster Master Slave¼Ü¹¹
ÎÒÃÇÓÃMaster-Slaves¼Ü¹¹½â¾öÁ˶ÁѹÁ¦±È½Ï´óµÄÓ¦Ó㬶øÎÒÃÇÓÃMaster-Master¼Ü¹¹½â¾öÁ˵¥µã·þÎñÎÊÌ⣬ÌṩÁËϵͳµÄ¿ÉÓÃÐÔ¡£µ«ÊÇÓÐʱÎÒÃÇÃæÁÙ¾Þ´óµÄ¶ÁÊý¾ÝѹÁ¦£¬ÌرðÊÇwebϵͳ£¬ÓÖÐèÒª½â¾öµ¥µã·þÎñµÄÎÊÌ⣬ΪӦÓÃÌṩ×ã¹»¸ßµÄ¿ÉÓÃÐÔ¡£ÕâʱÎÒÃǾÍÐèÒª½«ÕâÁ½Öּܹ¹½áºÏÆðÀ´¡£Õâ¾ÍÊÇMaster-Master-Slaves¼Ü¹¹¡£½á¹¹Í¼ÈçÏÂ
Master×éµÄ·þÎñÆ÷µÄÖ÷ÒªÌØµã£º
1. ¸ºÔðÓ¦Óÿͻ§¶ËµÄдÊý¾Ý´¦Àí¡£
2. ½â¾öµ¥µã·þÎñµÄ·½°¸£¬Ìá¸ß¿ÉÓÃÐԵķ½°¸¡£
3. ×÷Ϊslave×é·þÎñÆ÷µÄ¸´ÖÆÊý¾ÝÔ´¡£
Slave×éµÄ·þÎñÆ÷µÄÌØµã£º
1. ¸ºÔðÓ¦Óÿͻ§¶ËµÄ¶ÁÊý¾Ý´¦Àí¡£
2. ·Öµ£Ó¦ÓÃϵͳǿ´óµÄ¶ÁÊý¾ÝѹÁ¦¡£
3. ±£³ÖÓëmaster×éµÄÊý¾ÝÒ»Ö¡£
Ïà¹ØÎĵµ£º
ΪÁËÓ¦ÓÃϵͳµÄ¿ÉÉìËõÐÔ£¬ÍùÍùÐèÒª¶ÔÊý¾Ý¿â½øÐÐscale outÉè¼Æ£¬scale outÉè¼ÆÒ²¾ÍÊÇͨ¹ýÔö¼ÓÊý¾Ý¿â´¦Àí½ÚµãÀ´Ìá¸ßϵͳÕûÌåµÄ´¦ÀíÄÜÁ¦£¬¼´Ôö¼ÓÊý¾Ý¿â·þÎñÆ÷µÄÊýÁ¿À´·Öµ£Ñ¹Á¦¡£Í¨¹ýÕâÖÖ·½Ê½ÏµÍ³µÄÉìËõÐÔÔöÇ¿ÁË£¬³É±¾Ò²½µµÍÁË£¬µ«ÊÇϵͳµÄ¼Ü¹¹¸ºÔðÁË£¬Î¬»¤À§ÄÑÁË¡£ÄÑÃâ³öÏÖϵͳµÄå´»ú»ò¹ÊÕÏ¡£Òò´Ë£¬ÀíÂÛÉÏÀ´Ëµ£¬ÏµÍ³µÄ°²È«ÐÔ£¨ ......
¹Ø¼ü×Ö: key×Ö¶ÎÊÇmysqlÀïÃæµÄ¹Ø¼ü×Ö
insert into app(name,created,key,secret,masterSecret) values ('aa',null,null,null,null);
ÒòΪÕâÀïµÄkey×Ö¶ÎÊÇmysqlµÄ¹Ø¼ü×Ö£¬ËùÒÔÒ»Ö±²å²»½øÈ¥¡£
ÐÞ¸ÄÈçÏÂ:ÔÚkeyµÄÍ·ÉϼÓÉÏÁ½µã(·´ÒýºÅ£¬ËüÔÚ¼üÅ̵Ä~Õâ¸ö¼üÉÏ)¡£¼´¿É¸ã¶¨
sql½¨±íÈçÏ£º
Java´úÂë
CREATE T ......
1)
°²×°Apache/2.2.14 ºÍ PHP/5.2.12 Ö®ºó£¬ÖØÐÂÆô¶¯Apache£¬Æô¶¯Ê§°Ü¡£²éÁËһЩ×ÊÁÏ£¬»ù±¾Éϸø³öµÄ½¨ÒéÊǽûµôExtension¡£ÎÒ¾Í×°ÁËÒ»¸öExtesion Mysqli¡£
ÐÞ¸Äphp.ini ×¢Ê͵ôÕâÒ»ÐУ¬¹ûÈ»ÉúЧ¡£
[PHP_MYSQLI]
;extension=php_mysqli.dll
°²×°Íêmysql£¬ÔÙÖØÐÂenableÕâ¸öÅäÖþͺÃÁË£¬¹À¼ÆÊÇÒÀÀµÄ³Ð©mysqlµÄ¿â¡£
......
ÆäʵÈç¹ûÄã·þÎñÆ÷ÖØÐ°²×°ÁË,Ò²²»±ØÖØÐ°²×°mysql ¼¸¸öСÃüÁî¾Í¸ã¶¨ÁË
Ê×ÏÈÊǰ²×°mysql·þÎñ:
mysql-nt –install
net start mysql
µ±È»Ó´ÔÚbinĿ¼ÔËÐÐÕâ¸öÃüÁîÁË
Ð¶ÔØµÄÃüÁîÊÇ:
net stop "MySQL"
mysqld-nt.exe –remove "MySQL"
ΪʲôÓеÄÅóÓÑÐ¶ÔØ²»ÁËÄØ,ÒòΪËûÒѾ°ÑÔ´Îļþ¶¼É¾³ýÁË »òÕßÔËÐÐÐ ......