Birmingham mumbai

Logical Volume Manager
 (
LVM
) for the partition that 
houses your database files. This will certainly spare you grief in the long run. As 
we've discussed in 
Chapter 9
, 
Managing Storage Volumes
, LVM makes it very simple to 
expand a filesystem, especially on a virtual machine. 

---

Managing Databases
[
 328 
]
If your database server is on a virtual machine, you can add a disk to the volume 
group and expand it if your database partition starts to get full, and your customers 
will never notice there was ever about to be a problem. Without LVM, you'll need to 
shut down the server, add a new volume, 
rsync
 your database server files over to the 
new location, and then bring up the server. Depending on the size of your database, 
this situation can span hours. Do yourself a favor, use LVM.
With that out of the way, we can begin setting up MariaDB. For learning and testing 
purposes, you can use pretty much any server you'd
 like; physical, virtual, or 
Virtual 
Private Server
 (
VPS
). Once you're ready, let's move on and we'll get started!
Installing MariaDB
Now we've come to the fun part, installing MariaDB. To get the ball rolling, we'll 
install the 
mariadb-server
 package:
sudo apt install mariadb-server 
If your organization prefers to stick with MySQL, the package to install is 
mysql-
server
 instead:
sudo apt install mysql-server 
Going forward, I'll assume that you've installed MariaDB, though the instructions 
here shouldn't differ much between them. For the name of the service, you'll want to 
substitute 
mariadb
 for 
mysql
 whenever I mention it if you are using MySQL instead. 
However, keep in mind that compatibility with MySQL cannot be guaranteed. 
Previous versions of Ubuntu Server used 
mysql
 for the service name, even when 
installing MariaDB (Ubuntu 16.04 is an example of this). This is just something to 
keep in mind if you're supporting a legacy edition of Ubuntu.
Although it might be tempting to try out both MySQL and 
MariaDB to compare and contrast their differences, I don't 
recommend switching from MariaDB to MySQL (or vice versa) on 
the same server. I've seen some very strange configuration issues 
occur on servers that had one installed and then were switched 
to the other (even after wiping the configuration). For the most