The NoSQL DB can be Mongo Couch or something else. Choose a document DB by preference. You can add to these faster than MySQL (I think, test for sure). These DB's can have replicas easily. Choose one of them and use a simple script to index into Solr. Cheers -- Rick
On May 9, 2017 2:58:21 AM EDT, Bharath Kumar <bharath.mvku...@gmail.com> wrote: >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" -- Sorry for being brief. Alternate email is rickleir at yahoo dot com
