keepalived+nginx+tomcat+redis+mysql主主架构部署(4)

5、配置Sentinel

#cd /opt/redis/

#vi sentinel.conf

主从节点一致：

#守护进程
daemonize yes
protected-mode no
#端口
port 1777
#运行日志
logfile "/opt/redis/sentinel.log"
pidfile "/opt/redis/sentinel.pid"
#配置监控主服务器,mymaster:定义主服务器名,10.200.36.166:主服务ip 6000:主服务端口 2:设置当有1个sentinel判断master故障后才真正认为master无法继续提供服务，即开始容灾措施
sentinel monitor mymaster 10.200.36.166 6000 1
#指定sentinel认定一个服务器断线的毫秒数,即一个sentinel认定服务SDOWN，在这个配置时间内需要获得指定个数的Sentinel判定ODWON,才开始failover
sentinel down-after-milliseconds mymaster 2000
#从节点数量为几后面就写几，我这里只有一个从节点，所以写1
sentinel parallel-syncs mymaster 1

6，启动Sentinel

#cd /opt/redis

#./bin/redis-sentinel ./sentinel.conf &--启动

7，检验

#./bin/redis-cli -h 10.200.36.166 -p 6000 # -h:ip地址,-p:访问端口

主节点:

10.200.36.166:6000> info replication
# Replication
role:master
connected_slaves:1
slave0:ip=10.200.36.167,port=6000,state=online,offset=616,lag=1
master_replid:3a676503f92e3403f9d4a20097d8f16f7dfa2b5d
master_replid2:0000000000000000000000000000000000000000
master_repl_offset:616
second_repl_offset:-1
repl_backlog_active:1
repl_backlog_size:1048576
repl_backlog_first_byte_offset:1
repl_backlog_histlen:616

从节点:

10.200.36.167:6000> info replication
# Replication
role:slave
master_host:10.200.36.166
master_port:6000
master_link_status:up
master_last_io_seconds_ago:3
master_sync_in_progress:0
slave_repl_offset:616
slave_priority:100
slave_read_only:1
connected_slaves:0
master_replid:3a676503f92e3403f9d4a20097d8f16f7dfa2b5d
master_replid2:0000000000000000000000000000000000000000
master_repl_offset:616
second_repl_offset:-1
repl_backlog_active:1
repl_backlog_size:1048576
repl_backlog_first_byte_offset:1
repl_backlog_histlen:616

sentinel使用./bin/redis-cli -h 10.200.36.166 -p1777访问

八，基础指令

1，启动顺序

Nginx -> Tomcat -> Keepalived -> Redis

2，指令

#cd /usr/local/nginx/sbin

#./nginx --启动nginx

#./nginx -s stop --关闭nginx

#./nginx -s reload --重启nginx

#su tomcat --切换成tomcat用户

#cd /opt/apache-tomcat-9.0.13/bin/

#./startup.sh --启动tomcat

#./shutdown.sh --关闭tomcat

#systemctl start keepalived.service --启动keepalived

#systemctl stop keepalived.service --关闭keepalived

#systemctl restart keepalived.service --重启keepalived

#cd /opt/redis

#./bin/redis-server ./redis.conf & --启动redis

#./bin/redis-cli -p 6000 shutdown --关闭redis

#./bin/redis-sentinel ./sentinel.conf & --启动sentinel

#./bin/redis-cli -p 1777 shutdown --关闭sentinel 注：redis有两种启动方式。 前台启动：./bin/redis-server ./redis.conf 后台启动：./bin/redis-server

./redis.conf &

还有种后台启动的方式是改redis.conf配置文件，将daemonize改为yes，这样直接使用./bin/redis-server

./redis.conf也是后台启动。

九，搭建MySql主主

1.安装MySQL服务（建议源码安装）

1.1 yum安装依赖包

yum -y install make gcc gcc-c++ ncurses-devel bison openssl-devel

1.2 添加MySQL所需要的用户和组，添加boost库Cmake编译安装时使用。

#groupadd -g 77 mysql

#adduser -u 77 -g mysql -s /sbin/nologin mysql

#cd /opt/soft/

#tar -zxvf boost_1_59_0.tar.gz -C /usr/local/boost

#cd /usr/local/boost/boost_1_59_0/

#./bootstrap.sh

1.3 创建mysql数据目录

#mkdir -p /optl/mysql/

1.4 解压编译安装cmake、MySQL

#cd /opt/soft/

#tar -zxvf cmake-3.13.4.tar.gz

#cd cmake-3.13.4/

#./bootstrap

#gmake

#make &make install

1.5安装MySql

#cd /opt/soft/

#tar -zxvf mysql-5.7.25.tar.gz

#cd mysql-5.7.25

#cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
--DDEFAULT_CHARSET=utf8 \
--DDEFAULT_COLLATION=utf8_general_ci \
--DENABLED_LOCAL_INFILE=ON \
--DWITH_INNOBASE_STORAGE_ENGINE=1 \
--DWITH_FEDERATED_STORAGE_ENGINE=1 \
--DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
--DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \
--DWITH_PARTITION_STORAGE_ENGINE=1 \
--DWITH_PERFSCHEMA_STORAGE_ENGINE=1 \
--DCOMPILATION_COMMENT='Mysqlma' \
--DWITH_READLINE=ON \
--DWITH_BOOST=/usr/local/boost/ boost_1_59_0/ \
--DSYSCONFDIR=/data/mysqldata/3306

#make && make install

1.6 添加开机启动脚本

#cp support-files/mysql.server /etc/rc.d/init.d/mysqld

1.7 添加Master配置文件/etc/my.cnf

#vim /etc/my.cnf

[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
basedir = /usr/local/mysql
port = 3306
socket = /tmp/mysql.sock
datadir = /usr/local/mysql/data
pid-file = /usr/local/mysql/data/mysql.pid
log-error = /usr/local/mysql/data/mysql.err
server-id = 1
auto_increment_offset = 1
auto_increment_increment = 2                                            #奇数ID
log-bin = mysql-bin                                                     #打开二进制功能,MASTER主服务器必须打开此项
binlog-format=ROW
#binlog-row-p_w_picpath=minimal
log-slave-updates=true
gtid-mode=on
enforce-gtid-consistency=true
master-info-repository=TABLE
relay-log-info-repository=TABLE
sync-master-info=1
slave-parallel-workers=0
sync_binlog=0
binlog-checksum=CRC32
master-verify-checksum=1
slave-sql-verify-checksum=1
binlog-rows-query-log_events=1
#expire_logs_days=5
max_binlog_size=1024M                                                   #binlog单文件最大值
							
replicate-ignore-db = mysql                                            #忽略不同步主从的
replicate-ignore-db = information_schema
replicate-ignore-db = performance_schema
max_connections = 3000
max_connect_errors = 30
skip-character-set-client-handshake                                     #忽略应用程序想要设置的其他字符集
init-connect='SET NAMES utf8'                                           #连接时执行的SQL
character-set-server=utf8                                               #服务端默认字符集
wait_timeout=1800                                                       #请求的最大连接时间
interactive_timeout=1800                                                #和上一参数同时修改才会生效
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES                     #sql模式
max_allowed_packet = 10M
bulk_insert_buffer_size = 8M
query_cache_type = 1
query_cache_size = 128M
query_cache_limit = 4M
key_buffer_size = 256M
read_buffer_size = 16K
skip-name-resolve
slow_query_log=1
long_query_time = 6
slow_query_log_file=slow-query.log
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqldump]
quick
max_allowed_packet = 16M
[mysqld_safe]

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-111706-4.html