On Tue, 21 Jun 2005, Kevin Burton wrote:
> >Out of curiosity, how many queries are we talking and what sort of
> >complexity level? I've had replication setups do 600 (simple) updates/s
> >and slaving was current most of the time and never more than 1 second
> >behind.
> >
> >
> Mostly INSERTS.. W
Atle Veka wrote:
On Mon, 20 Jun 2005, Kevin Burton wrote:
We're noticing a problem where if we were to write to the master with
multiple threads that our slave DB will fall behind.
Note that we're trying to perform as many inserts as humanly possible
and the load on the master is 1.
On Mon, 20 Jun 2005, Kevin Burton wrote:
> We're noticing a problem where if we were to write to the master with
> multiple threads that our slave DB will fall behind.
>
> Note that we're trying to perform as many inserts as humanly possible
> and the load on the master is 1.
Out of curiosity, ho
On Jun 20, 2005, at 5:37 PM, Kevin Burton wrote:
Kevin Burton wrote:
We're noticing a problem where if we were to write to the master
with multiple threads that our slave DB will fall behind.
BTW.. I should clarify.. when I mean "break" I really meant to say
that the slave replication w
Kevin Burton wrote:
We're noticing a problem where if we were to write to the master with
multiple threads that our slave DB will fall behind.
BTW.. I should clarify.. when I mean "break" I really meant to say that
the slave replication will fall WAY behind because it can't replay
transactio
Kevin Burton <[EMAIL PROTECTED]> wrote on 06/20/2005 01:35:38 PM:
> We're noticing a problem where if we were to write to the master with
> multiple threads that our slave DB will fall behind.
> Note that we're trying to perform as many inserts as humanly possible
> and the load on the master is
We're noticing a problem where if we were to write to the master with
multiple threads that our slave DB will fall behind.
Note that we're trying to perform as many inserts as humanly possible
and the load on the master is 1.
My theory is that the master, since it can write to multiple tables