You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by "@Nandan@" <na...@gmail.com> on 2018/02/17 17:16:46 UTC
Index data from mysql DB to Solr - From Scratch
Hi Team,
I am working on one e-commerce project in which my data is storing into
MySQL DB.
As currently we are using mysql search but planning to implement Solr
search to provide our customers more facilities.
Just for development purpose ,I am trying to do experiments into localhost.
Please guide me how can I Achieve it. Please provide some information links
which I can refer to learn more in details from scratch.
Thanks and Best Regards,
Nandan Priyadarshi
Re: Index data from mysql DB to Solr - From Scratch
Posted by Gora Mohanty <go...@mimirtech.com>.
On 18 February 2018 at 08:18, @Nandan@ <na...@gmail.com>
wrote:
> Thanks Rick.
> Is it possible to get some demo learning video link or web links from
> where I can get overview with real example?
> By which I can able to know in more details.
>
Searching Google for "Solr index data database" turns up many links with
examples, e.g.,
http://blog.comperiosearch.com/blog/2014/08/28/indexing-database-using-solr/
Regards,
Gora
Re: Index data from mysql DB to Solr - From Scratch
Posted by "@Nandan@" <na...@gmail.com>.
Thanks Rick.
Is it possible to get some demo learning video link or web links from
where I can get overview with real example?
By which I can able to know in more details.
On Feb 18, 2018 4:11 AM, "Rick Leir" <rl...@leirtech.com> wrote:
> Nandan
> Work backwards from your results screen. When a user has done a search,
> what information would you like to appear on the screen?
>
> That tells you what your Solr document needs to contain. How will you get
> that information into the Solr document? You will do the SQL select(s) as
> necessary, get the info from MySQL, build a flat JSON record containing
> all that info for one document, and POST it to Solr. Repeat for all
> documents. Do a commit. Sorry, I Left out all the details! Cheers -- Rick
>
> On February 17, 2018 12:56:59 PM EST, "@Nandan@" <
> nandanpriyadarshi298@gmail.com> wrote:
> >Hi David ,
> >Thanks for your reply.
> >My few questions are :-
> >1) I have to denormalize my MySQL data manually or some process is
> >there.
> >2) is it like when Data will insert into my MySQL , it has to auto
> >index
> >into solr ?
> >
> >Please explain these .
> >Thanks
> >
> >On Feb 18, 2018 1:51 AM, "David Hastings" <DH...@wshein.com> wrote:
> >
> >> Your first step is to denormalize your data into a flat data
> >structure.
> >> Then index that into your solr instance. Then you’re done
> >>
> >> On Feb 17, 2018, at 12:16 PM, @Nandan@
> ><nandanpriyadarshi298@gmail.com
> >> <ma...@gmail.com>> wrote:
> >>
> >> Hi Team,
> >> I am working on one e-commerce project in which my data is storing
> >into
> >> MySQL DB.
> >> As currently we are using mysql search but planning to implement Solr
> >> search to provide our customers more facilities.
> >> Just for development purpose ,I am trying to do experiments into
> >localhost.
> >> Please guide me how can I Achieve it. Please provide some information
> >links
> >> which I can refer to learn more in details from scratch.
> >>
> >> Thanks and Best Regards,
> >> Nandan Priyadarshi
> >>
>
> --
> Sorry for being brief. Alternate email is rickleir at yahoo dot com
Re: Index data from mysql DB to Solr - From Scratch
Posted by Rick Leir <rl...@leirtech.com>.
Nandan
Work backwards from your results screen. When a user has done a search, what information would you like to appear on the screen?
That tells you what your Solr document needs to contain. How will you get that information into the Solr document? You will do the SQL select(s) as necessary, get the info from MySQL, build a flat JSON record containing all that info for one document, and POST it to Solr. Repeat for all documents. Do a commit. Sorry, I Left out all the details! Cheers -- Rick
On February 17, 2018 12:56:59 PM EST, "@Nandan@" <na...@gmail.com> wrote:
>Hi David ,
>Thanks for your reply.
>My few questions are :-
>1) I have to denormalize my MySQL data manually or some process is
>there.
>2) is it like when Data will insert into my MySQL , it has to auto
>index
>into solr ?
>
>Please explain these .
>Thanks
>
>On Feb 18, 2018 1:51 AM, "David Hastings" <DH...@wshein.com> wrote:
>
>> Your first step is to denormalize your data into a flat data
>structure.
>> Then index that into your solr instance. Then you’re done
>>
>> On Feb 17, 2018, at 12:16 PM, @Nandan@
><nandanpriyadarshi298@gmail.com
>> <ma...@gmail.com>> wrote:
>>
>> Hi Team,
>> I am working on one e-commerce project in which my data is storing
>into
>> MySQL DB.
>> As currently we are using mysql search but planning to implement Solr
>> search to provide our customers more facilities.
>> Just for development purpose ,I am trying to do experiments into
>localhost.
>> Please guide me how can I Achieve it. Please provide some information
>links
>> which I can refer to learn more in details from scratch.
>>
>> Thanks and Best Regards,
>> Nandan Priyadarshi
>>
--
Sorry for being brief. Alternate email is rickleir at yahoo dot com
Re: Index data from mysql DB to Solr - From Scratch
Posted by "@Nandan@" <na...@gmail.com>.
Hi David ,
Thanks for your reply.
My few questions are :-
1) I have to denormalize my MySQL data manually or some process is there.
2) is it like when Data will insert into my MySQL , it has to auto index
into solr ?
Please explain these .
Thanks
On Feb 18, 2018 1:51 AM, "David Hastings" <DH...@wshein.com> wrote:
> Your first step is to denormalize your data into a flat data structure.
> Then index that into your solr instance. Then you’re done
>
> On Feb 17, 2018, at 12:16 PM, @Nandan@ <nandanpriyadarshi298@gmail.com
> <ma...@gmail.com>> wrote:
>
> Hi Team,
> I am working on one e-commerce project in which my data is storing into
> MySQL DB.
> As currently we are using mysql search but planning to implement Solr
> search to provide our customers more facilities.
> Just for development purpose ,I am trying to do experiments into localhost.
> Please guide me how can I Achieve it. Please provide some information links
> which I can refer to learn more in details from scratch.
>
> Thanks and Best Regards,
> Nandan Priyadarshi
>
Re: Index data from mysql DB to Solr - From Scratch
Posted by David Hastings <DH...@wshein.com>.
Your first step is to denormalize your data into a flat data structure. Then index that into your solr instance. Then you’re done
On Feb 17, 2018, at 12:16 PM, @Nandan@ <na...@gmail.com>> wrote:
Hi Team,
I am working on one e-commerce project in which my data is storing into
MySQL DB.
As currently we are using mysql search but planning to implement Solr
search to provide our customers more facilities.
Just for development purpose ,I am trying to do experiments into localhost.
Please guide me how can I Achieve it. Please provide some information links
which I can refer to learn more in details from scratch.
Thanks and Best Regards,
Nandan Priyadarshi