In this section, we are going to store objects in an Ignite cache and examine application performance. First, we will create a database-backed RESTful web service to store and fetch soccer players. Next, we will add a caching layer on top of the database layer to improve the query performance:
- Install MySQL (version 8.0.11 or higher version) from the following Oracle URL: https://dev.mysql.com/downloads/installer/. Configure it using the the steps mentioned here: https://youtu.be/UgHRay7gN1g
.
Include MySQL workbench.
- Launch MySQL workbench and create a new database (schema), football:
- In query editor, execute the use SQL command to select our newly created database. The following is the SQL command—use football; (don't forget the semicolon ;).
- Execute the following script to create a table, club. clubno is the primary key and cname is...
