Mastering Ubuntu Server - Third Edition by Jay LaCroix

Author:Jay LaCroix
Language: eng
Format: epub
Tags: COM046070 - COMPUTERS / Operating Systems / Linux, COM046000 - COMPUTERS / Operating Systems / General, COM046030 - COMPUTERS / Operating Systems / UNIX
Publisher: Packt
Published: 2020-12-23T14:56:11+00:00

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

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.