Replace Elasticsearch with MySQL on production / cloud

58 views
Skip to first unread message

Big Tom

unread,
Nov 15, 2015, 10:57:56 PM11/15/15
to Light Admin Group
I love this project but Elasticsearch is giving me hell. I'm using spring boot / JPA / Hibernate and I'm using JDK-8 on Kubuntu Trusty only. There's a problem with LA servlet being very sensitive to previous initialization of the ES data directory.  Different behaviour is displayed when I'm doing hot deployment via Eclipse, or if I use Maven deployment via the war plugin. On the other hand, the spring-boot plugin shows other behaviour. It's totally capricious. Very often the application will not load LA. I've devised a method by which lightadmin only works on Eclipse (Mars) hot deployment if I clean the Tomcat (v8.0.24) work directory and rebuild the project. On the cloud (Pivotal) I have no idea where the Elasticsearch data directory is installed and I have a hunch it's eating up resources. My simple one page site consumes ~900mb of RAM. I'm already using MySQL, which is a paid service on Pivotal (ClearDB).

So... The bottom line is, and most crucial to me... Is there a way to replace the Elasticsearch persistence layer with JPA and use my own database for both my application and the LA administrative UI?

BTW the demos run on MySQL like a char, No problem at all. Very nice work!

Cheers

Tom
Reply all
Reply to author
Forward
0 new messages