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???

Akshath Hegde

Options: ReplyQuote

Written By
January 31, 2016 11:48PM
February 01, 2016 08:07PM
February 01, 2016 09:43PM
February 02, 2016 09:29PM
Re: MYSQL - CDC Capturing
February 03, 2016 12:23AM
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.