Suggest me solution to track the change in test DB and replicate in Another DB

Posted by Pranav on Server Fault See other posts from Server Fault or by Pranav
Published on 2010-04-08T05:45:47Z Indexed on 2010/04/08 5:53 UTC
Read the original article Hit count: 478

Filed under:
|

Suggest me solution to track the change in test DB and replicate in Another DB...

My Client need a script or any solution, if he has two Database, One Test DB in which he tests his data on test portal and if he find it appropriate he can use those changes to be done in main DB to display on Live site.. Fior this he needs the solution to record or track all updation/deletion/insertion, so that he can do the same in main DB if found appropriate,

NOTE:

we have only one server, no separate server, hence binary log replication doesnt seems to be working for my case..

© Server Fault or respective owner

Suggest me solution to track the change in test DB and replicate in Another DB

Posted by Parth on Stack Overflow See other posts from Stack Overflow or by Parth
Published on 2010-04-08T05:39:23Z Indexed on 2010/04/08 5:43 UTC
Read the original article Hit count: 478

Filed under:
|

Suggest me solution to track the change in test DB and replicate in Another DB...

My Client need a script or any solution, if he has two Database, One Test DB in which he tests his data on test portal and if he find it appropriate he can use those changes to be done in main DB to display on Live site.. Fior this he needs the solution to record or track all updation/deletion/insertion, so that he can do the same in main DB if found appropriate,

**

NOTE:

** we hav only on server, no separate server, hence binary log replication doesnt seems to be working for my case...

© Stack Overflow or respective owner

Related posts about mysql-replication

Related posts about mysql