标题:CentOS7+MySQL/MariaDB+Galera+HAProxy+Keepalived构建高可用数据库集群
最编程
2024-02-24 20:57:53
...
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
#syslog-->Rsyslog-->journald
# enable syslog for haproxy
sed
-i
's/SYSLOGD_OPTIONS=""/SYSLOGD_OPTIONS="-r"/g'
/etc/sysconfig/rsyslog
cat
>
/etc/rsyslog
.d
/haproxy
.conf<<eof
# Log haproxy(local2.*) stuff
\$ModLoad imudp
\$UDPServerRun 514
local2.*
/var/log/haproxy
.log
eof
chown
-R --reference=
/etc/rsyslog
.d
/listen
.conf
/etc/rsyslog
.d
/haproxy
.conf
chcon -R --reference=
/etc/rsyslog
.d
/listen
.conf
/etc/rsyslog
.d
/haproxy
.conf
systemctl restart rsyslog.service
# enable syslog for keepalived
sed
-i
's/KEEPALIVED_OPTIONS="-D"/KEEPALIVED_OPTIONS="-D -S 0"/g'
/etc/sysconfig/keepalived
cat
>
/etc/rsyslog
.d
/keepalived
.conf<<eof
# Log keepalived(local0.*) stuff
\$ModLoad imudp
\$UDPServerRun 514
local0.*
/var/log/keepalived
.log
eof
chown
-R --reference=
/etc/rsyslog
.d
/listen
.conf
/etc/rsyslog
.d
/keepalived
.conf
chcon -R --reference=
/etc/rsyslog
.d
/listen
.conf
/etc/rsyslog
.d
/keepalived
.conf
systemctl restart rsyslog.service
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
[root@controllernode1 ~]
# delsc /etc/my.cnf.d/galera.cnf
[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
innodb_locks_unsafe_for_binlog=1
query_cache_size=0
query_cache_type=0
bind-address=0.0.0.0
wsrep_provider=
/usr/lib64/galera/libgalera_smm
.so
wsrep_provider_options=
"pc.wait_prim=no; pc.bootstrap=true;"
|