Getting Started with MariaDB - Second Edition
Format: PDF / Kindle (mobi) / ePub
Explore the powerful features of MariaDB with practical examples
About This Book
- Install, configure, and manage MariaDB
- Store and manipulate data with MariaDB
- Get up and running with real-world, practical examples based on MariaDB 10
Who This Book Is For
This book is for anyone who wants to learn more about databases in general and wants to get started with MariaDB. Prior database experience is not required.
What You Will Learn
- Install MariaBD on Windows, Mac OS X, and Linux
- Configure MariaDB for better performance using the features of version 10
- Get familiar with the usage of operators for retrieving rows more selectively
- Use MariaDB 10's powerful tools to store, retrieve, and analyze data
- Secure MariaDB from unauthorized access
- Maintain the databases associated with MariaDB to ensure efficient and optimum functioning
- Retrieve data and learn how to sort, summarize, group, and manipulate it.
MariaDB is a database that has become very popular in the few short years that it has been around. It does not require a big server or expensive support contract. It is also powerful enough to be the database of choice for some of the biggest and most popular websites in the world, taking full advantage of the latest computing hardware available.
From installing and configuring through basic usage and maintenance, each chapter in this revised and expanded guide leads on sequentially and logically from the one before it, introducing topics in their natural order so you learn what you need, when you need it. The book is based on the latest release of MariaDB and covers all the latest features and functions. By the end of this beginner-friendly book, not only will you have a running installation of MariaDB, but you will have practical, hands-on experience in the basics of how to install, configure, administer, use, and maintain it.
take the server or computer our MariaDB database is present and walk out with it, none of our network and other security measures will mean anything. It's trivial for an attacker to gain access to our data if they have physical access to the machine. The next ring is the Server on which MariaDB is running. Who can log in? Where can they log in from? Who has administrative rights? Does it have monitoring and backup systems in place so we can keep an eye on it? The answers to these questions depend
comfortable leaving a large stack of money in the location our server is in, then it is probably a pretty good place for our server (assuming there is power and adequate cooling). [ 37 ] MariaDB Security The best place for a server is usually with other servers in a dedicated server room. Preferably it should be a room that is secure and where access is controlled with well-defined security policies and procedures. These could range from a locked closet (that only a few chosen people can
a MariaDB database have columns, which can relate in one way or another. For example, the id column in an employee table may relate to the employee_id column in an address table. These relationships (also called foreign keys) are why we call MariaDB a relational database. A database without tables of data is nothing more than a name. Until we create some tables and start adding data to those tables, our database is empty and useless. Creating a table There are few things in MariaDB we will
(YUM) package manager. Linux .deb packages are used on distributions, such as Debian and Ubuntu, which use the Advanced Packaging Tool (APT) package manager. We will cover how to install all these types in this chapter. We will cover the fourth type, Linux and Windows Binaries, briefly. These packages are mainly useful to experienced users of MariaDB who have nonstandard setups. The Windows binaries come in a ZIP file (.zip) and the Linux binaries in a gzipped tar file (.tar.gz). Installing
gpgcheck=1 The gpgkey line tells YUM where the MariaDB signing key is located. The gpgcheck line directs Yum to always use the signing key to verify the MariaDB packages. The first time we install MariaDB our system will not have the key so Yum will download it and install it. If Yum has never used the key before it will ask for confirmation whether it is OK to import the key. See the MariaDB package security section for more information on the MariaDB signing key. Copy and paste the generated