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

Nginx+PHP+MySQLË«»ú»¥±¸¡¢È«×Ô¶¯Çл»·½°¸[ת]

ÔÚÉú²úÓ¦ÓÃÖУ¬Ä³Ì¨“Nginx+PHP+MySQL”½Ó¿ÚÊý¾Ý·þÎñÆ÷£¬°çÑݵĽÇɫʮ·ÖÖØÒª£¬Èç¹û·þÎñÆ÷Ó²¼þ»òNginx¡¢MySQL·¢Éú¹ÊÕÏ£¬¶ø¶Ìʱ¼äÄÚÎÞ·¨»Ö¸´£¬ºó¹û½«·Ç³£ÑÏÖØ¡£ÎªÁ˱ÜÃâµ¥µã¹ÊÕÏ£¬ÎÒÉè¼ÆÁË´ËÌ×·½°¸£¬±àдÁËfailover.sh½Å±¾£¬ÊµÏÖÁËË«»ú»¥±¸¡¢È«×Ô¶¯Çл»£¬¹ÊÕÏ×ªÒÆÊ±¼äÖ»Ð輸ʮÃë¡£
¡¡¡¡Ò»¡¢Ë«»ú»¥±¸¡¢È«×Ô¶¯Çл»·½°¸£º
¡¡¡¡1¡¢ÍØÆËͼ£º
 
¡¡¡¡
  
¡¡¡¡2¡¢½âÊÍ£º
¡¡¡¡(1)¡¢¼ÙÉèÍâÍøÓòÃûblog.s135.com½âÎöµ½ÍâÍøÐéÄâIP 72.249.146.214ÉÏ£¬ÄÚÍøhostsÉèÖÃdb10¶ÔÓ¦ÄÚÍøÐéÄâIP 192.168.146.214
¡¡¡¡(2)¡¢Ä¬ÈÏÇé¿öÏ£¬ÓÉÖ÷»ú°ó¶¨ÄÚ¡¢ÍâÍøÐéÄâIP£¬±¸»ú×÷Ϊ±¸·Ý£¬µ±Ö÷»úµÄMySQL¡¢Nginx»ò·þÎñÆ÷³öÏÖ¹ÊÕÏÎÞ·¨·ÃÎÊʱ£¬±¸»ú»á×Ô¶¯½Ó¹ÜÄÚ¡¢ÍâÍøÐéÄâIP¡£Á½Ì¨·þÎñÆ÷¶¼Æô¶¯¸ºÔð¼à¿Ø¡¢×Ô¶¯Çл»ÐéÄâIPµÄÊØ»¤½ø³Ì/usr/bin/nohup /bin/sh /usr/local/webserver/failover/failover.sh 2>&1 > /dev/null &
¡¡¡¡(3)¡¢Ö÷»úºÍ±¸»úÉϵÄMySQL·þÎñÆ÷»¥ÎªÖ÷´Ó£¬»¥Ïàͬ²½¡£ÔÚÖ÷»ú´¦Óڻ״̬£¨¼´ÓÉÖ÷»ú°ó¶¨ÐéÄâIP£©Ê±£¬¶ÁдÖ÷»úµÄMySQL£¬Ð´µ½Ö÷»úµÄÊý¾Ý»áͬ²½µ½±¸»ú£»ÔÚ±¸»ú´¦Óڻ״̬ʱ£¬¶Áд±¸»úµÄMySQL£¬Ð´µ½±¸»úµÄÊý¾Ý»áͬ²½µ½Ö÷»ú£¨Èç¹ûÖ÷»úÉϵÄMySQLËÀµôÔÝʱÎÞ·¨Í¬²½£¬Ö÷»úÉϵÄMySQL»Ö¸´ºó£¬Êý¾Ý»á×Ô¶¯´Ó±¸»úÉÏͬ²½¹ýÀ´£¬·´Ö®ÒàÈ»£©¡£
¡¡¡¡(4)¡¢Ö÷»ú´¦Óڻ״̬ʱ£¬Ã¿20Ãë»á°Ñ/data0/htdocs/£¨ÍøÒ³¡¢³ÌÐò¡¢Í¼Æ¬´æ·ÅĿ¼£©¡¢/usr/local/webserver/php/etc/£¨php.iniµÈÅäÖÃÎļþĿ¼£©¡¢/usr/local/webserver/nginx/conf/£¨NginxÅäÖÃÎļþĿ¼£©Èý¸öĿ¼ÏµÄÎļþͨ¹ýrsyncÍÆË͵½±¸»ú·þÎñÆ÷ÉϵĶÔӦĿ¼£¨ÔöÁ¿ÍÆËÍ£¬Á½Ì¨·þÎñÆ÷ÉÏÒ»ÑùµÄÎļþ²»»áÖØ¸´ÍÆËÍ£©£¬·´Ö®Èç¹û±¸»ú´¦Óڻ״̬ʱ£¬Ã¿20Ãë»á³¢ÊÔ°ÑÎļþÍÆË͵½Ö÷»ú¡£rsyncµÄÅäÖÃÎļþ¼ûÁ½Ì¨·þÎñÆ÷µÄ/etc/rsyncd.conf£¬rsyncÊØ»¤½ø³ÌµÄÆô¶¯ÃüÁîΪrsync --daemon
¡¡¡¡3¡¢×Ô¶¯Çл»Á÷³Ì
¡¡¡¡(1)¡¢Ö÷»úĬÈϰó¶¨ÄÚ¡¢ÍâÍøÐéÄâIP£¬µ±Ö÷»úµÄMySQL¡¢NginxÎÞ·¨·ÃÎÊ»ò·þÎñÆ÷å´»ú£¬Ö÷»úÉϵÄfailover.shÊØ»¤½ø³Ì»á×Ô¶¯Õª³ý×Ô¼º°ó¶¨µÄÄÚ¡¢ÍâÍøÐéÄâIP£¨Èç¹ûÖ÷»úÉϵÄfailover.shËÀµô£¬ÎÞ·¨Õª³ý×Ô¼º°ó¶¨µÄÐéÄâIPҲû¹ØÏµ£©£¬±¸»úÉϵÄfailover.shÊØ»¤½ø³Ì»á×Ô¶¯½Ó¹Ü±¸»úÔ­À´°ó¶¨µÄÄÚ¡¢ÍâÍøÐéÄâIP£¬²¢·¢ËÍARPing°ü¸øÄÚ¡¢ÍâÍøÍø¹Ø¸üÐÂMAC£¬Ç¿Ðнӹܡ£
¡¡¡¡(2)¡¢±¸»ú°ó¶¨ÐéÄâIPºó£¬»á·¢ËÍARPing°ü¸øÄÚ¡¢ÍâÍøÍø¹Ø£¬Í¨ÖªÍø¹Ø¸üÐÂÐéÄâIPµÄMACµØÖ·Îª±¸»úµÄMACµØÖ·£¬´Ó¶ø±£Ö¤ÁËÇл»ºóÄܹ»Í¨¹ýÐéÄâIP¼°Ê


Ïà¹ØÎĵµ£º

Ô¶³ÌÁ¬½Ó MySQL l×ÊÁÏ zz


Ô¶³ÌÁ¬½Ómysql×ÊÁÏ
Ô¶³ÌÁ¬½Óµ½mysqlÐèÒª×öµÄ£º
1¡¢½øÈëmysql£¬´´½¨Ò»¸öÐÂÓû§xuys£º
¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿âÃû.±íÃû Óû§@µÇ¼Ö÷»ú identified by "Óû§ÃÜÂë";
grant select,update,insert,delete on *.* to xuys@192.168.88.234 identified by "xuys1234";
²é¿´½á¹û£¬Ö´ÐУº
   use mysql;
 & ......

PHPº¯ÊýµÄ¶¨ÒåÓëʹÓÃ

Ô­ÎÄÁ´½Ó£ºhttp://www.phpdo.net/index.php/2010/02/10/1-13/
PHPÖÐÒ»¸ö»ù±¾µÄ½Å±¾ÓÉÁ½²¿·Ö×é³É£ºÖ÷³ÌÐòºÍº¯Êý¡£
º¯Êý²»½ö¿ÉÒÔ¹¹³ÉÒ»¸öPHP½Å±¾µÄ»ù±¾¹¦ÄÜ£¬Ò²Ê¹µÃ³ÌÐò½á¹¹»¯£¬ÓÐÖúÓÚ³ÌÐò´úÂëµÄÖØÓá£
PHPº¯ÊýµÄµ÷ÓÃ
ͨ¹ý°´ÕÕº¯Êý¸ñʽд³öº¯ÊýÒÔ¼°ÏàÓ¦µÄ²ÎÊý¼´¿É£¬ÒÂÓï·¨ÈçÏ£º
String¡¡substr(string¡¡str,int¡¡start) ......

php tips

5.¹ØÓÚ±íµ¥Ë¢ÐÂ
ÎÊ£ºÎªÊ²Ã´ÎÒÔÚµã»÷ä¯ÀÀÆ÷µÄºóÍ˰´Å¥ºó£¬ËùÓÐ×ֶεÄÐÅÏ¢¶¼±»Çå¿ÕÁË£¿
´ð£ºÕâÊÇÓÉÓÚÄãÔÚÄãµÄ±íµ¥Ìá½»Ò³ÃæÖÐʹÓÃÁË session_start º¯Êý¡£¸Ãº¯Êý»áÇ¿ÖÆµ±Ç°Ò³Ãæ²»±»»º´æ¡£½â¾ö°ì·¨Îª£¬ÔÚÄãµÄ Session_start º¯Êýºó¼ÓÈë header("Cache-control: private"); ×¢ÒâÔÚ±¾ÐÐ֮ǰÄãµÄPHP³ÌÐò²»ÄÜÓÐÈκÎÊä³ö¡£
²¹³ä£º ......

MYSQL ɾ³ýͬһ±íÖÐÖØ¸´¼Ç¼

MYSQL ɾ³ýͬһ±íÖÐÖØ¸´¼Ç¼
CREATE TABLE `user` (
  `db_id` varchar(255) NOT NULL,
  `name` varchar(45) default NULL,
  `age` int(10) unsigned NOT NULL,
  `address` varchar(45) default NULL,
  PRIMARY KEY  (`db_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 &nb ......

ÐÞ¸ÄmysqlµÄrootÃÜÂëµÄ¼¸ÖÖ·½·¨

http://www.xiaojb.com/archives/it/mysqlroot.shtml
Method 1:
ÔÚ/usr/local/mysql/bin/Ï£º
./mysqladmin -u root password ‘new_password’
Ò»°ã°²×°Ê±Óô˷½·¨ÉèÖá£
Method 2:
ÔÚmysql״̬Ï£º
mysql>UPDATE user SET password=PASSWORD(’new_password’) WHERE user=’root&rsq ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ