MySQL Forums
Forum List  »  Partitioning

Re: MYSQL - CDC Capturing
Posted by: Akshath Hegde
Date: February 03, 2016 12:23AM

Hi Rick,

We have one table in mysql, which will be updated continuously from Customer (We have given table permission to Customers).

Table structure given by Customer only. So they have strictly told us we should not add any extra column to that table.

Now problem is they keep updating records in bulk, sometimes they update 2-5lakhs of records in single update. We want to capture these updates.


Currently we have On update Trigger on this table. But I want to capture a updated row without using Trigger.


is there any other way in MYSQL to do this???

Regards,
Akshath Hegde

Options: ReplyQuote


Subject
Views
Written By
Posted
5475
January 31, 2016 11:48PM
1913
February 01, 2016 08:07PM
1694
February 01, 2016 09:43PM
1620
February 02, 2016 09:29PM
Re: MYSQL - CDC Capturing
1804
February 03, 2016 12:23AM
1734
February 04, 2016 10:38PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.