Yes, we also want to take advantage of the option to expand capacity, but even just for purposes of smoother fail-over (i.e. shorter down time, actually zero down time as far as the server's availability is concerned) I see the advantage of db-level replication over DRBD.
(sorry for top posting. Mail client limitation) --Amos On 9/22/08, Oleg Goldshmidt <[EMAIL PROTECTED]> wrote: > "Amos Shapira" <[EMAIL PROTECTED]> writes: > >> BUT now that we are finally moving from DNS-based fail-over (due to >> lack of Virtual IP support in the hosting product we originally had) >> to Virtual-IP (using Linux Virtual Server) we see how MySQL >> master-master replication (using simple two-sided replication, e.g. >> http://www.howtoforge.com/mysql-5-master-master-replication-fedora-8, >> NOT the "MySQL Cluster" product which last time I read about it it >> sounded like a bad joke) would benefit us - >> 1. It means that fail-over time will be virtually zero (compared to a >> few seconds to bring up the secondary) >> 2. It means that we can take advantage of both MySQL servers in >> parallel - for higher capacity > > It looks like you are also interested in load balancing / scalability > and are looking for active/active failover as a part of that. AFAIK, > LinuxHA has active/active mode, but I have never used it. From Noam's > description it seems that active/passive is what he is looking for. > >>> [2] RedHat is the only exception I know of, I suppose because they >>> have their own clustering product - of course RPMs are there. >> >> Exception to what? Linux-HA and DRBD comes packaged in CentOS 5 and we >> have all software from rpm's, we didn't have to compile anything. > > RPMs are there, but AFAIK they are not included by default in RHEL > (the "RedHat" we, as a commercial company, normally deal with, as > opposed to CentOS). Other distros (including, e.g., SLES) have LinuxHA > in by default. We have it here on RHEL, actually it was the first > platform we tried it on and it was up and running in no time, > providing failover to a rather sophisticated bunch of servers with > MySQL inside. > > -- > Oleg Goldshmidt | [EMAIL PROTECTED] > -- Sent from Google Mail for mobile | mobile.google.com ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
