Getting Started with MariaDB - Second Edition电子书

Getting Started with MariaDB Second Edition

Table of Contents

Getting Started with MariaDB Second Edition

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Free access for Packt account holders

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Installing MariaDB

Choosing a MariaDB series

The development series

The stable series

The maintenance 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

2. Configuring MariaDB

The MariaDB filesystem layout

The MariaDB filesystem layout on Windows

The MariaDB filesystem layout on Linux

Modular configuration on Linux

The anatomy of the MariaDB configuration file

Where is my configuration file?

Comments

Groups

Options that do not require values

Options that require values

Option formatting

Options, options everywhere

Activating configuration changes

Summary

3. Securing MariaDB

Security layers

Securing MariaDB in 10 seconds

Connecting safely

Connecting safely on the command line

Connecting safely in scripts

Server security

Building security

Internal network security

Internet security

Summary

4. Administering MariaDB

User privileges

Global administrative user privileges

Database, table, and column user privileges

Miscellaneous user privileges and limits

Creating users

Granting, revoking, and showing permissions

Granting permissions

Revoking permissions

Showing permissions

Setting and changing passwords

Removing users

Summary

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

Using CREATE DATABASE to create a database

Using DROP DATABASE to delete a database

Data, tables, and normalization

Creating, altering, and dropping tables

Using CREATE TABLE

Using CREATE TABLE – basic syntax

Using CREATE TABLE – datatypes

Using CREATE TABLE– other options

Using CREATE TABLE – an example

Using SHOW to display the command used to create a table

Using DESCRIBE to explore the structure of a table

Using ALTER TABLE

Using ALTER TABLE – basic syntax

Using ALTER TABLE – adding a column

Using ALTER TABLE – modifying a column

Using ALTER TABLE – dropping a column

Using DROP TABLE

Summary

6. Using MariaDB – Inserting, Updating, and Deleting

Using INSERT

Inserting complete rows

Inserting partial rows

Inserting from another table

Inserting from a file

Using UPDATE

Using DELETE

Summary

7. Using MariaDB – Retrieving Data

Retrieving data

Retrieving everything

Retrieving selected columns

Filtering and searching data

Filtering by exact values

Using logical operators

Using the AND operator

Using the OR operator

Evaluation order

Using the IN operator

Using the NOT operator

Searching with LIKE

Sorting data

Joining data

Summarizing data

The AVG function

The COUNT function

The MIN and MAX functions

The SUM function

Using GROUP BY with summarized data

Using HAVING to filter GROUP BY

Summary

8. Maintaining MariaDB

MariaDB log files

The binary log

The error log

The general query log

The slow query log

Optimizing and tuning MariaDB

Backing up, importing, and restoring data

Basic backups with mysqldump

Restoring backups made with mysqldump

Making tab-delimited backups with mysqldump

Restoring and importing data with mysqlimport

Making backups of MyISAM tables with mysqlhotcopy

Making backups of XtraDB and InnoDB tables with xtrabackup

Restoring backups made with xtrabackup

Making cold backups

Repairing MariaDB

Checking and optimizing tables with mysqlcheck

Repairing tables

Summary

A. MariaDB Next Steps

Index