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
