How can I synchronize mysql data with Elasticsearch data in real time?

Recently, in a project, we need to use Elasticsearch for a product search. what should we do to keep mysql data synchronized with Elasticsearch data in real time, what I can think of now is to update Elasticsearch every time database operations are involved, but in this case... recently, in a project, we need to use Elasticsearch for a product search. what should we do to keep mysql data synchronized with Elasticsearch data in real time, what I can think of now is to update Elasticsearch every time it involves database operations. However, this requires too many changes to the original program, because it only uses mysql, please provide a better solution. thank you !!!

Reply content:

Recently, in a project, we need to use Elasticsearch for a product search. what should we do to keep mysql data synchronized with Elasticsearch data in real time, what I can think of now is to update Elasticsearch every time it involves database operations. However, this requires too many changes to the original program, because it only uses mysql, please provide a better solution. thank you !!!

What is the amount of changes every day?
If the inventory, sales, and other frequently changing data are isolated or updated periodically, the frequency is well controlled.
I am using a trigger.
Http://www.toozy.cn/mysql-trigger-elasticsearch/