lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fuad Efendi (JIRA)" <>
Subject [jira] Issue Comment Edited: (SOLR-1828) DIH Handler separate connection for delta and full index
Date Tue, 07 Dec 2010 18:56:10 GMT


Fuad Efendi edited comment on SOLR-1828 at 12/7/10 1:55 PM:

Performance-related issue & patch: SOLR-2233
This seems to be wrong: MySQL is better optimized for Read-Mostly...? It shouldn't be like
that... all reads should go to slave...

      was (Author: funtick):
    Related issue & patch: SOLR-2233
> DIH Handler separate connection for delta and full index
> --------------------------------------------------------
>                 Key: SOLR-1828
>                 URL:
>             Project: Solr
>          Issue Type: Bug
>          Components: contrib - DataImportHandler
>    Affects Versions: 1.4
>         Environment: Linux
>            Reporter: Bill Bell
> We would like to configure the DIH handler for a SLAVE connection for FULL imports, and
a MASTER connection for DELTA.
> Use case:
> 1. The DIH full index slams the database pretty hard, and we would like those to run
one a day on the SLAVE MYSQL connection.
> 2. The DIH delta index does not hit the database very hard, and we would like that to
run off the MASTER MYSQL connection.
> Currently the DIH handler does not allow a name="db-1" on the deltaQuery="", it is only
at the entity level. Please add it to each delta, full, etc as an option.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message