SOLR - Share dataSource/connection String Across Cores

Question

I've a requirement where there will be one instance of SOLR with multiple cores. The data is being pulled from database. We have 3 different search criteria, each business entity have millions of rows. So we created 3 cores. Now the problem is that datasource (Database) is same and only the SQL/tables for retrieving is different. I want to share this connection string across the cores. Each core has data-config.xml in which this connection string is specified. I'd like to specify the connection string at one place only. How to achieve this?

Thanks in advance,

Unni

Still no answers for common datasource for all cores. – unniks Sep 17 '14 at 12:50 — unniks, Sep 17 '14 at 12:50

score 1 · Answer 1 · answered Jul 13 '16 at 18:20

in data-config.xml

<dataConfig>
            <dataSource 
               jndiName="jdbc/somename" 
               type="JdbcDataSource" 
               readOnly="true" 
              />
... Rest your code
</dataConfig>

In etc/jetty.xml

<New id="jdbc" class="org.eclipse.jetty.plus.jndi.Resource">
    <Arg>jdbc/somename</Arg>
    <Arg>
        <New class="com.mysql.jdbc.jdbc2.optional.MysqlDataSource">
            <Set name="Url">jdbc:mysql://localhost:3306/yourdb</Set>
            <Set name="User">user name</Set>
            <Set name="Password"></Set>
        </New>
    </Arg>
</New>

score 0 · Answer 2 · edited Nov 07 '14 at 09:34

0

You need to define your datasource in solrconfig.xml:

       <lst name="defaults">
            <str name="config">data-config.xml</str>
            <lst name="datasource">
                <str name="type">JdbcDataSource</str>
                <str name="driver">oracle.jdbc.driver.OracleDriver</str>
                <str name="url">jdbc:oracle:thin:@localhost:1521:xe</str>
                <str name="user">wbdbuser</str>
                <str name="password">wbdbuser</str>
            </lst>
      </lst>

edited Nov 07 '14 at 09:34

Hamad

5,096
13
37
65

answered Nov 07 '14 at 08:59

Esha

151
8

Still each cores need to have the same configuration. Instead I used jetty to share across multiple cores. – unniks Dec 12 '14 at 12:04
can you please post how you used jetty to share config? – Esha Dec 29 '14 at 10:05
Sorry I did not see this. – unniks Jul 13 '16 at 18:06

SOLR - Share dataSource/connection String Across Cores

2 Answers2

Linked