在哪里存储搜索索引的数据？

I'm building a search index (Elasticsearch) for existing data in a relational database. Is it common to have duplicated in both the relational database as well as the search index? Or should it just be the search index? How safe is it to have your data stored entirely on say the Elasticsearch cloud?I'm building a search index (Elasticsearch) for