MySQL Forums :: Partitioning :: MYSQL - CDC Capturing

Advanced Search

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

Subject Views Written By Posted
MYSQL - CDC Capturing 1203 Akshath Hegde 01/31/2016 11:48PM
Re: MYSQL - CDC Capturing 609 Rick James 02/01/2016 08:07PM
Re: MYSQL - CDC Capturing 599 Akshath Hegde 02/01/2016 09:43PM
Re: MYSQL - CDC Capturing 550 Rick James 02/02/2016 09:29PM
Re: MYSQL - CDC Capturing 586 Akshath Hegde 02/03/2016 12:23AM
Re: MYSQL - CDC Capturing 481 Rick James 02/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.