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