Is this High Availability solutions what I need?

Hi everybody!

In my actual job, the people from the Systems Development Department have
been using the LAMP technology (Linux + Apache + Php + MySQL) for their
deployments (good for them...! :-)) ).

As more and more systems are ready online, and the use and importance of
them grows up faster, the need to have a High Availability solutions begins
to apear.

The goals of this HA solution are:

- There will be two servers, identical in hardware, with Suse Linux
Enterprise Server 9 and LAMP: the master and the (apprentice) secondary (The
Sith couple :-D).

- Normally, the master will be the only one who brings the services, but
in case of fail, the secondary takes its place automatically in a rasonable
time (5 seconds or less). All the services must work on the secundary.

- When the master goes available, it takes the control of the services
again.

- In realtion with data (system's code updated regularly via FTP,
hundreds of MySQL records per hour and configuration files), it must be
available in the secondary server at the moment of failure, with all its
integrity. Moreover, when the master returns, it must syncronizes all new
data recorded in the secondary before taking control.

- All of this has to be transparently for the users.


I have started to read about the High-Availability Linux Project
(http://www.linux-ha.org), hearthbeat, fake and DRBD (http://www.drbd.org);
but I like to know if they are exactly what I need for the above goals, if
they need aditional packages, if there is another solution to acomplish the
objectives, and so on. Also, the URL for a good tutorial, documentation or
howto will be appreciated!

About MySQL, is DRBD capable to sync the DBs without data lost and
preserving the transaction operations and integrity of InnoDB and MyISAM
tables, or do I have to implement and independant MySQL redundancy scheme?

A last cuestion will be what hardware solution do you think is the best for
these objetives (RAID, power supply redundancy, etc.), without concern in
the costs?


Thanks a lot in advanced!


P.D. Sorry for my English!

____________________________________________________________ _____
Platica con tus amigos en linea con MSN Messenger
http://messenger.t1msn.com.mx/

-
To unsubscribe from this list: send the line "unsubscribe linux-admin" in
the body of a message to majordomo@vger.kernel.org
More majordomo info at http://vger.kernel.org/majordomo-info.html

Re: Is this High Availability solutions what I need?

I'm pretty sure you can run mysql as a cluster.... I would check into
this.

Thanks,
Tom Callahan
TESSCO Technologies
Desk: (410)-229-1361
Cell: (410)-588-7605
Email: callahant@tessco.com

A real engineer only resorts to documentation when the keyboard dents on
the forehead get too noticeable.



On Sep 17, 2006, at 11:12 PM, Vladimir Burciaga Aguilar wrote:

> Hi everybody!
>
> In my actual job, the people from the Systems Development Department
> have
> been using the LAMP technology (Linux + Apache + Php + MySQL) for
> their
> deployments (good for them...! :-)) ).
>
> As more and more systems are ready online, and the use and
> importance of
>
> them grows up faster, the need to have a High Availability solutions
> begins
> to apear.
>
> The goals of this HA solution are:
>
> - There will be two servers, identical in hardware, with Suse Linux
> Enterprise Server 9 and LAMP: the master and the (apprentice)
> secondary
> (The
> Sith couple :-D).
>
> - Normally, the master will be the only one who brings the
> services,
> but
> in case of fail, the secondary takes its place automatically in a
> rasonable
> time (5 seconds or less). All the services must work on the secundary.
>
> - When the master goes available, it takes the control of the
> services
> again.
>
> - In realtion with data (system's code updated regularly via FTP,
> hundreds of MySQL records per hour and configuration files), it
> must be
> available in the secondary server at the moment of failure, with
> all its
>
> integrity. Moreover, when the master returns, it must syncronizes all
> new
> data recorded in the secondary before taking control.
>
> - All of this has to be transparently for the users.
>
>
> I have started to read about the High-Availability Linux Project
> (http://www.linux-ha.org), hearthbeat, fake and DRBD
> (http://www.drbd.org);
> but I like to know if they are exactly what I need for the above
> goals,
> if
> they need aditional packages, if there is another solution to
> acomplish
> the
> objectives, and so on. Also, the URL for a good tutorial,
> documentation
> or
> howto will be appreciated!
>
> About MySQL, is DRBD capable to sync the DBs without data lost and
> preserving the transaction operations and integrity of InnoDB and
> MyISAM
>
> tables, or do I have to implement and independant MySQL redundancy
> scheme?
>
> A last cuestion will be what hardware solution do you think is the
> best
> for
> these objetives (RAID, power supply redundancy, etc.), without concern
> in
> the costs?
>
>
> Thanks a lot in advanced!
>
>
> P.D. Sorry for my English!
>
> ____________________________________________________________ _____
> Platica con tus amigos en linea con MSN Messenger
> http://messenger.t1msn.com.mx/
>
> -
> To unsubscribe from this list: send the line "unsubscribe linux-admin"
> in
> the body of a message to majordomo@vger.kernel.org
> More majordomo info at http://vger.kernel.org/majordomo-info.html

-
To unsubscribe from this list: send the line "unsubscribe linux-admin" in
the body of a message to majordomo@vger.kernel.org
More majordomo info at http://vger.kernel.org/majordomo-info.html

Re: Is this High Availability solutions what I need?

At 20:57 18/09/2006, Thomas Callahan wrote:



>I'm pretty sure you can run mysql as a cluster.... I would check into
>this.


Or set up a shared external SCSI Raid array so you only have one data
array with the 2 machines accessing it, using a heartbeat so
the machines keep in touch.

As a start have a look at http://www.linux-ha.org/

Regards
Carl

-
To unsubscribe from this list: send the line "unsubscribe linux-admin" in
the body of a message to majordomo@vger.kernel.org
More majordomo info at http://vger.kernel.org/majordomo-info.html

Re: Is this High Availability solutions what I need?

You have to worry about file locking then. Ocfs2 might be a good choice for
that.


================================
Sent from my wireless handheld device.

Tom Callahan

-----Original Message-----
From: linux-admin-owner@vger.kernel.org
To: Vladimir Burciaga Aguilar; linux-admin@vger.kernel.org
CC: linux-admin@vger.kernel.org
Sent: Wed Sep 20 07:07:39 2006
Subject: Re: Is this High Availability solutions what I need?

At 20:57 18/09/2006, Thomas Callahan wrote:



>I'm pretty sure you can run mysql as a cluster.... I would check into
>this.


Or set up a shared external SCSI Raid array so you only have one data
array with the 2 machines accessing it, using a heartbeat so
the machines keep in touch.

As a start have a look at http://www.linux-ha.org/

Regards
Carl

-
To unsubscribe from this list: send the line "unsubscribe linux-admin" in
the body of a message to majordomo@vger.kernel.org
More majordomo info at http://vger.kernel.org/majordomo-info.html
-
To unsubscribe from this list: send the line "unsubscribe linux-admin" in
the body of a message to majordomo@vger.kernel.org
More majordomo info at http://vger.kernel.org/majordomo-info.html