[OpenAFS] Holy Grail of High Availability
   
    Nick Andrew
     
    lists@nick-andrew.net
       
    Tue, 8 Oct 2002 23:29:37 +1000
    
    
  
On Tue, Oct 08, 2002 at 01:27:50PM +0200, Tino Schwarze wrote:
> Replicating a database will not work this way - you circumvent all kinds
> of internal caches and integrity checks. Your database needs to support
> replication explicitly.
I should just point out that MySQL supports replication and
transactional tables. With replication, each instance may be
a slave of at most one master. That limits the topology, but
still allows flexibility, e.g.
 - one server for updates and N servers for queries (star)
 - two update/query servers each slaved off the other (binary system)
 - N update/query servers each slaved off its neighbour (ring)
Nick.