安装Nginx
Nginx需要安装stream模块
stream模块可以代理mysql、FTP等tcp连接
安装依赖
yum install -y wget gcc gcc-c++ make pcre pcre-deve zilib zlib-devel openssl-devel
下载Nginx
wget http://nginx.org/download/nginx-1.18.0.tar.gz
tar zxvf nginx-1.18.0.tar.gz
编译安装Ngixn
cd nginx-1.18.0
./configure --prefix=/usr/local/nginx --with-stream --with-http_ssl_module --with-http_gzip_static_module --with-http_stub_status_module
make && make install
配置反代理
配置配置文件
--配置反代理Mysql
vim /usr/local/nginx/conf.d/default.conf
events {
worker_connections 1024;
}
stream {
upstream mysql{
server 172.17.0.3:3306;
}
server {
listen 8080;
proxy_pass mysql;
}
}
启动Nginx
--指定配置文件启动
cd /usr/local/nginx
/usr/local/nginx/sbin/nginx -c conf.d/default.conf
验证反代理是否成功
mysql -uroot -p123456 -h172.16.0.14 -P8080
参数解释:
-u 指定Mysql用户名
-p 指定Mysql密码
-h 指定Nginx代理服务器IP
-P 指定端口
root@linux:/usr/local/nginx# mysql -uroot -p123456 -h172.16.0.14 -P8080
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.6.49 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MySQL [(none)]>