keepalived+nginx+tomcat负载均衡&动静分离

Nginx+Keepalived+Tomcat负载均衡&动静分离

目录
第一部分 环境准备
第二部分 部署调度器—搭建Nginx+Keepalived(双机热备)
第三部分 部署服务器池—搭建Tomcat
第四部分 搭建Mysql数据库
第五部分 案例应用

第一部分 环境准备
一:Nginx+keepalived服务器两台(调度器,双机热备)
系统:Linux—CentOS7.4
IP地址:192.168.80.10(lvs01)
192.168.80.20(lvs02)
软件需求:nginx安装包(nginx-1.13.9.tar.gz)
Keepalived安装包(keepalived-1.4.2.tar.gz)
二:tomcat服务器两台(服务器池)
系统:Linux—CentOS7.4
IP地址:192.168.80.30(TM01)
192.168.80.40(TM02)
软件需求:java环境jdk包(jdk-8u144-linux-x64.tar.gz)
tomcat安装包(apache-tomcat-8.5.23.tar.gz)
SL会员商城项目软件包(SLSaleSystem.tar.gz)
三:Mysql服务器一台
系统:Linux-CentOS7.4
IP地址:192.168.80.50
软件需求:mysql安装包(mysql-boost-5.7.20.tar.gz)
SL会员商场数据库文件(slsaledb-2014-4-10.sql)
四:客户端一台,以win7为例,测试验证用
IP地址:192.168.80.2
//Linux系统信息

第二部分 部署调度器—搭建Nginx+Keepalived(双机热备)
//以下在两台Nginx调度服务器上操作
第一步:配置主服务器(192.168.80.10)
-------安装nginx服务-------
[root@lvs01 ~]# yum install -y \ //安装编译工具及插件
gcc
gcc-c++
make
openssl-devel
zlib-devel
pcre-devel
[root@lvs01 ~]# useradd -s /sbin/nologin -M nginx //添加帐号
[root@lvs01 ~]# tar vxf nginx-1.13.9.tar.gz //解压nginx安装包
[root@lvs01 ~]# cd nginx-1.13.9
[root@lvs01 nginx-1.13.9]# ./configure \ //个性化配置

–user=nginx
–group=nginx
–with-file-aio
–with-http_flv_module
–with-http_stub_status_module
–with-http_ssl_module
–with-http_gzip_static_module
–with-http_realip_module
[root@lvs01 nginx-1.13.9]# make //编译
[root@lvs01 nginx-1.13.9]# make install //安装
//以下编译nginx主配置文件
[root@lvs01 nginx-1.13.9]# vi /usr/local/nginx/conf/nginx.conf
user nginx nginx;
worker_processes 1;

#error_log logs/error.log;
#error_log logs/error.log notice;
error_log logs/error.log info;

pid logs/nginx.pid;

events {
worker_connections 1024;
}

http {
include mime.types;
default_type application/octet-stream;

log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                  '$status $body_bytes_sent "$http_referer" '
                  '"$http_user_agent" "$http_x_forwarded_for"';

access_log  logs/access.log  main;
    add_header X-Server $hostname;
    server_names_hash_bucket_size 128;
    server_name_in_redirect off;

sendfile        on;
tcp_nopush     on;
tcp_nodelay on;

#keepalive_timeout  0;
keepalive_timeout  60;
    client_header_buffer_size 32k;
    large_client_header_buffers 4 128k;
    client_max_body_size 512m;
    open_file_cache max=65535 inactive=20s;
    open_file_cache_valid 30s;
    open_file_cache_min_uses 1;

gzip  on;
    gzip_static on;
    gzip_http_version 1.1;
    gzip_comp_level 2;
    gzip_min_length 1024;
    gzip_vary on;
    gzip_types text/plain text/javascript application/x-javascript text/css text/xml application/xml application/xml+rss;

server_tokens off;
fastcgi_connect_timeout 300;
fastcgi_send_timeout 300;
fastcgi_read_timeout 300;
fastcgi_buffer_size 512k;
fastcgi_buffers 6 512k;
fastcgi_busy_buffers_size 512k;
fastcgi_temp_file_write_size 512k;
fastcgi_intercept_errors on;
client_body_buffer_size 128k;

    proxy_connect_timeout 600;
    proxy_read_timeout 600;
    proxy_send_timeout 600;
    proxy_buffer_size 32k;
    proxy_buffers 4 32k;
    proxy_busy_buffers_size 64k;
    proxy_temp_file_write_size 2m;
    proxy_ignore_client_abort on;
    proxy_cache_path /usr/local/nginx/cache_temp levels=2:2

keys_zone=cache_temp:128m inactive=30m max_size=2g;
proxy_cache_valid 200 302 10m;
include /usr/local/nginx/conf/conf.d/*.conf;

server {
    listen       80;
    server_name  localhost;

    charset UTF-8;

    #access_log  logs/host.access.log  main;

    location / {
        root   html;
        index  index.html index.htm;
    }

    #error_page  404              /404.html;

    # redirect server error pages to the static page /50x.html
    #
    error_page   500 502 503 504  /50x.html;
    location = /50x.html {
        root   html;
    }

    # proxy the PHP scripts to Apache listening on 127.0.0.1:80
    #
    #location ~ \.php$ {
    #    proxy_pass   http://127.0.0.1;
    #}

    # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
    #
    #location ~ \.php$ {
    #    root           html;
    #    fastcgi_pass   127.0.0.1:9000;
    #    fastcgi_index  index.php;
    #    fastcgi_param  SCRIPT_FILENAME  /scripts$fastcgi_script_name;
    #    include        fastcgi_params;
    #}

    # deny access to .htaccess files, if Apache's document root
    # concurs with nginx's one
    #
    #location ~ /\.ht {
    #    deny  all;
    #}
}

# another virtual host using mix of IP-, name-, and port-based configuration
#
#server {
#    listen       8000;
#    listen       somename:8080;
#    server_name  somename  alias  another.alias;

#    location / {
#        root   html;
#        index  index.html index.htm;
#    }
#}


# HTTPS server
#
#server {
#    listen       443 ssl;
#    server_name  localhost;

#    ssl_certificate      cert.pem;
#    ssl_certificate_key  cert.key;

#    ssl_session_cache    shared:SSL:1m;
#    ssl_session_timeout  5m;

#    ssl_ciphers  HIGH:!aNULL:!MD5;
#    ssl_prefer_server_ciphers  on;

#    location / {
#        root   html;
#        index  index.html index.htm;
#    }
#}

}
保存退出
//以下编辑子配置文件
[root@lvs01 nginx-1.13.9]# cd /usr/local/nginx/conf/
[root@lvs01 conf]# mkdir conf.d
[root@lvs01 conf]# cd conf.d/
[root@lvs01 conf.d]# vi lvs01.conf //新建子配置文件
server {
listen 80;
server_name lvs01 192.168.80.10; //服务器名称与IP地址
index index.html index.jsp;
root /usr/local/nginx/html;
access_log /usr/local/nginx/logs/tomcat.aa.com_access.log main;
location ~ ..jsp$ {
index index.jsp;
proxy_set_header HOST $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header Client-IP $remote_addr;
proxy_set_header X-For KaTeX parse error: Double subscript at position 12: proxy_add_x_̲forwarded_for; … {
expires 30d;
proxy_pass http://center_pool;
}
location ~ .
.(js|css)?$ {
expires 1h;
proxy_pass http://center_pool;

    }

}
[root@lvs01 conf.d]# vi pool.conf //创建服务器池
upstream center_pool { //默认轮询
server 192.168.80.30:8080;
server 192.168.80.40:8080;
}
//制作启动脚本
[root@lvs01 conf.d]# vi /etc/init.d/nginx
#!/bin/bash

chkconfig: 35 99 20

description: Nginx Service Control Script

PROG="/usr/local/nginx/sbin/nginx"
PIDF="/usr/local/nginx/logs/nginx.pid"
case “$1” in
start)
$PROG
;;
stop)
kill -s QUIT $(cat $PIDF)
;;
restart)
$0 stop
$0 start
;;
reload)
kill -s HUP $(cat $PIDF)
;;
*)
echo “Usage: $0 {start|stop|restart|reload}”
exit 1
esac
exit 0
[root@lvs01 conf.d]# chmod +x /etc/init.d/nginx //增加执行权限
[root@lvs01 conf.d]# chkconfig --add nginx //加入系统管理服务
[root@lvs01 conf.d]# service nginx start //启动nginx服务
[root@lvs01 conf.d]# netstat -anpt | grep 80

-------------部署keepalived-----------
[root@lvs01 conf.d]# yum -y install \ //安装插件

popt-devel
kernel-devel
openssl-devel
[root@lvs01 ~]# tar xvf keepalived-1.4.2.tar.gz
[root@lvs01 ~]# cd keepalived-1.4.2
[root@lvs01 keepalived-1.4.2]# ./configure --prefix=/ //配置
[root@lvs01 keepalived-1.4.2]# make && make install //编译与安装
[root@lvs01 keepalived-1.4.2]# cp keepalived/etc/init.d/keepalived /etc/init.d/
[root@lvs01 keepalived-1.4.2]# systemctl enable keepalived //设置开机自启
//以下编辑keepalived配置文件
[root@lvs01 keepalived-1.4.2]# cd /etc/keepalived/
[root@lvs01 keepalived]# vi keepalived.conf
! Configuration File for keepalived
global_defs {
route_id NGINX-01
}
vrrp_script nginx {
script “/opt/nginx.sh”
interval 2
weight -10
}
vrrp_instance VI_1 {
state MASTER
interface ens33
virtual_router_id 51
priority 150
advert_int 1
authentication {
auth_type PASS
auth_pass 1111
}
track_script {
nginx
}
virtual_ipaddress {
192.168.80.100
}
}
//注意,主备的优先级配置的相差50

//判断keepalived进程是否存在,在就启动nginx不在就关闭
[root@lvs01 keepalived]# vi /opt/nginx.sh
#!/bin/bash
#Filename:nginx.sh
A=$(ps -ef | grep keepalived | grep -v grep | wc -l)
if [ $A -gt 0 ]; then
/etc/init.d/nginx start
else
/etc/init.d/nginx stop
Fi
[root@lvs01 keepalived]# chmod +x /opt/nginx.sh
[root@lvs01 keepalived]# systemctl start keepalived
[root@lvs01 ~]# ip addr show dev ens33 //查看漂移地址是否生成

---------------测试验证------------
[root@lvs01 keepalived]# systemctl stop keepalived //关闭keepalived服务
[root@lvs01 keepalived]# killall -9 nginx //关闭nignx服务
[root@lvs01 keepalived]# netstat -anpt | grep 80 //80端口已停止运行

[root@lvs01 keepalived]# systemctl start keepalived //开启keepalived服务
[root@lvs01 keepalived]# netstat -anpt | grep 80 //nginx随keepalived启动

//验证成功

第二步:配置从服务器(192.168.80.20)
---------安装nginx服务----------
[root@lvs02 ~]# yum install -y \ //安装编译工具及插件

gcc
gcc-c++
make
openssl-devel
zlib-devel
pcre-devel
[root@lvs02 ~]# useradd -s /sbin/nologin -M nginx //添加帐号
[root@lvs02 ~]# tar vxf nginx-1.13.9.tar.gz //解压nginx安装包
[root@lvs02 ~]# cd nginx-1.13.9
[root@lvs02 nginx-1.13.9]# ./configure \ //个性化配置
–user=nginx
–group=nginx
–with-file-aio
–with-http_flv_module
–with-http_stub_status_module
–with-http_ssl_module
–with-http_gzip_static_module
–with-http_realip_module
[root@lvs02 nginx-1.13.9]# make //编译
[root@lvs02 nginx-1.13.9]# make install //安装
//以下编译nginx主配置文件(和主服务器配置一样)
[root@lvs02 nginx-1.13.9]# vi /usr/local/nginx/conf/nginx.conf
user nginx nginx;
worker_processes 1;

#error_log logs/error.log;
#error_log logs/error.log notice;
error_log logs/error.log info;

pid logs/nginx.pid;

events {
worker_connections 1024;
}

http {
include mime.types;
default_type application/octet-stream;

log_format  main  '$remote_addr - $remote_user [$time_local] "$request" '
                  '$status $body_bytes_sent "$http_referer" '
                  '"$http_user_agent" "$http_x_forwarded_for"';

access_log  logs/access.log  main;
    add_header X-Server $hostname;
    server_names_hash_bucket_size 128;
    server_name_in_redirect off;

sendfile        on;
tcp_nopush     on;
tcp_nodelay on;

#keepalive_timeout  0;
keepalive_timeout  60;
    client_header_buffer_size 32k;
    large_client_header_buffers 4 128k;
    client_max_body_size 512m;
    open_file_cache max=65535 inactive=20s;
    open_file_cache_valid 30s;
    open_file_cache_min_uses 1;

gzip  on;
    gzip_static on;
    gzip_http_version 1.1;
    gzip_comp_level 2;
    gzip_min_length 1024;
    gzip_vary on;
    gzip_types text/plain text/javascript application/x-javascript text/css text/xml application/xml application/xml+rss;

server_tokens off;
fastcgi_connect_timeout 300;
fastcgi_send_timeout 300;
fastcgi_read_timeout 300;
fastcgi_buffer_size 512k;
fastcgi_buffers 6 512k;
fastcgi_busy_buffers_size 512k;
fastcgi_temp_file_write_size 512k;
fastcgi_intercept_errors on;
client_body_buffer_size 128k;

    proxy_connect_timeout 600;
    proxy_read_timeout 600;
    proxy_send_timeout 600;
    proxy_buffer_size 32k;
    proxy_buffers 4 32k;
    proxy_busy_buffers_size 64k;
    proxy_temp_file_write_size 2m;
    proxy_ignore_client_abort on;
    proxy_cache_path /usr/local/nginx/cache_temp levels=2:2

keys_zone=cache_temp:128m inactive=30m max_size=2g;
proxy_cache_valid 200 302 10m;
include /usr/local/nginx/conf/conf.d/*.conf;

server {
    listen       80;
    server_name  localhost;

    charset UTF-8;

    #access_log  logs/host.access.log  main;

    location / {
        root   html;
        index  index.html index.htm;
    }

    #error_page  404              /404.html;

    # redirect server error pages to the static page /50x.html
    #
    error_page   500 502 503 504  /50x.html;
    location = /50x.html {
        root   html;
    }

    # proxy the PHP scripts to Apache listening on 127.0.0.1:80
    #
    #location ~ \.php$ {
    #    proxy_pass   http://127.0.0.1;
    #}

    # pass the PHP scripts to FastCGI server listening on 127.0.0.1:9000
    #
    #location ~ \.php$ {
    #    root           html;
    #    fastcgi_pass   127.0.0.1:9000;
    #    fastcgi_index  index.php;
    #    fastcgi_param  SCRIPT_FILENAME  /scripts$fastcgi_script_name;
    #    include        fastcgi_params;
    #}

    # deny access to .htaccess files, if Apache's document root
    # concurs with nginx's one
    #
    #location ~ /\.ht {
    #    deny  all;
    #}
}

# another virtual host using mix of IP-, name-, and port-based configuration
#
#server {
#    listen       8000;
#    listen       somename:8080;
#    server_name  somename  alias  another.alias;

#    location / {
#        root   html;
#        index  index.html index.htm;
#    }
#}


# HTTPS server
#
#server {
#    listen       443 ssl;
#    server_name  localhost;

#    ssl_certificate      cert.pem;
#    ssl_certificate_key  cert.key;

#    ssl_session_cache    shared:SSL:1m;
#    ssl_session_timeout  5m;

#    ssl_ciphers  HIGH:!aNULL:!MD5;
#    ssl_prefer_server_ciphers  on;

#    location / {
#        root   html;
#        index  index.html index.htm;
#    }
#}

}
保存退出
//以下编辑子配置文件(注意与主服务器不同项)
[root@lvs02 nginx-1.13.9]# cd /usr/local/nginx/conf/
[root@lvs02 conf]# mkdir conf.d
[root@lvs02 conf]# cd conf.d/
[root@lvs02 conf.d]# vi lvs02.conf //新建子配置文件
server {
listen 80;
server_name lvs01 192.168.80.20; //服务器名称与IP地址
index index.html index.jsp;
root /usr/local/nginx/html;
access_log /usr/local/nginx/logs/tomcat.aa.com_access.log main;
location ~ ..jsp$ {
index index.jsp;
proxy_set_header HOST $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header Client-IP $remote_addr;
proxy_set_header X-For KaTeX parse error: Double subscript at position 12: proxy_add_x_̲forwarded_for; … {
expires 30d;
proxy_pass http://center_pool;
}
location ~ .
.(js|css)?$ {
expires 1h;
proxy_pass http://center_pool;
}
}
[root@lvs02 conf.d]# vi pool.conf //创建服务器池
upstream center_pool { //默认轮询
server 192.168.80.30:8080;
server 192.168.80.40:8080;
}
//制作启动脚本
[root@lvs02 conf.d]# vi /etc/init.d/nginx
#!/bin/bash

chkconfig: 35 99 20

description: Nginx Service Control Script

PROG="/usr/local/nginx/sbin/nginx"
PIDF="/usr/local/nginx/logs/nginx.pid"
case “$1” in
start)
$PROG
;;
stop)
kill -s QUIT $(cat $PIDF)
;;
restart)
$0 stop
$0 start
;;
reload)
kill -s HUP $(cat $PIDF)
;;
*)
echo “Usage: $0 {start|stop|restart|reload}”
exit 1
esac
exit 0
[root@lvs02 conf.d]# chmod +x /etc/init.d/nginx
[root@lvs02 conf.d]# chkconfig --add nginx
[root@lvs02 conf.d]# service nginx start
[root@lvs02 conf.d]# netstat -anpt | grep 80

-------------部署keepalived-----------
[root@lvs02 conf.d]# yum -y install \

popt-devel
kernel-devel
openssl-devel
[root@lvs02 ~]# tar xvf keepalived-1.4.2.tar.gz
[root@lvs02 ~]# cd keepalived-1.4.2
[root@lvs02 keepalived-1.4.2]# ./configure --prefix=/
[root@lvs02 keepalived-1.4.2]# make && make install
[root@lvs02 keepalived-1.4.2]# cp keepalived/etc/init.d/keepalived /etc/init.d/
[root@lvs02 keepalived-1.4.2]# systemctl enable keepalived
[root@lvs02 keepalived-1.4.2]# cd /etc/keepalived/
[root@lvs02 keepalived]# vi keepalived.conf
! Configuration File for keepalived
global_defs {
route_id NGINX-02
}
vrrp_script nginx {
script “/opt/nginx.sh”
interval 2
weight -10
}
vrrp_instance VI_1 {
state BACKUP
interface ens33
virtual_router_id 51
priority 100
advert_int 1
authentication {
auth_type PASS
auth_pass 1111
}
track_script {
nginx
}
virtual_ipaddress {
192.168.80.100
}
}
//注意,主备的优先级配置的相差50

//判断keepalived进程是否存在,在就启动nginx不在就关闭
[root@lvs02 keepalived]# vi /opt/nginx.sh
#!/bin/bash
#Filename:nginx.sh
A=$(ip addr | grep 192.168.80.100/32 | grep -v grep | wc -l)
if [ $A -gt 0 ]; then
/etc/init.d/nginx start
else
/etc/init.d/nginx stop
fi
[root@lvs02 keepalived]# chmod +x /opt/nginx.sh
[root@lvs02 ~]# systemctl keepalived start

----------测试验证----------
一:查看从服务器状态
[root@lvs02 ~]# ip addr show dev ens33 //查看漂移地址

//由于主服务器在运行,漂移地址并未同步过来

//当主服务器在运行的时候,从服务器虚拟地址并未生成,nginx服务并未随keepalived启动
二:模拟主服务故障

  1. 主服务器
    [root@lvs01 ~]# service keepalived stop
    [root@lvs01 ~]# killall -9 nginx
    [root@lvs01 ~]# netstat -anpt | grep 80

//80端口已不运行
[root@lvs01 ~]# ip addr show dev ens33

//漂移地址消失,不工作
2. 从服务器
[root@lvs02 ~]# ip addr show dev ens33 //查看漂移地址

//漂移地址自动生成
[root@lvs02 ~]# netstat -anpt | grep 80

//服务器检测到虚拟地址,nginx服务自动启动开始工作
三:模拟主服务器恢复工作

  1. 主服务器
    [root@lvs01 ~]# service keepalived start
    [root@lvs01 ~]# ip addr show dev ens33

[root@lvs01 ~]# netstat -anpt | grep 80

//主服务器已恢复工作
2. 从服务器
[root@lvs02 ~]# ip addr show dev ens33

//漂移地址自动移除
[root@lvs02 ~]# netstat -anpt | grep 80

//nginx自动停止服务
//双机热备验证成功

第三部分 部署服务器池—搭建Tomcat
//以下在两台tomcat服务器上操作
第一步:部署第一个节点服务器TM01(192.168.80.30)
----------部署java环境,jdk---------
[root@tom01 ~]# tar xvf jdk-8u144-linux-x64.tar.gz //解压jdk
[root@tom01 ~]# cp -r jdk1.8.0_144/ /usr/local/java //创建java源目录
[root@tom01 ~]# vi /etc/profile
最后添加以下内容:
export JAVA_HOME=/usr/local/java
export JRE_HOME=/usr/local/java/jre
export PATH=$PATH:/usr/local/java/bin
export CLASSPATH=./:/usr/local/java/lib:/usr/local/java/jre/lib
保存退出
[root@tom01 ~]# source /etc/profile //立即生效
[root@tom01 ~]# java –version //查看版本

//java环境部署完成

----------部署tomcat----------
[root@tom01 ~]# tar xvf apache-tomcat-8.5.23.tar.gz //解压apache-tomcat
[root@tom01 ~]# cp -r apache-tomcat-8.5.23 /usr/local/tomcat8 //创建tomcat源目录
//做个软链接,使tomcat开启与关闭更加方便
[root@tom01 ~]# ln -s /usr/local/tomcat8/bin/startup.sh /usr/bin/tomcatup
[root@tom01 ~]# ln -s /usr/local/tomcat8/bin/shutdown.sh /usr/bin/tomcatdown
[root@tom01 ~]# tomcatup //开启tomcat

[root@tom01 ~]# netstat -anpt | grep 8080

-----------验证------------

  1. Win7下访问默认主页:http://192.168.80.30:8080

//tomcat部署成功
2. 服务器池中有两台tomcat服务器,为了便于识别,主页上添加点标记
[root@tom01 ~]# vi /usr/local/tomcat8/webapps/ROOT/index.jsp
添加一行内容:

保存退出
[root@tom01 ~]# tomcatdown
[root@tom01 ~]# tomcatup //重启
//再次访问默认主页http://192.168.80.30:8080

第二步:部署第二个节点服务器TM02(192.168.80.40)
----------部署java环境,jdk---------
[root@tom02 ~]# tar xvf jdk-8u144-linux-x64.tar.gz //解压jdk
[root@tom02 ~]# cp -r jdk1.8.0_144/ /usr/local/java //创建java源目录
[root@tom02 ~]# vi /etc/profile
最后添加以下内容:
export JAVA_HOME=/usr/local/java
export JRE_HOME=/usr/local/java/jre
export PATH=$PATH:/usr/local/java/bin
export CLASSPATH=./:/usr/local/java/lib:/usr/local/java/jre/lib
保存退出
[root@tom02 ~]# source /etc/profile //立即生效
[root@tom02 ~]# java –version //查看版本

//java环境部署完成

----------部署tomcat----------
[root@tom02 ~]# tar xvf apache-tomcat-8.5.23.tar.gz //解压apache-tomcat
[root@tom02 ~]# cp -r apache-tomcat-8.5.23 /usr/local/tomcat8 //创建tomcat源目录
//做个软链接,使tomcat开启与关闭更加方便
[root@tom02 ~]# ln -s /usr/local/tomcat8/bin/startup.sh /usr/bin/tomcatup
[root@tom02 ~]# ln -s /usr/local/tomcat8/bin/shutdown.sh /usr/bin/tomcatdown
[root@tom02 ~]# tomcatup //开启tomcat

[root@tom02 ~]# netstat -anpt | grep 8080

-----------验证------------
[root@tom02 ~]# vi /usr/local/tomcat8/webapps/ROOT/index.jsp
添加一行内容:

保存退出
[root@tom02 ~]# tomcatdown
[root@tom02 ~]# tomcatup //重启
//再次访问默认主页http://192.168.80.40:8080

//tomcat部署成功

第三步:验证nginx调度器漂移地址轮询
Win7访问http://192.168.80.100/index.jsp

再次访问:

//轮询验证成功

第四部分 搭建Mysql数据库
//以下在mysql数据库上操作(192.168.80.50)
一:安装编译工具与插件
[root@mysql ~]# yum -y install \

gcc
gcc-c++
make
ncurses
ncurses-devel
bison
cmake

二:建立数据库程序用户
[root@mysql ~]# useradd -s /sbin/nologin mysql

三:解压mysql安装包
[root@mysql ~]# tar xf mysql-boost-5.7.20.tar.gz –C /opt/

四:配置(个性化配置及优化项目)
[root@mysql ~]# cd /opt/mysql-5.7.20/
[root@mysql mysql-5.7.20]# cmake \

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ //定义安装目录
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock \ //连接数据库socket路径
-DSYSCONFDIR=/etc \ //指定初始化参数文件目录(my.cnf)
-DSYSTEMD_PID_DIR=/usr/local/mysql \ //数据库目录
-DDEFAULT_CHARSET=utf8 \ //指定默认使用的字符集编码
-DDEFAULT_COLLATION=utf8_general_ci \ //指定默认使用的字符集校对规则,utf8_general_ci是适用于UTF-8字符集的通用规则
-DWITH_INNOBASE_STORAGE_ENGINE=1 \ //支持InnoDB引擎
-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \ //安装支持数据库分区
-DMYSQL_DATADIR=/usr/local/mysql/data
-DWITH_BOOST=boost
-DWITH_SYSTEMD=1

五:编译与安装
[root@mysql mysql-5.7.20]# make
[root@mysql mysql-5.7.20]# make install

//对数据库目录进行权限配置
[root@mysql mysql-5.7.20]# chown -R mysql.mysql /usr/local/mysql/

六:编辑Mysql主配置文件
[root@mysql mysql-5.7.20]# vi /etc/my.cnf
(里面内容全部删除,替换成以下内容)
[client]
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock

[mysql]
port = 3306
default-character-set=utf8
socket = /usr/local/mysql/mysql.sock

[mysqld]
user = mysql
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
port = 3306
character_set_server=utf8
pid-file = /usr/local/mysql/mysqld.pid
socket = /usr/local/mysql/mysql.sock
server-id = 1

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,PIPES_AS_CONCAT,ANSI_QUOTES
//保存退出

[root@mysql mysql-5.7.20]# chown mysql:mysql /etc/my.cnf //配置文件属主与属组

六:设置环境变量
[root@mysql mysql-5.7.20]# echo ‘PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH’ >> /etc/profile
//把这两个路径添加到环境变量中,并放到profile文件中使之开机自运行,否则不生效
[root@mysql mysql-5.7.20]# echo ‘export PATH’ >> /etc/profile
//设为全局变量,使它使用环境更广
[root@mysql mysql-5.7.20]# source /etc/profile //立即生效

七:初始化数据库
[root@mysql ~]# cd /usr/local/mysql/
[root@mysql mysql]# bin/mysqld \

–initialize-insecure
–user=mysql
–basedir=/usr/local/mysql
–datadir=/usr/local/mysql/data

八:开启Mysql服务
[root@mysql mysql]# cp usr/lib/systemd/system/mysqld.service /usr/lib/systemd/system/
[root@mysql mysql]# systemctl daemon-reload
[root@mysql mysql]# systemctl start mysqld
[root@mysql mysql]# netstat -anpt | grep 3306 //查看服务运行状态

[root@mysql mysql]# systemctl enable mysqld //设为开机启动

十:访问数据库操作
[root@mysql mysql]# mysqladmin -u root -p password “abc123”
//给root账号设置密码为abc123
注意:提示输入的是原始密码(原始没有密码,直接回车)
[root@mysql mysql]# mysql -u root –p //登录数据库
注意:有密码的加“-p”,如果没有密码不用加“-p”

//数据库安装配置成功,退出则输入”quit“

第五部分 案例应用
第一步:Tomcat服务器下操作(两台tomcat都要操作)
[root@tm01 ~]# cd /usr/local/tomcat8/conf/
[root@tm01 conf]# vi server.xml
在/Host name下面新增一行:

保存退出

第二步:在mysql服务器上操作
[root@mysql ~]# mysql -u root –p //登录数据库,输入密码abc123
create database slsaledb; //创建数据库slsaledb
GRANT all ON slsaledb.* TO ‘testuser’@’%’ IDENTIFIED BY ‘admin123’; //授权testuser用户(密码为admin123)拥有slsaledb数据库的所有权限
flush privileges; //刷新权限

quit 退出
[root@mysql ~]# mysql -u root -p < slsaledb-2014-4-10.sql //上传slsaledb数据库
//用root进数据库查看

第三步:在tomcat服务器上操作

  1. TOM01(192.168.80.30):
    [root@tm01 ~]# tar xf SLSaleSystem.tar.gz -C /usr/local/tomcat8/webapps/
    [root@tm01 ~]# cd /usr/local/tomcat8/webapps/SLSaleSystem/WEB-INF/classes
    [root@tm01 classes]# vi jdbc.properties

保存退出
2. TOM02(192.168.80.40):
[root@tom02 ~]# tar xf SLSaleSystem.tar.gz -C /usr/local/tomcat8/webapps/
[root@tom02 ~]# cd /usr/local/tomcat8/webapps/SLSaleSystem/WEB-INF/classes
[root@tom02 classes]# vi jdbc.properties

保存退出

第四步:验证
一: 验证tomcat连接
Win7下访问:http://192.168.80.30:8080(TOM01)

输入管理员帐号admin,密码123456

访问:http://192.168.80.40:8080(TOM02)

输入管理员帐号admin,密码123456

  • 1
    点赞
  • 4
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值