MySQL Forums
Forum List  »  General

Re: Daily rebuild of a development database.
Posted by: Peter Brawley
Date: June 20, 2016 09:13AM

Good plan to put them on separate servers.

If tests include a lot of data manipulation on the prospective slave, replication may be impractical.

If the change to InnoDB is the big contributor to the slowdown, that may be due to indexing, so consider doing the daily restore on unindexed tables, then adding indexes once all the data is in place.

Options: ReplyQuote


Subject
Written By
Posted
Re: Daily rebuild of a development database.
June 20, 2016 09:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.