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

MySQLÊý¾Ý¿â¸´ÖÆMaster Master Slave¼Ü¹¹

ÎÒÃÇÓÃMaster-Slaves¼Ü¹¹½â¾öÁ˶ÁѹÁ¦±È½Ï´óµÄÓ¦Ó㬶øÎÒÃÇÓÃMaster-Master¼Ü¹¹½â¾öÁ˵¥µã·þÎñÎÊÌ⣬ÌṩÁËϵͳµÄ¿ÉÓÃÐÔ¡£µ«ÊÇÓÐʱÎÒÃÇÃæÁÙ¾Þ´óµÄ¶ÁÊý¾ÝѹÁ¦£¬ÌرðÊÇwebϵͳ£¬ÓÖÐèÒª½â¾öµ¥µã·þÎñµÄÎÊÌ⣬ΪӦÓÃÌṩ×ã¹»¸ßµÄ¿ÉÓÃÐÔ¡£ÕâʱÎÒÃǾÍÐèÒª½«ÕâÁ½Öּܹ¹½áºÏÆðÀ´¡£Õâ¾ÍÊÇMaster-Master-Slaves¼Ü¹¹¡£½á¹¹Í¼ÈçÏÂ
Master×éµÄ·þÎñÆ÷µÄÖ÷ÒªÌØµã£º
1. ¸ºÔðÓ¦Óÿͻ§¶ËµÄдÊý¾Ý´¦Àí¡£
2. ½â¾öµ¥µã·þÎñµÄ·½°¸£¬Ìá¸ß¿ÉÓÃÐԵķ½°¸¡£
3. ×÷Ϊslave×é·þÎñÆ÷µÄ¸´ÖÆÊý¾ÝÔ´¡£
Slave×éµÄ·þÎñÆ÷µÄÌØµã£º
1. ¸ºÔðÓ¦Óÿͻ§¶ËµÄ¶ÁÊý¾Ý´¦Àí¡£
2. ·Öµ£Ó¦ÓÃϵͳǿ´óµÄ¶ÁÊý¾ÝѹÁ¦¡£
3. ±£³ÖÓëmaster×éµÄÊý¾ÝÒ»Ö¡£


Ïà¹ØÎĵµ£º

MySQLÊý¾Ý¿â¸´ÖÆMaster Slave¼Ü¹¹·ÖÎö

ΪÁËÓ¦ÓÃϵͳµÄ¿ÉÉìËõÐÔ£¬ÍùÍùÐèÒª¶ÔÊý¾Ý¿â½øÐÐscale outÉè¼Æ£¬scale outÉè¼ÆÒ²¾ÍÊÇͨ¹ýÔö¼ÓÊý¾Ý¿â´¦Àí½ÚµãÀ´Ìá¸ßϵͳÕûÌåµÄ´¦ÀíÄÜÁ¦£¬¼´Ôö¼ÓÊý¾Ý¿â·þÎñÆ÷µÄÊýÁ¿À´·Öµ£Ñ¹Á¦¡£Í¨¹ýÕâÖÖ·½Ê½ÏµÍ³µÄÉìËõÐÔÔöÇ¿ÁË£¬³É±¾Ò²½µµÍÁË£¬µ«ÊÇϵͳµÄ¼Ü¹¹¸ºÔðÁË£¬Î¬»¤À§ÄÑÁË¡£ÄÑÃâ³öÏÖϵͳµÄå´»ú»ò¹ÊÕÏ¡£Òò´Ë£¬ÀíÂÛÉÏÀ´Ëµ£¬ÏµÍ³µÄ°²È«ÐÔ£¨ ......

mysql ¹Ø¼ü×Ö keyµÄתÒå


¹Ø¼ü×Ö: key×Ö¶ÎÊÇmysqlÀïÃæµÄ¹Ø¼ü×Ö
insert into app(name,created,key,secret,masterSecret) values ('aa',null,null,null,null);
ÒòΪÕâÀïµÄkey×Ö¶ÎÊÇmysqlµÄ¹Ø¼ü×Ö£¬ËùÒÔÒ»Ö±²å²»½øÈ¥¡£
ÐÞ¸ÄÈçÏÂ:ÔÚkeyµÄÍ·ÉϼÓÉÏÁ½µã(·´ÒýºÅ£¬ËüÔÚ¼üÅ̵Ä~Õâ¸ö¼üÉÏ)¡£¼´¿É¸ã¶¨
 
sql½¨±íÈçÏ£º
Java´úÂë
CREATE T ......

Head First PHP MYSQL Ñ§Ï°Ëæ±Ê 1


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·þÎñ:
mysql-nt –install
net start  mysql
µ±È»Ó´ÔÚbinĿ¼ÔËÐÐÕâ¸öÃüÁîÁË
Ð¶ÔØµÄÃüÁîÊÇ:
net stop "MySQL"
mysqld-nt.exe –remove "MySQL"
ΪʲôÓеÄÅóÓÑÐ¶ÔØ²»ÁËÄØ,ÒòΪËûÒѾ­°ÑÔ´Îļþ¶¼É¾³ýÁË »òÕßÔËÐÐÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ