Getting Started with MariaDB - Second Edition

Daniel Bartholomew

• Publisher: Packt Publishing
• Year: 2015
• ISBN:
  9781785284120
• Edition: 2
• Topic: Business
• Subtopic: Business Intelligence
• Index: Business

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

Getting Started with MariaDB Second Edition

Copyright © 2015 Packt Publishing

All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.

Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.

Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.

First published: June 2015

Production reference: 1120615

Published by Packt Publishing Ltd.

Livery Place

35 Livery Street

Birmingham B3 2PB, UK.

ISBN 978-1-78528-412-0

www.packtpub.com

Credits

Author

Daniel Bartholomew

Reviewers

David Chanial

Emilien Kenler

Giacomo Picchiarelli

Commissioning Editor

Kartikey Pandey

Acquisition Editor ...