As an OpenStack administrator, you will most likely rely on an experienced database administrator for all OpenStack-related database maintenance. The official OpenStack exam requirements contain a broad objective to "analyze database servers and back up a database". Here are some basics for working with a MySQL/MariaDB, which should put you in good shape for the exam.
We can use the mysql command-line tool to explore MySQL on our virtual appliance.
Run the following:
$ sudo mysql -h localhost
After connecting, we can run the following command to see all the OpenStack service databases:
MariaDB [(none)]> show databases;
You should see output similar to Figure 10.9
Figure 10.9: Output from the 'show databases' SQL statement
To use a specific database, we can run the following:
MariaDB [(none)]> use nova;
To see all the tables in the Nova...
