/SQL/Mysql master slave setup with keepalived

Mysql master slave setup with keepalived

! Configuration File for keepalived
global_defs {
      notification_email {
        alexzeng@wordpress.com
      }
      notification_email_from alexzeng@wordpress.com
      smtp_server mx.wordpress.com
      smtp_connect_timeout 30
      router_id mysql-ha
      }
 
vrrp_script check_mysql {
   script "/mysql/keepalived_check.sh db02.wordpress.com"
   interval 2
   weight 2
}
 
vrrp_instance VI_1 {
      state BACKUP
      interface eth1
      virtual_router_id 51
      priority 100
      advert_int 1
      nopreempt  # only needed on higher priority node
      authentication {
      auth_type PASS
      auth_pass 1111
      }
 
      track_script {
        check_mysql
      }
      virtual_ipaddress {
       192.168.5.144/24 dev eth1 label eth1:1
      }
      notify_master /mysql/keepalived_master.sh
      notify_backup /mysql/keepalived_backup.sh
}

Source: alexzeng.wordpress.com

Similar codes

0 vote282 views1 answer
How to use lower case in mysql
SQL
0 vote273 views1 answer
How to change the field size of an existing column
SQL
1 vote287 views2 answers
Oracle list partitioned tables
SQL
2 votes264 views2 answers
Sqlite_busy: database is locked
SQL
2 votes322 views1 answer
Create mysql user on all hosts
SQL
0 vote279 views1 answer
Equi joins in oracle
SQL
0 vote298 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote280 views1 answer
Datagrip exec
SQL
1 vote298 views1 answer
Table infromation in sql server
SQL
0 vote330 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL