NAME

MHA::AWS - A support script for "MySQL Master HA" running on AWS

SYNOPSIS

$ mhaws [subcommand] --interface_id=ENI-id [... args passed by MHA]
$ mhaws [subcommand] --route_table_id=[RouteTable-id] --vip=[master VIP] [... args passed by MHA]

required arguments:
  1. failover method is ENI attach/detach
    --interface_id=[ENI-id for master VIP]

  2. failover method is RouteTable change destination
    --route_table_id=[RouteTable-id]
    --vip=[master VIP]

subcommand:
  master_ip_failover
  master_ip_online_change
  shutdown


/etc/masterha_default.cnf

[server default]
master_ip_failover_script=mhaws master_ip_failover --interface_id=eni-xxxxxxxx
master_ip_online_change_script=mhaws master_ip_online_change --interface_id=eni-xxxxxxxx
shutdown_script=mhaws shutdown --interface_id=eni-xxxxxxxx

DESCRIPTION

MHA::AWS is a support script for "MySQL Master HA" which running on Amazon Web Service.

REQUIREMENTS

• EC2 instance's "Name" tags must be resolved as DNS name in internal.
• root user must be allowed to ssh login between each MySQL instances.
• aws-cli is installed and available.

Failover method = ENI attach/detach

• One ENI (Elastic Network Interface) must be attached to the MySQL master instance. Clients accesses for the ENI's IP address.

Failover method = VPC route table rewriting

• Prepare a VIP address in your VPC.
• All MySQL hosts(master, slaves) can handle the VIP.
• Clients accesses for the VIP address.

FAILOVER FLOW

• 1 MHA detect master failure.
• 2 "mhaws master_ip_failover --command stop", ENI will be detached from the old master instance.
  • (ENI) ENI will be detached from the old master instance.
  • (Route table) Route to VIP will be removed from VPC route table.
• 3 "mhaws shutdown --command (stopssh|stop)", Old master mysqld process will be killed (if ssh connection is available). Or old master instance will be stopped via AWS API (if ssh connection is NOT available).
• 4 MHA will elect the new master and set up replication.
• 5 "mhaws master_ip_failver --command start", ENI will be attached to the new master instance.
  • (ENI) ENI will be attached to the new master instance.
  • (Route table) Route to VIP will be set to new master instance.

SEE ALSO

AWS::CLIWrapper, https://code.google.com/p/mysql-master-ha/

LICENSE

Copyright (C) FUJIWARA Shunichiro.

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

AUTHOR

FUJIWARA Shunichiro fujiwara.shunichiro@gmail.com