在Debian上实现LNMP(Linux, Nginx, MySQL/MariaDB, PHP)的高可用性通常涉及以下几个关键步骤和技术:
http {
upstream backend {
server backend1.example.com;
server backend2.example.com;
# 添加更多服务器
}
server {
listen 80;
location / {
proxy_pass http://backend;
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header X-Forwarded-Proto $scheme;
}
}
}
[mysqld]
server-id = 1
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = your_database_name
重启MySQL服务:sudo systemctl restart mysql
创建复制用户:CREATE USER 'replicator'@'%' IDENTIFIED BY 'password';
GRANT REPLICATION SLAVE ON *.* TO 'replicator'@'%';
FLUSH PRIVILEGES;
查看主服务器状态:SHOW MASTER STATUS;
[mysqld]
server-id = 2
relay_log = /var/log/mysql/mysql-relay-bin.log
log_bin = /var/log/mysql/mysql-bin.log
binlog_do_db = your_database_name
read_only = 1
重启MySQL服务:sudo systemctl restart mysql
配置从服务器连接到主服务器:CHANGE MASTER TO
MASTER_HOST='master_ip',
MASTER_USER='replicator',
MASTER_PASSWORD='password',
MASTER_LOG_FILE='mysql-bin.000001',
MASTER_LOG_POS=107;
START SLAVE;
listen = /run/php/php7.4-fpm.sock
重启PHP-FPM服务:
sudo systemctl restart php7.4-fpm
在Nginx配置中添加PHP-FPM池:
location ~ \.php$ {
include snippets/fastcgi-php.conf;
fastcgi_pass unix:/run/php/php7.4-fpm.sock;
}
vrrp_instance VI_1 {
state MASTER
interface eth0
virtual_router_id 51
priority 100
advert_int 1
authentication {
auth_type PASS
auth_pass 1234
}
virtual_ipaddress {
192.168.1.100
}
}
重启Keepalived服务:
sudo systemctl restart keepalived
sudo apt install prometheus grafana
配置Prometheus和Grafana以监控Nginx、MySQL和PHP-FPM。
mysqldump -u root -p --all-databases > full_backup.sql
通过上述配置,可以显著提高Debian LNMP环境的高可用性,确保系统在部分组件故障时仍能正常运行。在实际部署时,还需要根据具体需求和环境进行调整和优化。