hi Jeremy , thanks (again, tell me if it's to much=) for helping me.
i've got to admit here that i'm reaching the maximum of my linux skills.
i've used top,free,iostat and sar , without finding the answers i need.
for instance , on the master (dual P3 1Ghz , 1G ram, running only mysql,
with 353M
On Fri, Oct 24, 2003 at 04:00:07AM +0200, Benjamin KRIEF wrote:
> >
> > Is your bottleneck CPU, I/O, or lock contention?
> >
> > Is your slave running on worse hardware than your master?
>
> my bottleneck is CPU , definitely. the load can go up to 35 in peak hours.
> no swapping occurs , my key ef
hi , and thanks for your answer,
> On Mon, Oct 20, 2003 at 07:03:37PM +0200, Benjamin KRIEF wrote:
>> the problem is that it's quite impossible to fine tune the load between
>> the servers , and my slave is a bit too busy , so the replication thread
>> is becoming very slow , and sometimes , i can
On Mon, Oct 20, 2003 at 07:03:37PM +0200, Benjamin KRIEF wrote:
> hi guys,
>
> i've just finished implementing replication on 2 production servers.
[snip]
> the problem is that it's quite impossible to fine tune the load between
> the servers , and my slave is a bit too busy , so the replication
hi guys,
i've just finished implementing replication on 2 production servers.
i'm using round robin dns to balance the load between the slave & the master.
as you would presume , the master handle all the updates, and 1/2 of the
selects , the slave handle the other 1/2 of the selects.
the selec
