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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We're in the process of phasing out an old system and migrating onto a new one. The last time that we phased out an old system, we ran both systems in parallel and integrated data between both until everything was fully migrated out in our field. During that process, I was able to build an integration between our legacy system and our new system that leveraged SQL Server's Change Data Capture to track changes and integrate those over incrementally.

For this next migration, the legacy system that we will be phasing out is based on MySQL v5.1.69 instead of SQL Server. I am not familiar with MySQL and I was wondering if there are any technologies similar to CDC that can be leveraged on MySQL in our current version or a newer version that would be worth migrating towards?

share|improve this question
up vote 1 down vote accepted

LinkedIn has open-sourced their CDC tool Databus, which supports MySQL.

Another open source CDC tool (implemented in PHP) was written as a part of the FlexViews project.

share|improve this answer
Awesome. Thanks, I'll check those out. – njkroes Apr 22 '14 at 20:50

You could try brew something based on the Triggers (AFTER INSERT, DELETE, UPDATE). I would think it depends on the Target System. How did CDC work? Did it propagate all the data and structure to a MySQL Database?

You can use the Triggers to fill a kind of work queues, so that if an entry EntryARownrX from table A gets changed, you stuff that info (table A, row nr X, Update/Insert/Delete) in a Queue Table and then transform that change to your new System (with reading the actual value of data directly from A for Insert or Update).

share|improve this answer
Yeah, triggers are definitely an option. The nice thing about CDC is that it would automatically create and propagate tables based on inserts, updates and deletes without manually having to create the triggers. – njkroes Apr 22 '14 at 20:49

Your Answer


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.