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.

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

2 Answers 2

up vote 1 down vote accepted

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

http://engineering.linkedin.com/data-replication/open-sourcing-databus-linkedins-low-latency-change-data-capture-system

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

http://swanhart.livejournal.com/132117.html

share|improve this answer
    
Awesome. Thanks, I'll check those out. –  njkroes Apr 22 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 at 20:49

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.