vim /etc/nginx/nginx.conf
http {
...
upstream tomcatservers {
server 172.18.68.21:8080;
server 172.18.68.22:8080;
}
...
server {
...
location / {
proxy_pass http://tomcatservers;
}
...
}
}
systemctl start nginx
cp solo-2.4.1.war /usr/share/tomcat/webapps/ systemctl restart tomcat
cd /usr/share/tomcat/webapps/solo-2.4/WEB-INF/classes vim latke.properties #### Server #### # 配置协议 serverScheme=http # 配置客户端访问站点时的域名或IP,也就是前端Nginx的域名 serverHost=www.shuaiguoxia.com # 使用的端口 serverPort=80
#### H2 runtime #### #runtimeDatabase=H2 #jdbc.username=root #jdbc.password= #jdbc.driver=org.h2.Driver #jdbc.URL=jdbc:h2:~/solo_h2/db #jdbc.pool=h2 # #### MySQL runtime #### runtimeDatabase=MYSQL jdbc.username=root # 用户名 jdbc.password=123456 # 密码 jdbc.driver=com.mysql.jdbc.Driver jdbc.URL=jdbc:mysql://172.18.68.41:3306/solo?useUnicode=yes&characterEncoding=utf8 jdbc.pool=druid
commons-pool2-2.2.jar jedis-2.5.2.jar tomcat-redis-session-manager-2.0.0.jar
cp commons-pool2-2.2.jar /usr/share/tomcat/lib/ cp jedis-2.5.2.jar cp tomcat-redis-session-manager-2.0.0.jar
vim /etc/tomcat/context.xml # <Valve className="com.orangefunction.tomcat.redissessions.RedisSessionHandlerValve" /> <Manager className="com.orangefunction.tomcat.redissessions.RedisSessionManager" host="172.18.68.31" port="6379" database="0" maxInactiveInterval="60" />
ntpdate 172.18.0.1 iptables -F
vim /etc/redis.conf bind 0.0.0.0 # 监听所有IP port 6379 # 设定监听的端口 requirepass 123456 # 设定连接的密码
bind 0.0.0.0 # 监听所有IP slaveof 172.18.68.31 6379 # 设定主节点的IP+端口 masterauth 123456 # 主节点的连接密码 slave-read-only yes # 从节点为只读
shell > redis-cli -h 172.18.68.32 # 连接从服务器redis 127.0.0.1:6379> INFO replication # 查看主从复制状态信息 # Replication role:slave master_host:172.18.68.31 # 主节点IP master_port:6379 # 主节点的端口 master_link_status:up # up为主从同步正常 master_last_io_seconds_ago:9 master_sync_in_progress:0 slave_repl_offset:1420 slave_priority:100 slave_read_only:1 connected_slaves:0 master_repl_offset:0 repl_backlog_active:0 repl_backlog_size:1048576 repl_backlog_first_byte_offset:0 repl_backlog_histlen:0
yum install Mariadb # # #运行初始化脚本对MySQL进行 cd /usr/local/mysql/bin mysql_secure_installation #MySql初始化脚本,以下为每一项的翻译 先回车 是否设置root密码 输入密码 确认密码 是否设置匿名用户 是否允许root远程登录 删除test数据库 现在是否生效
shell > vim /etc/my.cnf server-id=1 #节点ID log-bin=mysql-bin #指定二进制日志前缀 relay-log=mysql-relay-bin #指定relaylog日志前缀 replicate-wild-ignore-table=mysql.% #排除要复制的表 replicate-wild-ignore-table=test.% replicate-wild-ignore-table=information_schema.%
Musql > grant replication slave on *.* to 'slave_user'@'10.0.0.67' identified by '123456';
shell > vim /etc/my.cnf server-id=2 #节点ID log-bin=mysql-bin #指定二进制日志前缀 relay-log=mysql-relay-bin #指定relaylog日志前缀 replicate-wild-ignore-table=mysql.% #排除要复制的表 replicate-wild-ignore-table=test.% replicate-wild-ignore-table=information_schema.%
# 在MySQL主服务器中查询结果 MariaDB [(none)]> show master status\G; *************************** 1. row *************************** File: master-log.000003 Position: 18893845 Binlog_Do_DB: Binlog_Ignore_DB:
MySQL > change master to master_host='10.0.0.66', master_user='slave_user', master_password='123456', master_log_file='mysql-bin.000001', master_log_pos=106;`
MariaDB [(none)]> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 172.18.68.41
Master_User: slave-user
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: master-log.000002
Read_Master_Log_Pos: 245
Relay_Log_File: mysql-relay-bin.000002
Relay_Log_Pos: 530
Relay_Master_Log_File: master-log.000002
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
机械节能产品生产企业官网模板...
大气智能家居家具装修装饰类企业通用网站模板...
礼品公司网站模板
宽屏简约大气婚纱摄影影楼模板...
蓝白WAP手机综合医院类整站源码(独立后台)...苏ICP备2024110244号-2 苏公网安备32050702011978号 增值电信业务经营许可证编号:苏B2-20251499 | Copyright 2018 - 2025 源码网商城 (www.ymwmall.com) 版权所有