How to automatically synchronize to manticoresearch when mysql data changes？

[Rise-fei]

How to synchronize data in mysql to manticoresearch in real time, such as insert update delete SQL？ Is there any simpler way, such as the binlog tool that monitors mysql, or other tools?

[sanikolaev]

There's no tool which monitors mysql binlog and updates Manticore automatically. You can use the main+delta schema which is well explained in the docs and at https://play.manticoresearch.com . You can then expect a few seconds resolution. Alternatively, you can write a script which gets triggered when mysql is updated and syncs the change to Manticore.

[starinacool]

It might be possible to use a mysql trigger that monitors insert and updates to a certain table and than updates manticore table via SphinxSE.