CPU Load? What CPU Load?
> > I do recognize this is not *perfect* I run the Rsync every 20 minutes,
and
> > then I run myismchk on the slave system immediately afterwards. I run
the
> > MyISMChk to only scan Tables that have changed since the last check. Not
all
> > my tables change every 20 minutes. I will be timing operations and
lowering
> > this Rsync down to approximately 12 minutes. This method works very
> > effectively for managing a 6 Gig Database that is changing approximately
400
> > megs of data a day.
>
> What kind of CPU load are you seeing? rsync is more CPU intensive than
> most other replication methods, which is how it gains its bandwidth
> efficiency.
>
> Also, can somebody give a brief synopsis of how MySQL replication works?
> I would suspect that since the database has inside knowledge of the data,
> it should be keeping a transaction log or something like that.
>
> --
> John Cronin
> mailto: `echo NjsOc3@xxxxxxxxxxx | sed 's/[NOSPAM]//g'`
>
> _______________________________________________
> LinuxVirtualServer.org mailing list - lvs-users@xxxxxxxxxxxxxxxxxxxxxx
> Send requests to lvs-users-request@xxxxxxxxxxxxxxxxxxxxxx
> or go to http://www.in-addr.de/mailman/listinfo/lvs-users
>
|