You could do something like have a process periodically run the non-delete queries in the logs against another database and replicate the second database. Wouldn't be automatic, but you'd have as much control as you like over what goes in the other db.
Depending on what you're trying to do, it may be enough that the logs (including the delete statements) end up on the slave. If your queries against the no-deletes version are trivial, you may be able to just pipe the log output through grep. - James Moore --------------------------------------------------------------------- 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
