Noam Rathaus | 21 Sep 21:31

Clustering/Failover Project

Hi,

We are looking for someone to implement a warm-failover, where our existing 
MySQL, Apache and Linux based system will have complete and immediate 
failover (two identical servers either working in parallel or one kicking 
into action when the second one fails, all the while replicating).

Objective:
 * Our system is based on a Linux, MySQL and Apache
 * We want to allow the failure of one server, due to some hardware or
network failure or a manual decision, to turn over all responsibilities to the
second server

Requirements:
 * Failover must synchronize all the data stored in MySQL and be transparent
and seamless - possibly only up to the last few minutes before the failure
 * Has to be implemented into an existing Debian based system
 * No additional hardware should be added unless absolutely required
 * You will need to provide a full guide to the implementation, in addition to 
Perl based scripts to support the failover, a control script to monitor 
status, initiate failover, and recover from failover
 * You need to allow failover to work across an IP based network, where the 
two server are physically distant from each other

I am not looking for general commentary about my project design, philosophical 
comments about failovers or non-topic replies. I'm also not interested in 
replies telling me there's a project that does exactly that (and only 
requires a few tiny customizations that will take days). I'm only looking for 
people who would like to be paid to develop the project and give it to 
us "turnkey", even it is only to customize an existing project that does it.
(Continue reading)

Oleg Goldshmidt | 21 Sep 23:44
Favicon

Re: Clustering/Failover Project

Noam Rathaus <noamr@...> writes:

> I'm also not interested in replies telling me there's a project that
> does exactly that (and only requires a few tiny customizations that
> will take days).

Well, how about a couple of hours, including RTFM? LinuxHA (heartbeat,
http://www.linux-ha.org) + DRBD (http://www.drbd.org,
http://linux-ha.org/DRBD) is the most common linux HA solution, works
great with MySQL (http://www.mysql.com/products/enterprise/drbd.html),
comes with most linux distros [1,2], and thus is likely already
installed on your system.

Anyway, I am not available for this gig, so feel free to pay whoever
does this for you. If I were you, I would insist on hearing real hard
arguments before deciding on a competing solution.

One such argument may be "we absolutely cannot move MySQL data onto a
separate partition, because (a really good argument goes here)".

[1] Debian included
[2] RedHat is the only exception I know of, I suppose because they 
    have their own clustering product - of course RPMs are there.

Hope this helps,

--

-- 
Oleg Goldshmidt | pub@...

=================================================================
(Continue reading)

Michael Tewner | 22 Sep 06:00

Re: Clustering/Failover Project

I've set up a system just like this and it's been up for over a year happily chugging along...

On Mon, Sep 22, 2008 at 12:44 AM, Oleg Goldshmidt <pub-kS3dXprRuVK+yyHGYkWdLQ@public.gmane.org> wrote:
Noam Rathaus <noamr-koYqR8i3DjZZkMgn48OZqdBPR1lH4CV8@public.gmane.org> writes:

> I'm also not interested in replies telling me there's a project that
> does exactly that (and only requires a few tiny customizations that
> will take days).

Well, how about a couple of hours, including RTFM? LinuxHA (heartbeat,
http://www.linux-ha.org) + DRBD (http://www.drbd.org,
http://linux-ha.org/DRBD) is the most common linux HA solution, works
great with MySQL (http://www.mysql.com/products/enterprise/drbd.html),
comes with most linux distros [1,2], and thus is likely already
installed on your system.

Anyway, I am not available for this gig, so feel free to pay whoever
does this for you. If I were you, I would insist on hearing real hard
arguments before deciding on a competing solution.

One such argument may be "we absolutely cannot move MySQL data onto a
separate partition, because (a really good argument goes here)".

[1] Debian included
[2] RedHat is the only exception I know of, I suppose because they
   have their own clustering product - of course RPMs are there.

Hope this helps,

--
Oleg Goldshmidt | pub-kS3dXprRuVK+yyHGYkWdLQ@public.gmane.org

=================================================================
To unsubscribe, send mail to linux-il-request-NSemkxREmS1YZAO8hgG6+w@public.gmane.org with
the word "unsubscribe" in the message body, e.g., run the command
echo unsubscribe | mail linux-il-request-NSemkxREmS1YZAO8hgG6+w@public.gmane.org



Gmane