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: [email protected]

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