Level 23
Check this presentation out from Laracon EU (https://m.youtube.com/watch?v=waTWeJeFp4A) to get you started. Some good tips there, especially with the model events for synching new data.
3 likes
Oct 18, 2014
8
Level 24
Laravel with Elasticsearch and keep it sync with MySQL
Hi guys,
I would really appreciate some guidance with this Elasticsearch and MySQL thing. So I am about to start a project and I've been reading about Elasticsearch, but want to use it with MySQL. Given this what is the best approach to keep both synced?
1) Every time I create a record I have to do it in both MySQL and ES? 2) Have no idea...
Please someone point me in the right direction.
Thanks in advance.
Level 24
@noeldiaz thanks! I will definitely take a look.
Level 6
Keep an eye on https://github.com/iverberk/larasearch early days for it and not a tutorial as such but is looking promising!
2 likes
Level 12
fyi - codesq - your link has an extra "," in it -- which makes it 404
Level 13
I've created an easy to use Laravel package to work with elasticsearch. More info here: https://murze.be/2015/01/using-elasticsearch-in-laravel/
Level 3
@freekmurze Thank you for the package. how do you sync data between MYSQL and Elasticsearch? As i understand, I have to save data twice during saving and updating. However, i don't understand, how do I use old data i already have in mysql database. Do you know any method to do that?
Level 24
@anam try this link: http://www.fullstackstanley.com/read/simple-search-with-laravel-and-elasticsearch
He gives this example (not sure this is what you are looking for):
Post::createIndex($shards = null, $replicas = null);
Post::putMapping($ignoreConflicts = true);
Post::addAllToIndex();
Level 3
@hfalucas thank you. Is there any way to copy whole mysql database and transform in to Elasticsearch indexes?
Post::addAllToIndex();
I think above approach is slower.
Please or to participate in this conversation.