Book Image

MariaDb Essentials

Book Image

MariaDb Essentials

Overview of this book

This book will take you through all the nitty-gritty parts of MariaDB, right from the creation of your database all the way to using MariaDB’s advanced features. At the very beginning, we show you the basics, that is, how to install MariaDB. Then, we walk you through the databases and tables of MariaDB, and introduce SQL in MariaDB. You will learn about all the features that have been added in MariaDB but are absent in MySQL. Moving on, you’ll learn to import and export data, views, virtual columns, and dynamic columns in MariaDB. Then, you’ll get to grips with full-text searches and queries in MariaDb. You’ll also be familiarized with the CONNECT storage engine. At the end of the book, you’ll be introduced to the community of MariaDB.
Table of Contents (10 chapters)
9
Index

Chapter 1. Installing MariaDB

MariaDB is a Relational Database Management System (RDBMS). It is fully open source, released with a GNU (General Public License), version 2. MariaDB is a fork of MySQL, started by its original author, Michael Widenius and some of MySQL's core developers.

Like other relational database management systems, MariaDB allows us to create and manage relational databases. It can modify the data structure and the data itself as well as answer questions (queries) on that data. The user can communicate with MariaDB by writing statements in SQL (Structured Query Language). The statements can also be composed by a program, which can send them to MariaDB. This allows programs of any type, including web applications, to interact with MariaDB to manage their data.

This chapter describes the steps that need be taken before one starts using MariaDB. In particular, we will discuss the following topics:

  • Choosing a MariaDB version
  • Installing MariaDB on various operating systems
  • Starting and stopping the server
  • Configuring MariaDB
  • Getting started with the command-line client
  • Upgrading MariaDB
  • Installing and configuring plugins