2008/9/22 Oleg Goldshmidt <[EMAIL PROTECTED]>: > Noam Rathaus <[EMAIL PROTECTED]> writes: > >> I'm also not interested in replies telling me there's a project that >> does exactly that (and only requires a few tiny customizations that >> will take days). > > Well, how about a couple of hours, including RTFM? LinuxHA (heartbeat, > http://www.linux-ha.org) + DRBD (http://www.drbd.org, > http://linux-ha.org/DRBD) is the most common linux HA solution, works > great with MySQL (http://www.mysql.com/products/enterprise/drbd.html), > comes with most linux distros [1,2], and thus is likely already > installed on your system.
(I changed the subject since this is about replying to Oleg, not within the scope of the original post). We are using MySQL over DRBD mostly because I had to set it up in a hurry and we were already using DRBD for PostgresQL and other files. 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 I have yet to get around to switch to MySQL clustering but I think if you have the time and the option then it's a better long-term investment than plain DRBD. > > Anyway, I am not available for this gig, so feel free to pay whoever > does this for you. If I were you, I would insist on hearing real hard > arguments before deciding on a competing solution. > > One such argument may be "we absolutely cannot move MySQL data onto a > separate partition, because (a really good argument goes here)". > > [1] Debian included > [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. Cheers, --Amos PS - The link to HowtoForge above, which I just noticed while writing this message, looks like excellent news since until now I saw only tutorials on how to do this on MySQL 4, which didn't provide support. PPS - Personally, I prefer PostgresQL, and maybe use PL/Proxy (https://developer.skype.com/SkypeGarage/DbProjects/PlProxy) or http://www.postgresql.at/english/downloads_e.html for clustering, e.g. see http://highscalability.com/skype-plans-postgresql-scale-1-billion-users. ================================================================= 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]
