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 [email protected]
More majordomo info at  http://vger.kernel.org/majordomo-info.html