[Client] → [Frontend 192.168.10.8: Nginx + PHP-FPM] → [Backend 192.168.10.5: MySQL 5.1/5.5]
前後端分離優勢:資料庫獨享資源、便於水平擴展 PHP 节點、安全隔離(後端僅開放 3306 給前端 IP)。
註: PHP 5.2 已停止維護,生產環境**強烈建議升級至 PHP 7.4+/8.x**,本文僅作遺留系統維護參考。
tar zxf mysql-5.1.63.tar.gz && cd mysql-5.1.63
./configure --prefix=/usr/local/mysql --without-server
make && make install
--without-server 只編譯客戶端庫,無需編譯 Server,極快。
cmake . -DWITHOUT_SERVER=ON
make mysqlclient libmysql
make install
安裝後 whereis mysql 確認路徑(通常 /usr/local/mysql/bin/mysql_config)。
yum install -y gcc gcc-c++ make libxml2-devel openssl-devel \
bzip2-devel libcurl-devel libjpeg-devel libpng-devel \
freetype-devel libmcrypt-devel libxslt-devel
tar zxf libiconv-1.14.tar.gz && cd libiconv-1.14
./configure --prefix=/usr/local/libiconv
make && make install
cd php-5.2.17
# 應用 fpm 補丁
patch -p1 < ../php-5.2.17-fpm-0.5.14.diff
patch -p1 < ../php-5.2.17-max-input-vars.patch
./configure \
--prefix=/usr/local/php \
--enable-fastcgi --enable-fpm \
--with-fpm-log=/var/log/php-fpm.log \
--with-fpm-conf=/etc/php-fpm.conf \
--with-fpm-pid=/var/run/php-fpm.pid \
--with-config-file-path=/etc \
--with-config-file-scan-dir=/etc/php.d \
--with-openssl --with-zlib --enable-bcmath \
--with-bz2 --with-curl --enable-ftp \
--with-gd --enable-gd-native-ttf \
--with-jpeg-dir --with-png-dir \
--with-gettext --with-mhash \
--enable-mbstring --with-mcrypt \
--enable-soap --enable-zip \
--with-iconv=/usr/local/libiconv \
--with-mysql=/usr/local/mysql \
--with-mysqli=/usr/local/mysql/bin/mysql_config \
--without-pear
make && make install
關鍵差異:MySQL 5.5 客戶端安裝至系統預設路徑 (/usr),改用 shared 方式:
--with-mysql=shared,/usr \
--with-mysqli=shared,/usr/bin/mysql_config
./configure \
--prefix=/usr/local/nginx \
--with-http_ssl_module \
--with-http_gzip_static_module \
--with-http_stub_status_module \
--with-pcre
make && make install
mysql -uroot -p
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.10.8' IDENTIFIED BY 'StrongPass123!';
FLUSH PRIVILEGES;
生產環境請建立專用業務帳號、最小權限、強密碼、禁用 root 遠程。
iptables -A INPUT -s 192.168.10.8 -p tcp --dport 3306 -j ACCEPT
iptables -A INPUT -p tcp --dport 3306 -j DROP
service iptables save && service iptables restart
mysql -h 192.168.10.5 -u root -p
<?php
$link = mysqli_connect("192.168.10.5", "root", "StrongPass123!");
if (!$link) { echo "bad!"; } else { echo "ok!"; }
mysqli_close($link);
?>
瀏覽器訪問該 PHP 文件,輸出 ok! 即連通正常。
pm = dynamic、pm.max_children 依據記憶體計算、request_terminate_timeout 防卡死。fastcgi_keep_conn on; 減少握手開銷。innodb_buffer_pool_size = 0.7 * 物理記憶體、max_connections、慢查詢日誌。完成上述部署,即可獲得一套「前端無狀態、後端獨立存儲」的經典 LAMP/LNMP 分離架構,為後續水平擴展奠定基礎。