Hi Bharath, In general its not a good idea to use Solr as the *primary data store* for various reasons listed here,
https://wiki.apache.org/solr/HowToReindex <https://wiki.apache.org/solr/HowToReindex> But if you design your system such that at-least one copy of the raw data is stored in some other storage system then you can use Solr as the operational database. Hope this helps. -Hrishikesh On Mon, May 8, 2017 at 7:43 PM, bharath.mvkumar <bharath.mvku...@gmail.com> wrote: > Hi All, > > We have a use case where we have mysql database which stores documents and > also some of the fields in the document is also indexed in solr. > We plan to move all those documents to solr by making solr as the nosql > datastore for storing those documents. The reason we plan to do this is > because we have to support cross center data replication for both mysql and > solr and we are in a way duplicating the same data.The number of writes we > do per second is around 10,000. Also currently we have only one shard and > we > have around 70 million records and we plan to support close to 1 billion > records and also perform sharding. > > Using solr as the nosql database is a good choice or should we look at > Cassandra for our use case? > > Thanks, > Bharath Kumar > > > > -- > View this message in context: http://lucene.472066.n3. > nabble.com/SOLR-as-nosql-database-store-tp4334119.html > Sent from the Solr - User mailing list archive at Nabble.com. >
