[Linux-HA] RE: One-way failover?

[Per Andreas Buer]

Marian Marinov wrote:
> Hello Alexey,
> I have installed mysql over a DRBD 2 weeks ago and I'm currently testing it 
> for entering in production.
>   

I've been using MySQL and DRBD for several years. Works great.

> For now the max downtime that I had during simulated server downs is 6-8min 
> during the checking of a big innodb DB. I had no issues with databases using 
> MyISAM.
>   
Yet. :-)

InnoDB takes time to fail over because it actually has some integrity
checks. MyISAM has none - so what happens during a failure is NOT
DEFINED. If you care about your data and you have a lot of updates
MyISAM might be a bit on the risky side.

Per.