Managing MySQL

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...