VIP Manager suggestions

[Rick Stevens]

On 03/20/2014 09:51 AM, CS_DBA issued this missive:
>
> On 03/20/2014 07:37 AM, Mark Haney wrote:
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>>
>>
>> On 03/20/14 09:26, CS_DBA wrote:
>>> A tool to manage the creation, assignment, shutdown, movement, etc
>>> of VIP's (or I.P. alliases)
>>>
>>>
>>>
>>> On 03/20/2014 05:31 AM, Patrick O'Callaghan wrote:
>>>> On Wed, 2014-03-19 at 21:31 -0600, CS_DBA wrote:
>>>>> Hi all;
>>>>>
>>>>> Anyone have any suggestions per Virtual I.P. managers?
>>>> OK, I'll bite. What's a Virtual I.P. manager?
>>>>
>>>> poc
>>>>
>> Well, the next question should be: Why?  Why would you need something
>> like that? What are you doing that requires that kind of setup that
>> DHCP wouldn't work better?
>>
>
> So we're looking at database failover, application connections to the db
> are via I.P.'s (or aliases) we can of course use ifconfig and
> create/destroy aliases and thus "move" the IP aliases at failover time,
> however I would like to leverage a tool so the IP alias move can be both
> seamless and executable via command(s) on a single server.
>
> With ifconfig aliases we need to do the following in the failover script:
> - execute the ifdown  on the old / failed master server (probably via
> commands over ssh)
> - validate that the ip alias came down
> - execute the ifup of the alias on the slave (going to be the new master
> shortly)
> - verify that it came up
> - then finish the db failover
>
>
> It would be keen if I could execute a single command like we do with
> amazon elastic ip's or RackSpace virtual ip's...
>
> Thoughts?

First off, make SURE you have your database replication set up
correctly (master-slave, master-master, whatever). It is SO easy to hose
a database when you flip automatically like that.

You can look at Linux HA (commonly used for this sort of thing). You may
want to look at using DRBD as well, putting your databases on the DRBD-
managed partitions.

If you're comfortable with your replication, have a look at keepalived:

	http://keepalived.org/
----------------------------------------------------------------------
- Rick Stevens, Systems Engineer, AllDigital    ricks at alldigital.com -
- AIM/Skype: therps2        ICQ: 22643734            Yahoo: origrps2 -
-                                                                    -
-     Veni, Vidi, VISA:  I came, I saw, I did a little shopping.     -
----------------------------------------------------------------------