-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Saturday 12 June 2004 09:12 am, François Schiettecatte wrote:
> Hi
>
> I am running into an interesting issue with replication speed. The
> setup I have is very simple, one master and one slave. The master
> processes a lot of inserts and updates all the time and these are
> replicated to the slave. The slave is read from all the time.
>
> The odd thing is that since I switched from using myisam to using
> innodb, the slave is not always able to keep up with the master, and
> lags behind. Further the machine load (as indicated by 'top') is always
> higher on the master than on the slave. However when the load on the
> master goes down (fewer inserts and updates), the slave will catch up.
Its simple, your second server is overloaded.. You need twice the computer on
that node to keep up. The slave still has to process those inserts./updates..
No matter if your connecting to it, or its replicated.
- --
All an argument ever proves is that two people are present.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQFAzgDqld4MRA3gEwYRAjdSAJ994Wcxal6JHZdOoB0s701iFU/85gCgmrzo
GnBqx1kXjGfEIxWKptWIcqg=
=oBr5
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
