LVS
lvs-users
Google
 
Web LinuxVirtualServer.org

Re: MySQL Replication

To: <lvs-users@xxxxxxxxxxxxxxxxxxxxxx>
Subject: Re: MySQL Replication
From: "Michael McConnell" <michaelm@xxxxxxxxxxx>
Date: Mon, 17 Sep 2001 20:10:17 -0700
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
>



<Prev in Thread] Current Thread [Next in Thread>