Using MySQL to store our service data
In this section, we are going to provide a brief overview of MySQL and demonstrate how to write and read data from the microservices that we created in the previous chapters.
MySQL is an open source relational database that was created in 1995 and since then has become one of the top-used databases across the development industry, according to DB-Engines ranking (https://db-engines.com/en/ranking). It stores data as a set of tables, each consisting of rows and columns of predefined types (such as string, numeric, binary, or more), and allows to data via SQL queries. For example, assume you have the following data, stored as a table called movies:
id |
title |
director |
922 |
New York Stories |
John Jones |
1055 |
Christmas Day ... |