Mastering MariaDB

Book Image

Mastering MariaDB

By : Federico Razzoli

Book Image

Mastering MariaDB

By: Federico Razzoli

Overview of this book

Mastering MariaDB

Mastering MariaDB

Credits

About the Author

About the Author

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Free Chapter

Understanding the Essentials of MariaDB

Understanding the Essentials of MariaDB

The MariaDB architecture

The command-line client

Storage engines

InnoDB data structures

Authentication and security

The information_schema database

The performance_schema database

Compatibility with MySQL and other DBMS

MariaDB resources

Debugging

Understanding error conditions in MariaDB

The diagnostics area

The GET DIAGNOSTICS statement

The general query log

Maintenance of the server logs

The SQL_ERROR_LOG plugin

Tips on debugging stored programs

Debugging stored programs using the SQL_ERROR_LOG plugin

Optimizing Queries

Optimizing Queries

The slow query log

Explaining the pt-query-digest command from Percona Toolkit

Introducing indexes

Working with the EXPLAIN statement

Transactions and Locks

Transactions and Locks

The InnoDB locks

Reads consistency

Users and Connections

Users and Connections

Setting permissions using roles

Connecting MariaDB through Secure Socket Layer

Authentication plugins

Monitoring connections

Caches

MyISAM key cache

Aria page cache

The query cache explained

The table open cache

Per-session buffers

InnoDB Compressed Tables

InnoDB Compressed Tables

An overview of the InnoDB compression

InnoDB compression requirements

Explaining the file-per-table mode

Creating InnoDB compressed tables

Explaining the implementation of the InnoDB compression

Monitoring the InnoDB compression performance

Other compression solutions

Backup and Disaster Recovery

Backup and Disaster Recovery

Types of backups

Complete and incremental backups

Creating a dump file with mysqldump

Delimited text backups

Physical backups

Using the binary log for incremental backups

Percona XtraBackup

Securing backups

Repairing tables

Replication

An overview of replication

Choosing a binary log format

Configuring replication

Multisource replication

Replication logs

Checking the replication for errors

Troubleshooting

Table Partitioning

Table Partitioning

Support for partitioning

Partitioning types and expressions

Administering partitioned tables

Partitions' physical files

Query optimizations

Data Sharding

Distributing files between multiple disks

The FEDERATEDX and CONNECT storage engines

The SPIDER storage engine

MariaDB Galera Cluster

MariaDB Galera Cluster

MariaDB Galera Cluster key concepts

Setting up a cluster

Starting the nodes

Configuring the cluster

Monitoring and troubleshooting

Listing the limitations of Galera Cluster

Galera Load Balancer

Index

Customer Reviews

5 star

0

4 star

0

3 star

0

2 star

0

1 star

0

Other compression solutions

Other storage engines offer the ability to compress tables. These engines are:

TokuDB: This engine always compresses tables; there is no way to avoid this. This is a part of its strategy, which aims to reach high performance by reducing the amount of output to disks.
ARCHIVE: This storage engine is specifically designed for compressed tables with limited functionalities. It is possible to add new data to an ARCHIVE table, but the existing rows cannot be deleted or updated. Index support is very limited.
MyISAM: While normal MyISAM tables are not compressed, a special tool called myisampack can be used to compress tables. A compressed MyISAM table is read only.
Tip
Note that while Aria aims to be a more robust and modern version of MyISAM, it does not support this feature.

Compression methods other than the InnoDB COMPRESSED row format are beyond the scope of this chapter. They are not widely used because other storage engines, including TokuDB, do not reach the performance...