On 11/04/13 18:55, Dimitri Maziuk wrote:
> On 11/04/2013 04:17 PM, Phil Stracchino wrote: ...  In at least one
> of the
>> cases I know about, though, the problem was not a failure of DRBD
>> per se, it was that someone accidentally started up mysqld on the
>> second node,
> 
> Ah, the "active-active" setup. I agree: avoid like plague.

Well, they weren't *supposed* to be both active at once.  But someone
made a mistake and accidentally started mysql on the standby node
while it was still running on the primary.  "Oops.  Oh, crap..."

> The simple stupid (and bulletproof) setup is an active/passive
> cluster with drbd, mysql, and floating ip. Unfortunately if it
> fails over your bacula-dir is going to lost its connection to the
> db and kill the running backup -- see my post from 2 days ago.

Well, that's one good way, yeah.  The other is a shared-nothing
master-master cluster.


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
November Webinars for C, C++, Fortran Developers
Accelerate application performance with scalable programming models. Explore
techniques for threading, error checking, porting, and tuning. Get the most 
from the latest Intel processors and coprocessors. See abstracts and register
http://pubads.g.doubleclick.net/gampad/clk?id=60136231&iu=/4140/ostg.clktrk
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users