# Elasticsearch as a primary store

**URL:** https://discuss.elastic.co/t/elasticsearch-as-a-primary-store/132647
**Category:** Elasticsearch
**Created:** [May 21, 2018, 11:26am UTC](https://discuss.elastic.co/t/elasticsearch-as-a-primary-store/132647 "2018-05-21T11:26:10Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Juris\_Rats](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/juris_rats/32/27068_2.png) [@Juris\_Rats](https://discuss.elastic.co/u/Juris_Rats)
#### Post date: [May 21, 2018, 11:26am UTC](https://discuss.elastic.co/t/elasticsearch-as-a-primary-store/132647/1 "2018-05-21T11:26:10Z")

</div>

Hi,  
I have read a number of posts on the issue still not have answers to my questions.  
I want to use ES in a scenario where:

- new and updateable data is replicated to ES indexes from the SQL database (when changes occur)
- old, read only data is stored in ES indexes only

I understand that ES may loose data (in some rare cases). I would like to set up some safe framework to handle those rare cases to be sure the data is not lost.

Questions I have are:

- are there any other use cases appart from the unavailability/crashing of cluster nodes, when the data may be lost? Can data be lost if all cluster nodes are available and working normally?
- is there a method I can safely detect each node unavailability/crash? Is every crash/unavailability logged?
- can data be lost for a read-only index? E.g. - while moved from one node to another because of loosing updates to cluster status?

Will be gratefull for any help  
I use latest version of ES (6.2)

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 18, 2018, 11:26am UTC](https://discuss.elastic.co/t/elasticsearch-as-a-primary-store/132647/2 "2018-06-18T11:26:13Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
