Setting up a sample database

In order to properly test our MariaDB database server, we need a database populated with sample data. For this reason, we will use the Employees database, developed by Patrick Crews and Giuseppe Maxia and provided by Oracle Corporation under a Creative Commons Attribution-Share Alike 3.0 Unported License. It provides a very large dataset (~160 MB and ~4 million records) spread over six tables, which will be ideal for our performance tests.

Note

The Creative Commons Attribution-Share Alike 3.0 Unported License, available at http://creativecommons.org/licenses/by-sa/3.0/, grants us the following freedoms regarding the Employees database:

Share: This lets us copy and redistribute the material in any medium or format

Adapt: This lets us remix, transform, and build upon the material

for any purpose, even commercially.

The licensor cannot revoke these freedoms as long as you follow the license terms.

Downloading and installing the Employees database

Let's proceed with...