I'm completley new to elastic search but I run a website with quoite a lot of data and just MySQL doesn't do it for me anymore.
I would love some help on how to set up my index. My site has users, each user can create as many blogs they want to. A blog has posts. Every post has a location_id. The locations table have many locations.
Every user will have a currently_in_location_id from where they were last as well as a from_location_id that tells where they are from.
The locations table will rarely change, but it will get things added. But users currently_in_location_id will change every few days.
I'm not sure how i should build the index, especially in regards to the locations as a posts location could be "Brazil", or it could be "Copenhagen, Denmark" or "Panjim, Goa, India"
Below i have tried to give an examble of how my data can look:
STRUCTURE OF THE DATA
BELOW IS SOME SAMPLE DATA
LOCATION (There is no predefined depht here, the child relations goes on for 0-10 levels)
location_name: Stockholm County
location_name: Gamla Stan
blog_title: Bob's blog
bost_title: Hello Moscow
post_body: I have now arrived in Moscow, it's great
published_at: 2016-20-21 13:37:00
updated_at: 2016-10-21 00:42:00
Any advice on how to build my index for this data is appreciated!