Re: [Hampshire] High availability database

Top Page

Reply to this message
Author: John Cooper
Date:  
To: chris, Hampshire LUG Discussion List
Subject: Re: [Hampshire] High availability database
On 15/09/09 17:15, Chris Simmonds wrote:
> Hi,
>
> I have a situation where I need to keep data on several PCs on a LAN in
> sync. Any PC may update the data, with suitable locking, which must be
> pushed out to all the others. It must be possible for a PC to go down
> and be brought back on line again without impacting the others. The
> amount of data is not large - say a few thousand items - and the
> population of PCs is also modest - maybe 50 of them. All will be running
> some version of Red Hat Linux.
>
> Has anyone worked on something along these lines?
>
> 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?
>
> Bye for now,
> Chris.
>

I don't know the type of data you are talking about but have you had a
look at Git (Linus Torvalds's versioning software)

http://www.kernel.org/pub/software/scm/git/docs/v1.2.6/tutorial.html

--
--------------------------------------------------------------
Discover Linux - Open Source Solutions to Business and Schools
http://discoverlinux.co.uk
--------------------------------------------------------------