RE: Implementing HA w/o clustering

2006-09-22 Thread Jerry Schwartz
I have done this, but only with some external programming. I was using Informix, not MySQL, but the principle would be the same. Essentially, I put a layer in between the client and the data base, and it wrote transactions into a FIFO for a slave on each server. The slaves, in turn, took care of al

Re: Implementing HA w/o clustering

2006-09-22 Thread JM
On Friday 22 September 2006 18:36, JM wrote: sorry.. what i have in mind is the writes.. master | |_ _ _ _ replicated 1 (read) | |_ _ _ _ replicated 2 (read) thanks, > hi, > > how can i spread reads on a non-cluster config? what i have in