Sql

Search

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
}

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql vs sql server performance benchmark
Sql :: oserror mysql_config not found virtualenv
Sql :: declare row variable sql server
Sql :: ring SQLite sqlite_init
Sql :: how to do a function to return row type from a table in pl/sql
Sql :: how to drop mili second in sql
Sql :: showing all columns in an sqlite table
Sql :: sql find record cannot cast date
Sql :: hive batch drop table
Sql :: mysql grant user wildcard database
Sql :: mybatis batch update oracle
Sql :: PostgreSQL random boolean for generate test values
Sql :: Grant read-only privilleges to the user
Sql :: python mysqlclient library not found for -lssl
Sql :: how to get button for every record from mysql
Sql :: sql server o arquivo solicitado não pode ser baixado
Sql :: what is group function in sql
Sql :: All Some Any
Sql :: how to run sql query in mysql workbench
Sql :: print pl sql
Sql :: create database in sql
Sql :: select all users sql
Sql :: how to retrive image from sql to picturebox usinf image location
Csharp :: unity if in editor
Csharp :: unity how to see what scen you are in
Csharp :: vb.net wait 1 second
Csharp :: create or update in laaravel
Csharp :: c# or
Csharp :: Change fog setting Unity
Csharp :: camera follow player unity smooth

Search

SQL

mysql master slave setup with keepalived

ADD CONTENT