Proposals/Elasticsearch Plugin

Developer's notes

Plugin administration

• Elastic Search Types are table names (usr,interaction_instance,interaction_forum_post,view,group,artefact)
• Everytime the settings are saved, the mapping of each type is updated, and the triggers on each table are dropped and re-created. MySQL is not supported at the moment. The functions in ESindexing need to be updated for MySQL.
• Resetting a type inserts all the records of the related table into elasticsearch_queue.
• Indexing is done on cron tun.

Indexing

Every time a record is inserted, updated or deleted in one of the selected table, a DB trigger inserts the id and type of that record into elasticsearch_queue.

The original idea was creating more hooks on the different types, but it would be more time consuming and complicated.