Book Image

Preparing for the Certified OpenStack Administrator Exam

By : Matt Dorn
Book Image

Preparing for the Certified OpenStack Administrator Exam

By: Matt Dorn

Overview of this book

This book provides you with a specific strategy to pass the OpenStack Foundation’s first professional certification: the Certified OpenStack Administrator. In a recent survey, 78% of respondents said the OpenStack skills shortage had deterred them from adopting OpenStack. Consider this an opportunity to increase employer and customer confidence by proving you have the skills required to administrate real-world OpenStack clouds. You will begin your journey by getting well-versed with the OpenStack environment, understanding the benefits of taking the exam, and installing an included OpenStack All-in-One Virtual Appliance to work through objectives covered throughout the book. After exploring the basics of the individual services, you will be introduced to strategies to accomplish the exam objectives relevant to Keystone, Glance, Nova, Neutron, Cinder, Swift, Heat, and troubleshooting. Finally, you’ll benefit from the special tips section and a practice exam to put your knowledge to the test. By the end of the journey, you will be ready to become a Certified OpenStack Administrator!
Table of Contents (13 chapters)

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