
Apache Solr for Indexing Data
By :

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.
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...
Change the font size
Change margin width
Change background colour