Re: SOLR as nosql database store

Thanks Walter and Mike. In our use case we have same schema on both source and target sites. The idea is if we can avoid mysql replication on the target site for a particular table in our mysql schema. Currently, we index some of the fields in that table in solr, we want to move all the fields to s

Re: SOLR as nosql database store

Yes Mike we have CDCR replication as well. On Wed, May 10, 2017 at 1:15 AM, Mike Drob wrote: > > The searching install will be able to rebuild itself from the data > storage install when that > is required. > > Is this a use case for CDCR? > > Mike > > On Tue, May 9, 2017 at 6:39 AM, Shawn Heise

Re: SOLR as nosql database store

CDCR doesn’t rebuild it so much as copy it. To change the schema, you’ll need to reindex. I’ve worked on two NoSQL databases (Objectivity and MarkLogic) and I’ve worked on Solr. They are utterly different designs, intended to do different things. wunder Walter Underwood wun...@wunderwood.org ht

Re: SOLR as nosql database store

On 5/10/2017 2:15 AM, Mike Drob wrote: >> The searching install will be able to rebuild itself from the data > storage install when that > is required. > > Is this a use case for CDCR? Does CDCR require an identical schema between locations? If not, then I think CDCR can keep a searching install

Re: SOLR as nosql database store

> The searching install will be able to rebuild itself from the data storage install when that is required. Is this a use case for CDCR? Mike On Tue, May 9, 2017 at 6:39 AM, Shawn Heisey wrote: > On 5/9/2017 12:58 AM, Bharath Kumar wrote: > > Thanks Hrishikesh and Dave. We use SOLR cloud with

Re: SOLR as nosql database store

Thanks Shawn and Rick for your suggestions. We will surely look at these options. On Tue, May 9, 2017 at 4:39 AM, Shawn Heisey wrote: > On 5/9/2017 12:58 AM, Bharath Kumar wrote: > > Thanks Hrishikesh and Dave. We use SOLR cloud with 2 extra replicas, > will that not serve as backup when somethi

Re: SOLR as nosql database store

On 5/9/2017 12:58 AM, Bharath Kumar 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 tha

Re: SOLR as nosql database store

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 ED

Re: SOLR as nosql database store

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

Re: SOLR as nosql database store

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 > 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

Re: SOLR as nosql database store

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 But if you design your system such that at-least one copy of the raw data is stored in some ot