Hi,
Ofer Inbar wrote:
We've got a couple of production databases using mostly MyISAM tables,
that can't be taken offline without bringing down our application. To
reduce downtime, we run a full mysqldump once a week and back up the
binary logs every day, so we can always use them to "catch up" from
the most recent full dump. Because we're mostly using MyISAM we can't
make the dump a transaction, so the database is very slow for about 10
minutes while we run the dump. This will get longer and longer as our
database grows.
We could eliminate the slowness entirely if we ran full dumps off a
replication slave. We could do it on a slave not in use by the
This doesn't address your question directly, but I have gotten in the habit of warning
people to verify that their slaves do have exactly the same data as the master. Many
people assume it does, but when they check, they find out there are differences,
usually attributable to bugs in replication. Backing up from slaves is wonderful, but
it is only a good idea if the slave's data is right :-)
This is why I wrote MySQL Table Checksum, currently as far as I know the only way to
verify a slave's data: http://mysqltoolkit.sourceforge.net/
cheers
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
