Replication "on commit"
I'll put you in context before asking my question: I have two servers, Dev
and Prod. What I would like to do is have a replication between the 2 DBs
(MySQL 5.5). But I don't want the 2 DBs to always be in sync. All the
modifications (data and files) will be done on the Dev server, so I would
like the Dev's DB replicated on the live one only when I "commit" the
changes made on the Dev server. What I want is to have a kind of
versioning between my 2 DBs with ideally no down time (obviously).
Is this something possible?
Would it be a better idea to setup a SVN server for that?
I have already searched on the internet, but I didn't come across someone
doing this.
Thank you!
No comments:
Post a Comment