(This is a repost of an ealier answer): Here's one which takes log rotation a step further than mysql provides for. It is run on the slaves to keep track of their position and then run on the master to purge up to the earliest slave position. This is useful because you can't reliably get all the slaves' latest position by looking at a master. If a slave is down temporarily, it will not show up on the master.
http://www.chelsea.net/~mprewitt/mtop/utils/purge_replication_log Andreas wrote: > > Hi, > > I'm trying to figure out a viable two site configuration. > Currently I got as far as to a ultra-early stage 2 box test system in a > LAN which does 2-way replication. > One runs LINUX and the other one Win2K. I have MySQL 4.0.4 on both. > > Now the bin-logs are piling up on both machines. Well, sort of ;) > > If I eventually get the whole thing going, the boxes will be in two > different places and talk via dial-up InterNet but not more often than 1 > or 2 times a day. > > How can I ensure that MySQL's logs won't fill up my HDDs ? > > AFAIK the relevant commands SHOW SLAVE STATUS and SHOW MASTER LOGS > depend on a working connection between the boxes. > > How can I figure out in a script which bin-log can be purged when the > slave that needed it temporalily isn't reachable ? > > I wouldn't dare to purge on each ip-down. > > ----------------------------------------------- > > And by the way ... what is this "replication client" privilege, I saw in > the user table on MySQL.com's Linux binary 4.0.4 ? > > And by another way ... the Win-Binary has neither REPLICATION SLAVE nor > REPLICATION CLIENT privilege in the user table. > > So the replicant-user must have REPLICATION SLAVE on Linux but oviously > has to get FILE on Win. Otherwise 2-way won't work. > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
