Is it possible to replicate between two databases on a single server, and if not, then what is the next best solution? I administer a Bugzilla installation with about 1.8GB in a MySQL database. Bugzilla has a built-in replication solution that copies data from a primary database optimized for updates to a "shadow database" optimized for reads.
This replication solution has a few hard-to-find bugs that cause periodic data corruption in the shadow database. We work around these problems by recreating the shadow database from scratch every night, but that causes its own problems with disk space availability (for the dump file) and downtime (it takes up to an hour without compression and up to 1.5 hours with gzip compression to dump the data into a dump file and then import it into the shadow database, and "night" for the bulk of our users is "day" for our other users around the world). So, I'm looking for a better solution. It's possible that I could obtain a second server and hack Bugzilla to handle it, but first I want to find an easier solution if one exists. Is there a way to use MySQL's built-in replication to replicate two databases residing on the same server? If not, is there another replication solution that could do the job? If not, could mysqlhotcopy solve my problems with the nightly shadow database rebuild at least, and if so do I need to do anything more (i.e. lock that database) than point the script at the shadow database directory and let it overwrite those files? -myk --------------------------------------------------------------------- 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
