Thanks Hrishikesh and Dave. We use SOLR cloud with 2 extra replicas, will that not serve as backup when something goes wrong? Also we use latest solr 6 and from the documentation of solr, the indexing performance has been good. The reason is that we are using MySQL as the primary data store and the performance might not be optimal if we write data at a very rapid rate. Already we index almost half the fields that are in MySQL in solr.
On Mon, May 8, 2017 at 9:24 PM, Dave <hastings.recurs...@gmail.com> wrote: > You will want to have both solr and a sql/nosql data storage option. They > serve different purposes > > > > On May 8, 2017, at 10: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. > -- Thanks & Regards, Bharath MV Kumar "Life is short, enjoy every moment of it"
