Birmingham mumbai

[
 325 
]
13
Managing Databases
The Linux platform has long been a very popular choice for hosting databases. Given 
the fact that databases power a large majority of popular websites across the internet 
nowadays, this is a very important role for servers to fill. Ubuntu Server is also a 
very popular choice for this purpose, as its stability is a major benefit to the hosting 
community. This time around, we'll take a look at MariaDB, a popular fork of 
MySQL. The goal won't be to provide a full walkthrough of MySQL's syntax (as that 
would be a full book in and of itself), but we'll focus on setting up and maintaining 
database servers utilizing MariaDB, and we'll even go over how to set up a primary/
secondary relationship between them. If you already have a firm understanding of 
how to architect databases, you'll still benefit from this chapter as we'll be discussing 
Ubuntu's implementation of MariaDB in particular, which has its configuration 
organized a bit differently than in other platforms.
As we work through setting up our very own MariaDB server, we will cover the 
following topics:
•  Preparations for setting up a database server
•  Installing MariaDB
• 
Understanding the MariaDB configuration files
•  Managing MariaDB databases
•  Setting up a secondary database server
As with setting up any server for a particular purpose, we should first think about 
the goal and plan accordingly. So in the next section, we'll talk about some of the 
higher-level details to consider while preparing a database server.

---

Managing Databases