On Tue, Sep 15, 2009 at 17:15:18 +0100 (+0100), Chris Simmonds wrote:
>
> One option I have considered is using, say, MySQL with one master node
> replicating to all the others and some mechanism to elect a new master
> if the original went down. But, that sounds messy. There must be a
> neater solution?
MySQL + LinuxHA + DRBD is the typical solution. You could use MySQL
with replication and failover (or even multi-master if you are brave).
A proper clustered filesystem (e.g. OCFS2 ontop of DRBD8) maybe better.
However be aware that all of these aren't simple configs and you
really want to do thorough testing beforehand - I've seen some setups
be incredibly brittle - so any theoretical improvement in uptime may
in practice become a major drop.
For example when I was looking at GFS last year:
http://www.smop.co.uk/blog/index.php/2008/02/11/gfs-goodgrief-wheres-the-documentation-file-system/
Adrian
--
bitcube.co.uk - Linux infrastructure consultancy
Puppet, Debian, Red Hat, Ubuntu, CentOS, ...
