ÁÉ­}ºô > IT§Þ³N ¼Æ¾Ú®w > MySQL
  IT¸ê°T·j¯Á
 
IT²£«~·j¯Á
[µ{¦¡¶}µo][ºôºÞ¥@¬É][ºô¸ô¦w¥þ][¼Æ¾Ú®w§Þ³N]
[§@·~¨t²Î][¹Å»«²á¤Ñ¡P½u¤W³X½Í][¬¡°Ê¶°ÀA]
[ºë±m±MÃD][Symantec±M°Ï][­q¾\IT§Þ³N¶g¥Z]
[¶}µo½×¾Â][ºôºÞ½×¾Â][¦w¥þ½×¾Â][¼Æ¾Ú®w½×¾Â]
[§@·~¨t²Î½×¾Â][Sybase±M°Ï][IBM dW§Þ³N±M°Ï]
[¯f¬r¨D§U][¯f¬r»Pº|¬}¼½³ø][¤åÀÉ¡P·½½X¤U¸ü]

lighttpd+PHP(FAST-CGI)++MySQLªº¾Ç²ßµ§°O

µo§G®É¶¡¡G2008.07.09 04:52     ¨Ó·½¡GÁÉ­}ºô    §@ªÌ¡GKyle

¦­´NÅ¥»¡lighttpd¥[PHPªºFAST-CGI¤è¦¡©Ê¯à¤£¿ù,©â®É¶¡¸Ë¤F¤U.¥u¬O§¹¦¨¤FÀô¹Òªº¦w¸Ë,ÁÙ¨S¨ãÅé¬Ý©Ê¯à¤°»òªº!

¥H¤U¬O§Ú¸Ëlighttpd+PHP(FAST-CGI)+mysqlªº¡A¦p¦³°ÝÃD¡A½Ðµ¹§Úµû½×.

¤@¡B¥ý¦w¸ËMySQL

¦w¸Ëmysql¡A§A¥i¥H¦w¸Ë·½½X¥]¡A¤]¥i¥H¥Î½sͦnªº¡Iª½±µ¸ÑÀ£«þ¨©¤]¦æ.§Ú¥Îªº¬Oª½±µ«þ¨©½sͦnªº¡I

1.½sĶ·½½X¥]

./configure --prefix=/data2/ali --enable-assembler --enable-thread-safe-client --without-debug

make

make install

2.¥Î½sͦnªºÀ£ÁY¥]¡Iª½±µ¸ÑÀ£«þ¨©

tar zxf mysql-standard-5.0.27-linux-i686-glibc23.tar.gz

cd mysql-standard-5.0.27-linux-i686-glibc23

cp -rf mysql-standard-5.0.27-linux-i686-glibc23 /usr/local/mysql

//¥H¤U¬O¬°¤F±Ò°Ê¦h­ÓºÝ¤f

mkdir -p /data2/ali/mysql3308

mkdir -p /data2/ali/mysql3309

./scripts/mysql_install_db --ldata=/data2/ali/mysql3308

cp support-files/my-medium.cnf /data2/ali/mysql3308/my.cnf

vi /data2/ali/mysql3308/my.cnf

­×§ï¤º®e¦p¤U:

#

[mysqld]

datadir = /data2/ali/mysql3308/

port = 3308

socket = /tmp/mysql-3308.sock

#

cp /data2/ali/mysql3308/ /data2/ali/mysql3309/

vi /data2/ali/mysql3309/my.cnf

­×§ï¤º®e¦p¤U:

#

[mysqld]

datadir = /data2/ali/mysql3309/

port = 3309

socket = /tmp/mysql-3309.sock

#

±Ò°Êmysql

/usr/local/mysql/bin/mysqld_safe --defaults-file=/data2/ali/mysql3308/my.cnf --user=root &

/usr/local/mysql/bin/mysqld_safe --defaults-file=/data2/ali/mysql3309/my.cnf --user=root &

Àˬdmysql¬O§_±Ò°Ê¦¨¥\¡C

ps -ax|grep mysql

20835 pts/3 S 0:00 /bin/sh ./mysqld_safe --defaults-file=/data2/ali/mysql3308/my.cnf --user=root

20862 pts/3 Sl 0:00 /usr/local/mysql/bin/mysqld --defaults-file=/data2/ali/mysql3308/my.cnf --basedir=/usr/local/mysql --datadir=/data2/ali/mysql3308/ --user=root --pid-file=/data2/ali/mysql3308//XD_Blog_Web_132_42.pid --skip-external-locking --port=3308 --socket=/tmp/mysql-3308.sock

20872 pts/3 S 0:00 /bin/sh ./mysqld_safe --defaults-file=/data2/ali/mysql3309/my.cnf --user=root

20903 pts/3 Sl 0:00 /usr/local/mysql/bin/mysqld --defaults-file=/data2/ali/mysql3309/my.cnf --basedir=/usr/local/mysql --datadir=/data2/ali/mysql3309/ --user=root --pid-file=/data2/ali/mysql3309//XD_Blog_Web_132_42.pid --skip-external-locking --port=3309 --socket=/tmp/mysql-3309.sock

³s±µmysql

mysql -S /tmp/mysql-3108.sock

¤G¡B±µµÛ¦w¸Ëphp

tar zxf php-5.2.4.tar.gz

cd php-5.2.4

./configure \

--prefix=/usr/local/php-fcgi \

--enable-fastcgi \

--enable-force-cgi-redirect \

--without-iconv \

--enable-mbstring \

--with-mysql=/usr/local/mysql

make

make install

½Æ»s°Ñ¼Æ¤å¥ó¨ì¥Ø¼Ð¥Ø¿ý:

cp php.ini-dist /usr/local/php-fcgi/lib/php.ini

Àˬdfast-cgi¬O§_¦w¸Ë¦¨¥\¥i¥H¹B¦æ¦p¤U©R¥O

/usr/local/php-fcgi/bin/php-cgi -v

Åã¥Ü¦p¤U¸ê°T¡A¤º®eùØ¥]§t¡§PHP 5.2.4 (cgi-fcgi)"ªí¥Ü¤ä´©fast-cgi¤F

PHP 5.2.4 (cgi-fcgi) (built: Oct 28 2007 20:08:41)

Copyright (c) 1997-2007 The PHP Group

Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies

¤T¡B³Ì«á¦w¸Ëlighttpd

1.¦w¸Ë°t¸mlighttpd

1.1 ­º¥ý³Ð«Ø¹B¦ælighttpdªº¥Î¤á©M²Õ

# groupadd lighttpd

# useradd -g lighttpd -s /sbin/nologin -d /dev/null lighttpd

1.2 ¶}©l¦w¸Ëlighttpd

# wget http://www.lighttpd.net/download/lighttpd-1.4.8.tar.gz

# tar -zxvf lighttpd-1.4.8.tar.gz

# cd lighttpd-1.4.8

# ./configure --prefix=/usr/local/lighttpd

# make

# make install

# mkdir /usr/local/lighttpd/conf

# mkdir /usr/local/lighttpd/log

# mv ./doc/lighttpd.conf /usr/local/lighttpd/conf/

# cp ./doc/rc.lighttpd.redhat /etc/init.d/lighttpd

vi conf/lighttpd.conf

±N #¡¨mod_fastcgi¡¨, ªº#¥h±¼

server.modules = (

"mod_rewrite",

"mod_redirect",

# "mod_alias",

"mod_access",

# "mod_cml",

# "mod_trigger_b4_dl",

# "mod_auth",

# "mod_status",

# "mod_setenv",

"mod_fastcgi",

§ä¨ìfastcgiªº©w¸q

#### fastcgi module

## read fastcgi.txt for more info

## for PHP don't forget to set cgi.fix_pathinfo = 1 in the php.ini

fastcgi.server = ( ".php" =>

( "localhost" =>

(

"socket" => "/var/run/lighttpd/php-fastcgi.socket",

"bin-path" => "/usr/local/php-fcgi/bin/php-cgi"

)

)

)

¤@¶}©l§Ú§â°t¸m¼g"bin-path" => "/usr/local/php-fcgi/bin/php"³o¼Ë¡Aµo²{³ø¿ù¡A«á¨Ó§ï¤F¤U¥H¤Wªº°t¸m¡Aµo²{OK¤F¡I

±Ò°Êlighttpd©R¥O¬O³o¼Ëªº¡G

/usr/local/lighttpd/sbin/lighttpd -f conf/lighttpd.conf

³Ì«á¥i¥H¦bµ{¦¡¥Ø¿ý¤U«Ø­Ótest.php,Àˬd¤@¤U¬O§_¥¿±`!

¡]³d¥ô½s¿è¡G¿c¥üªL¡^


[ µoªíµû½× ] ¦rÅé[ ¤j¡B¤¤¡B¤p ] [ ¦C¦L ] [ ¶i¤J³Õ«È ] [ ¶i¤J½×¾Â ]  [ ±ÀÂ˵¹ªB¤Í ]
  ¡i¬ÛÃö¤å³¹¡j
¡P ªì¾ÇªÌ¥²Åª¡GMySQL¼Æ¾Ú®w±`¨£°ÝÃD¶×Á` (06-27) ¡P ¦p¦ó¦bUnix¨t²ÎÀô¹Ò¤U¦w¸ËMySQL¼Æ¾Ú®w (06-27)
¡P ­Ó¤H¸gÅçÁ`µ²¡G§¹¥þ¨ø¸üMySQL¼Æ¾Ú®w5.0 (06-27) ¡P MySQL¼Æ¾Ú®w¦bºô¸ô¦w¥þ¤è­±ªº¤@¨Ç¨¾¿m±¹¬I (06-10)
¡P MySQL¤¤¨âºØ§Ö³t³Ð«ØªÅªíªº¤è¦¡ªº°Ï§O (06-06) ¡P LunixÀô¹Ò¤UMySQL¼Æ¾Ú®wªº¦Û°Ê³Æ¥÷¸}¥» (06-04)
¡P ¸Ñ¨MMySQL 5.0¤£¯à¨Ï¥Î¦Û°Ê¼W¥[¦r¬q°ÝÃD (06-02) ¡P Á¿¸ÑMaxDB¼Æ¾Ú®w©MMySQL¼Æ¾Ú®wªº¥D­n®t§O (05-30)
¡P Á¿¸ÑMySQL¼Æ¾Ú®wªº¼Æ¾ÚÃþ«¬©M«Ø®wµ¦²¤ (05-29) ¡P MySQL¼Æ¾Ú®w¤¤·j´M°õ¦æ®Ä²vºCªºSQL»y¥y (05-27)
  ¡i«È¤á»Ý¨D¤ÏõXªí¡j
* ©m¡@¡@¦W:
§ó¦h¸ê®Æ¡@ ¤F¸Ñ¤è®×¡@ »{ÃѼt°Ó
* ³æ¦ì¦WºÙ:
* Ápô¹q¸Ü:
* ¹q¤l¶l¥ó:
  ÁÉ­}±ÀÂË  
  ¤â¾÷¡P¸ê¶O ¡P·s«~¡P¾ÉÁÊ¡Pµû´ú¡P¤â¾÷¸ê¶O¡P¼e±a
¤â¾÷·j¯Á  ¿Õ°ò¨È N73 MOTO Z6
  IT²£«~ ¡Pµ§°O¥»¡P»O¦¡¾÷¡P¦øªA¾¹¡P¦C¦L¡P§ë¼v
IT²£«~·j¯Á 
  IT§Þ³N ¡P¶}µo¡PºôºÞ¡P¦w¥þ¡P¼Æ¾Ú®w¡P§@·~¨t²Î
  ¸ê°T¤Æ ¡P¼öÂI¡P±MÃD¡P³X½Í¡P¶g¥Z¡P¤è®×®×¨Ò
¡P ITªv²z¼²¤J¡§¦ºçÁ¦P¡¨ªº¤C¤j»¤¦] À³¦p¦óÁ×¶}
¡P ¤¬Ápºô¹s°â·~Á߯C·sª«ºØ ¹s°â°ò¦]¸ê°T¤ÆÅܲ§
¡P ERP®×¨Ò¤ÀªR SaaS±a¨Ó½ÄÀ» ITªA°È°Ó­±Á{¬D¾Ô
¡P ³q¤è´Á³fCRM¸Ñ¨M¤è®× ©Ð¦a²£¦æ·~CRM¸Ñ¨M¤è®×
  IT³Õ«È ¡P´¿¼C¬î¡P¶µ¥ß­è¡PJava¾Ç²ß¡PºôºÞ
  IT§Þ³N½×¾Â ¡P¶}µo¡PºôºÞ¡P¦w¥þ¡P¼Æ¾Ú®w¡P¨t²Î