Elasticsearch do site search, index and MySQL data table synchronization problem

Using Elasticsearch to do site search, background frame is laravel, so use this laravel package, "Elasticquent" (https://github.com/elasticquent/Elasticquent) ,

Problem:
If there is a artiles table in MySQL, and now there is a new article to join, then how does the Elasticsearch index automatically synchronize the data in the MySQL artiles table?

Reply content:

Using Elasticsearch to do site search, background frame is laravel, so use this laravel package, "Elasticquent" (https://github.com/elasticquent/Elasticquent) ,

Problem:
If there is a artiles table in MySQL, and now there is a new article to join, then how does the Elasticsearch index automatically synchronize the data in the MySQL artiles table?

and es.cn on the same content ....
Well, I'll stick around, too.

There are several ways to look at the choice:
1. Double write in the business system

2. Use tools such as ELASTICSEARCH-JDBC to do full and incremental synchronization

3. Use Ali's Canal to do database Binlog->kafka->es synchronization, need to develop, and rely on more, small companies choose to be cautious about it

