Database services play a vital role within today's corporate infrastructure, and yet this chapter is not aimed at programmers, database administrators, or developers. Instead, the following pages will take the alternative point of view in order to develop the conversation for system administrators and troubleshooters who are primarily working with CentOS 7. So, let's begin our journey by looking at some of the more common problems associated with databases as a whole in order to provide a troubleshooter's guide to MariaDB, MySQL, and PostgreSQL.
In this chapter, we will:
Learn how to get up-and-running with MariaDB on CentOS 7
Learn how to reset and recover a lost password for the root user with MariaDB
Learn how to tune both MariaDB and MySQL server with
mysqltuner
Discover how to run metrics across the MariaDB and MySQL servers
Learn how to remove MariaDB and return to the MySQL server
Learn how to install and configure PostgreSQL on CentOS 7