lnmp应用分离+keepalived+mysql互为主备

阅读量：6151 次

发布时间：2019-06-21

本文共 8515 字，大约阅读时间需要 28 分钟。

nginx+php:192.168.198.135,192.168.198.131

keepalived-master:192.168.198.228

keepalived-slave:192.168.198.229

mysql+keepalived:192.168.198.134,192.168.198.141

discuz:

1、安装nginx

①源码

②yum安装(我使用了这个)

yum install -y nginx

lnmp应用分离+keepalived+mysql互为主备

2、安装mariadb

①源码

②yum安装(我使用了这个)

yum install -y epel-release

yum install -y mariadb-server mariadb

yum install perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager perl-Time-HiRes -y

(1)mariadb主从配置(my.cnf)

主：

[mysqld]

server-id=1

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

wait_timeout = 300

#skip_name_resolve = 1

#explicit_defaults_for_timestamp=true

#symbolic-links =0

max_allowed_packet = 100M

thread_stack = 192K

thread_cache_size = 8

max_connections = 1000

max_connect_errors = 1500

transaction_isolation = READ-COMMITTED

#explicit_defaults_for_timestamp = 1

join_buffer_size = 134217728

tmp_table_size = 67108864

tmpdir = /tmp

#innodb_log_buffer_size = 32M

#innodb_log_file_size = 48M

#innodb_page_size = 8192

#innodb_buffer_pool_size = 12G

#innodb_buffer_pool_instances = 8

#innodb_buffer_pool_load_at_startup = 1

#innodb_buffer_pool_dump_at_shutdown = 1

#innodb_lru_scan_depth = 2000

#innodb_lock_wait_timeout = 5

#innodb_io_capacity = 4000

#innodb_io_capacity_max = 8000

#innodb_flush_method = O_DIRECT

#innodb_file_format = Barracuda

#innodb_file_format_max = Barracuda

query_cache_limit = 32M

query_cache_size = 32M

expire_logs_days = 10

max_binlog_size = 100M

#for replication

log-bin=mysql-bin

log-bin=test-bin

binlog-do-db=test

binlog-do-db=discuz

binlog-do-db=db

binlog-ignore-db=mysql

binlog-ignore-db=information_schema

binlog-ignore-db=performance_schema

#binlog-ignore-db=oc

[client]

#socket=/app/mysql/lib/mysql.sock

socket=/var/lib/mysql/mysql.sock

Disabling symbolic-links is recommended to prevent assorted security risks

#symbolic-links=0

Settings user and group are ignored when systemd is used.

If you need to run mysqld under a different user or group,

customize your systemd unit file for mariadb according to the

instructions in

[mysqld_safe]

log-error=/var/log/mariadb/mariadb.log

pid-file=/var/run/mariadb/mariadb.pid

include all files from the config directory

!includedir /etc/my.cnf.d

从：

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

character_set_server=utf8

#default-storage-engine=innodb

init_connect='SET NAMES utf8'

log-bin=test-bin

port=3306

#import csv file

secure_file_priv=""

max_connections = 1000

max_connect_errors = 1000

join_buffer_size = 11382893

tmp_table_size = 6710886

tmpdir = /tmp

Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

Settings user and group are ignored when systemd is used.

If you need to run mysqld under a different user or group,

customize your systemd unit file for mariadb according to the

instructions in

inno settings

#innodb_buffer_pool_size = 5G

#innodb_log_buffer_size = 32M

#innodb_log_file_size = 512M

#innodb_lru_scan_depth = 2000

#innodb_lock_wait_timeout = 5

#innodb_io_capacity = 4000

#innodb_io_capacity_max = 8000

#innodb_flush_method = O_DIRECT

#innodb_file_format = Barracuda

#innodb_file_format_max = Barracuda

#innodb_flush_neighbors = 1

#innodb_log_file_size = 2G

#innodb_log_buffer_size = 10777216

#innodb_purge_threads = 4

#innodb_large_prefix = 1

#innodb_thread_concurrency = 64

#innodb_print_all_deadlocks = 1

#innodb_strict_mode = 1

#innodb_sort_buffer_size = 67108864

#####Logs Settings#####

#innodb_log_buffer_size = 10777216

#innodb_purge_threads = 4

#innodb_large_prefix = 1

#innodb_thread_concurrency = 64

#innodb_print_all_deadlocks = 1

#innodb_strict_mode = 1

#innodb_sort_buffer_size = 67108864

#####Logs Settings#####

query_cache_limit = 32M

query_cache_size = 32M

expire_logs_days = 10

max_binlog_size = 100M

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

server-id=134

replicate-do-db=db

replicate-do-db=test

replicate-do-db=discuz

replicate_wild_do_table=test.t2

replicate_wild_do_table=test.t4

###replicate-do-db=erp

#replicate-do-db=payment

#replicate-do-db=crm

#replicate-do-db=marketing

#replicate-do-db=ocrp

#replicate-do-db=oc

slave-skip-errors=1032,1062,1050,1051,1677

log-slave-updates=true

relay-log=test-relay-bin

#relay-log-index=relay-bin-index

#skip-slave-start

#slave-parallel-type=LOGICAL_CLOCK

#slave-parallel-workers=16

#slave_pending_jobs_size_max=120M

#relay_log_info_repository=table

#master_info_repository=table

[mysqld_safe]

log-error=/var/log/mariadb/mariadb.log

pid-file=/var/run/mariadb/mariadb.pid

include all files from the config directory

!includedir /etc/my.cnf.d

(2)mariadb主从数据库的配置

主：

①创建用户

[root@zimbra ~]# mysql -u root -p123456 -e "create user repl;"

②授权远程访问(这一步不做好的话，通过vip访问会导致discuz会出现1045的报错)

[root@zimbra ~]# mysql -u root -p123456 -e "grant all privileges on . to 'root'@'192.168.198.134' identified by '123456' with grant option;"

MariaDB [mysql]> grant all privileges on . to 'root'@'192.168.198.141' identified by '123456' with grant option;