Hi,
I use Elasticsearch to store large continuous sensor data and analyse it later. Some part of my code also includes configurable threshold alert(s). When there is threshold break it triggers alerts. This threshold value is just a single instance and not a bulky continuous data, So I store this in MySQL currently as 'Key-Value' pair.
Is it a good idea to move such small data to Elasticsearch and eliminate MySQL completely? Or should I keep it in MySQL itself?