Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to setup a development database such that it'll initially be a mirror of the database used in production. At fixed points during the day (maybe midnight or something) and/or manually, I want it to be sync'd once again with the production DB.

My goal is to have a database I can play and mess with, with no lasting consequences. I've looked at replication, and it doesn't seem to be a good fit for this scenario. See, what I thought initially is that I could set up a slave, dump it, do my work, then use the dump to revert it to its previous (pristine?) state, before syncing with the master. Repeat when needed. While I might be able to get away with this with relatively small DBs, 8 gigs worth of dumps tend to take a while to be generated and imported. Plus I'd like to be able to have something that will scale to several devs.

Any hints as to where I should look next?

share|improve this question
    
@Neil Santos - Welcome! hope posted answers will help... please mark accepted answer. –  Coder Hawk May 13 '11 at 7:27
add comment

migrated from stackoverflow.com May 9 '11 at 12:35

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 4 down vote accepted

You can look into MySQL snapshots using the file system. More details in this link. Snapshots are very quick to create, and can be rolled back to.

share|improve this answer
    
Thanks for the tip! –  Neil Santos May 17 '11 at 11:37
add comment

For Oracle it's quite easy, a snapshot standby database would do the trick for you. Maybe Oracle will integrate this capability in mysql .... With 8GB databases, making a new copy should not give a lot of problems .... 15 minutes for a copy?

share|improve this answer
    
Thanks for the reply; I'll keep this in mind, if I find myself working with Oracle. :) –  Neil Santos May 17 '11 at 11:36
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.