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@xxxxxxxxxx
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@xxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxx
More majordomo info at http://vger.kernel.org/majordomo-info.html
