Apache Solr

This is the implementation of the Solr data handler for MindsDB.

Apache Solr is a highly reliable, scalable and fault tolerant, providing distributed indexing, replication and load-balanced querying, automated failover and recovery, centralized configuration, and more.

​

Prerequisites

Before proceeding, ensure the following prerequisites are met:

1. Install MindsDB locally via Docker or Docker Desktop.
2. To connect Apache Solr to MindsDB, install the required dependencies following this instruction.
3. Install or ensure access to Apache Solr.

​

Implementation

This handler is implemented using the sqlalchemy-solr library, which provides a Python/SQLAlchemy interface.

The required arguments to establish a connection are as follows:

• username is the username used to authenticate with the Solr server. This parameter is optional.
• password is the password to authenticate the user with the Solr server. This parameter is optional.
• host is the host name or IP address of the Solr server.
• port is the port number of the Solr server.
• server_path defaults to solr if not provided.
• collection is the Solr Collection name.
• use_ssl defaults to false if not provided.

​

Usage

In order to make use of this handler and connect to the Solr database in MindsDB, the following syntax can be used:

CREATE DATABASE solr_datasource
WITH
    engine = 'solr',
    parameters = {
      "username": "demo_user",
      "password": "demo_password",
      "host": "127.0.0.1",
      "port": "8981",
      "server_path": "solr",
      "collection": "gettingstarted",
      "use_ssl": "false"
    };

You can use this established connection to query your table as follows:

SELECT *
FROM solr_datasource.gettingstarted
LIMIT 10000;