Elasticsearch performs on-site search, synchronization problem between index and mysql data table

Use Elasticsearch for on-site search, the background framework is laravel, so the laravel package used, "Elasticquent" (https://github.com/elasticquent/Elasticquent),

Question:
If there is an articles table in mysql and a new article is added, how does the Elasticsearch index automatically synchronize the data in the articles table of mysql?

Reply content:

Use Elasticsearch for on-site search, the background framework is laravel, so the laravel package used, "Elasticquent" (https://github.com/elasticquent/Elasticquent),

Question:
If there is an articles table in mysql and a new article is added, how does the Elasticsearch index automatically synchronize the data in the articles table of mysql?

It turns out to be the same content as on es.cn. . . .
Then I’ll stick with you too

There are several methods, take a look and choose:
1. Do double writing in the business system

2. Use tools such as elasticsearch-jdbc for full and incremental synchronization

3. Use Alibaba’s canal to synchronize the database binlog->kafka->es, which requires development and has many dependencies. Small companies should be more cautious when choosing