Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Apache Solr for Indexing Data
  • Toc
  • feedback
Apache Solr for Indexing Data

Apache Solr for Indexing Data

By : Handiekar, Johri
1 (1)
close
Apache Solr for Indexing Data

Apache Solr for Indexing Data

1 (1)
By: Handiekar, Johri

Overview of this book

Apache Solr is a widely used, open source enterprise search server that delivers powerful indexing and searching features. These features help fetch relevant information from various sources and documentation. Solr also combines with other open source tools such as Apache Tika and Apache Nutch to provide more powerful features. This fast-paced guide starts by helping you set up Solr and get acquainted with its basic building blocks, to give you a better understanding of Solr indexing. You’ll quickly move on to indexing text and boosting the indexing time. Next, you’ll focus on basic indexing techniques, various index handlers designed to modify documents, and indexing a structured data source through Data Import Handler. Moving on, you will learn techniques to perform real-time indexing and atomic updates, as well as more advanced indexing techniques such as de-duplication. Later on, we’ll help you set up a cluster of Solr servers that combine fault tolerance and high availability. You will also gain insights into working scenarios of different aspects of Solr and how to use Solr with e-commerce data. By the end of the book, you will be competent and confident working with indexing and will have a good knowledge base to efficiently program elements.
Table of Contents (13 chapters)
close
12
Index

Indexing data from MySQL


In this section, we'll see how we can set up a MySQL database in Solr to index our data from the database to Solr directly. To do this, we'll use the musicCatalog schema, which we developed in previous chapters, and we will create a similar table to hold the data in the MySQL database.

Configuring datasource

We're assuming that you already have a MySQL database running on your machine. In the MySQL database, we'll need to create the following table to hold the musicCatalogue data.

Let's go ahead and create a database called solrIndexingExample in MySQL. We can use the following SQL to create a new database:

create database solrIndexingExample;

use solrIndexingExample;

After we have created the database, we'll need to create a table that will hold our data for musicCatalog. We can use this SQL query to create a table:

CREATE TABLE musiccatalog (
  songId int(11) NOT NULL AUTO_INCREMENT,
  songName varchar(250) DEFAULT NULL,
  artistName varchar(250) DEFAULT NULL,
  albumArtist...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete