I am trying to setup DRBD/MySQL/Corosync/Pacemaker on AWS EC2 instances, though I am not sure if it will work since how to integrate VIP is a problem for me.
Anyone have any thoughts on what to do ?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
For amazon AWS you have two options:
Then you'll need to edit your
IP2addr resource agent (under
/usr/lib/ocf/resource.d/heartbeat/IPaddr2) to manage the IP failover in-front of amazon.
ec2-assign-private-ip-addresseswhen promoting and
I prefer using ucarp for VIP management in conjunction with DRBD
I have some posts advocating MySQL, DRBD and ucarp
Feb 10, 2014: MySQL High Availability for InnoDB
Oct 17, 2012: Creating High Availability Cluster with PostgreSQL
Dec 19, 2011: Best way to setup master to multi master replication
What might interest you the most is my old post PostgreSQL Failover - What tools should I use? where I actually have some sample code for setting up PostgreSQL with DRBD and ucarp. You can use the same setup for MySQL in the cloud or on bare metal machines.