Use ElasticSearch to serve HTML pages

Question

I'm developing an application where users can create their own web pages. For this, they can create static HTML pages from their admin panel. Then this pages can be published on their web pages.

The fields of a page are: id, title, content, url.

The functionality is the next:

• Users has their own templates, this template includes a file called base.html where are the header, body, etc.. and all pages that they create inside the admin panel will be displayed inside this base.html file. So that "pages" they create in the backend only includes the content of the page, not the header, footer, etc..

• Also, the application allows users other functionality like a blog, and users can use some variables to display content inside their pages. Eg:

  {% for post in last_post %}

  {{ post.title }}

  {{ post.content|slice(0,255) }}

  {% endfor %}

Nowadays I'm saving this pages in MySQL and when a page is requested I search into MySql by the url field. The traffic has increased and I want to speed up the reads from the database and I have thought in use ElasticSearch for this.

My question is if could be a good idea, continue saving this HTML pages in MySQL and also in ElasticSearch. Then when a page is requested from the web page of the user make reads from ElasticSearch.

Thanks in advance for help

Answer 1

You can use elasticsearch - but just for a Key-Value lookup, it may be overkill - It makes more sense if your query is more than a key value lookup.

Have you considered using redis to speedup things ?