How to keep mysql data and Elasticsearch data synchronized in real time?

I am working on a project recently, and I need to use Elasticsearch to do a product search. What should I do to keep mysql data and Elasticsearch data synchronized in real time? All I can think of now is to update every time it involves database operations. Elasticsearch, but in this case, there will be too many modifications to the original program, because the original program only uses mysql. Please provide a better solution, thank you! ! !

Reply content:

I am working on a project recently, and I need to use Elasticsearch to do a product search. What should I do to keep mysql data and Elasticsearch data synchronized in real time? All I can think of now is to update every time it involves database operations. Elasticsearch, but in this case, there will be too many modifications to the original program, because the original program only uses mysql. Please provide a better solution, thank you! ! !

How big are the daily changes?
If frequently changing data such as inventory and sales volume are isolated, or updated periodically, the frequency is controlled.
I handle it through triggers.
http://www.toozy.cn/mysql-trigger-elasticsearch/