Tracking the update or changes in mysql table
Posted by: Rituraj vats
Date: June 15, 2015 08:19AM

I need to stream the changes to elasticsearch to keep in sync with my database(mysql).
What will be best way to do this ? I have thought for below approaches

1.Using trigger( but my table will have billions of data and the application will have frequent update so trigger may be costly.)

2.Using delta/history table (this will add the extra effort in development and this will cause the lot many joins )

Is there any out of box solution or any other way which will have the better performance and less complexity.

Options: ReplyQuote


Subject
Written By
Posted
Tracking the update or changes in mysql table
June 15, 2015 08:19AM


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.