Getting Started with MariaDB - Second Edition

Explore the powerful features of MariaDB with practical examples

Getting Started with MariaDB - Second Edition

Learning
Daniel Bartholomew

1 customer reviews
Explore the powerful features of MariaDB with practical examples
$19.99
$24.99
RRP $19.99
RRP $24.99
eBook
Print + eBook

Instantly access this course right now and get the skills you need in 2017

With unlimited access to a constantly growing library of over 4,000 eBooks and Videos, a subscription to Mapt gives you everything you need to learn new skills. Cancel anytime.

Free Sample

Book Details

ISBN 139781785284120
Paperback140 pages

Book Description

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.

Table of Contents

Chapter 1: Installing MariaDB
Choosing a MariaDB series
Installing MariaDB on Windows
Installing MariaDB on Mac OS X
Installing MariaDB on Debian, Ubuntu, and Linux Mint
Installing MariaDB on Fedora, Red Hat, and CentOS
Installing MariaDB on other Linux distributions
MariaDB package security
After the installation
Troubleshooting installation issues
Summary
Chapter 2: Configuring MariaDB
The MariaDB filesystem layout
Modular configuration on Linux
The anatomy of the MariaDB configuration file
Activating configuration changes
Summary
Chapter 3: Securing MariaDB
Security layers
Securing MariaDB in 10 seconds
Connecting safely
Server security
Building security
Internal network security
Internet security
Summary
Chapter 4: Administering MariaDB
User privileges
Creating users
Granting, revoking, and showing permissions
Setting and changing passwords
Removing users
Summary
Chapter 5: Using MariaDB – Databases and Tables
The mysql command-line client application
Connecting to MariaDB
Using USE to select a database
Using SHOW to list all databases on a server
Creating and deleting databases
Data, tables, and normalization
Creating, altering, and dropping tables
Summary
Chapter 6: Using MariaDB – Inserting, Updating, and Deleting
Using INSERT
Using UPDATE
Using DELETE
Summary
Chapter 7: Using MariaDB – Retrieving Data
Retrieving data
Filtering and searching data
Summarizing data
Summary
Chapter 8: Maintaining MariaDB
MariaDB log files
Optimizing and tuning MariaDB
Backing up, importing, and restoring data
Repairing MariaDB
Summary

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.

Authors

Table of Contents

Chapter 1: Installing MariaDB
Choosing a MariaDB series
Installing MariaDB on Windows
Installing MariaDB on Mac OS X
Installing MariaDB on Debian, Ubuntu, and Linux Mint
Installing MariaDB on Fedora, Red Hat, and CentOS
Installing MariaDB on other Linux distributions
MariaDB package security
After the installation
Troubleshooting installation issues
Summary
Chapter 2: Configuring MariaDB
The MariaDB filesystem layout
Modular configuration on Linux
The anatomy of the MariaDB configuration file
Activating configuration changes
Summary
Chapter 3: Securing MariaDB
Security layers
Securing MariaDB in 10 seconds
Connecting safely
Server security
Building security
Internal network security
Internet security
Summary
Chapter 4: Administering MariaDB
User privileges
Creating users
Granting, revoking, and showing permissions
Setting and changing passwords
Removing users
Summary
Chapter 5: Using MariaDB – Databases and Tables
The mysql command-line client application
Connecting to MariaDB
Using USE to select a database
Using SHOW to list all databases on a server
Creating and deleting databases
Data, tables, and normalization
Creating, altering, and dropping tables
Summary
Chapter 6: Using MariaDB – Inserting, Updating, and Deleting
Using INSERT
Using UPDATE
Using DELETE
Summary
Chapter 7: Using MariaDB – Retrieving Data
Retrieving data
Filtering and searching data
Summarizing data
Summary
Chapter 8: Maintaining MariaDB
MariaDB log files
Optimizing and tuning MariaDB
Backing up, importing, and restoring data
Repairing MariaDB
Summary

Book Details

ISBN 139781785284120
Paperback140 pages
Read More
From 1 reviews

Read More Reviews