Book Image

Mastering MariaDB

By : Federico Razzoli
Book Image

Mastering MariaDB

By: Federico Razzoli

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Mastering MariaDB
Federico Razzoli
Sep, 2014 | 384 pages
No titles found
Table of Contents (19 chapters)
Mastering MariaDB
Mastering MariaDB
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Understanding the Essentials of MariaDB
Understanding the Essentials of MariaDB
The MariaDB architecture
The command-line client
Storage engines
Logs
MariaDB caches
InnoDB data structures
Authentication and security
The information_schema database
The performance_schema database
Compatibility with MySQL and other DBMS
MariaDB resources
Summary
2
Debugging
Debugging
Understanding error conditions in MariaDB
The diagnostics area
The GET DIAGNOSTICS statement
The error log
System logs
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
Summary
3
Optimizing Queries
Optimizing Queries
The slow query log
Explaining the pt-query-digest command from Percona Toolkit
Introducing indexes
Working with the EXPLAIN statement
Summary
4
Transactions and Locks
Transactions and Locks
The InnoDB locks
Reads consistency
Deadlocks
Transactions
Metadata locks
Summary
5
Users and Connections
Users and Connections
User accounts
Setting permissions using roles
Connecting MariaDB through Secure Socket Layer
Authentication plugins
Monitoring connections
Summary
6
Caches
Caches
InnoDB caches
MyISAM key cache
Aria page cache
The query cache explained
The table open cache
Per-session buffers
Summary
7
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
Summary
8
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
Summary
9
Replication
Replication
An overview of replication
Choosing a binary log format
Configuring replication
Multisource replication
Replication logs
Checking the replication for errors
Troubleshooting
Summary
10
Table Partitioning
Table Partitioning
Support for partitioning
Partitioning types and expressions
Administering partitioned tables
Partitions' physical files
Query optimizations
Summary
11
Data Sharding
Data Sharding
Distributing files between multiple disks
The FEDERATEDX and CONNECT storage engines
The SPIDER storage engine
Summary
12
MariaDB Galera Cluster
MariaDB Galera Cluster
MariaDB Galera Cluster key concepts
Setting up a cluster
Starting the nodes
Configuring the cluster
Monitoring and troubleshooting
Load balancing
Listing the limitations of Galera Cluster
Galera Load Balancer
Summary
Index
Index

About the Reviewers

Josh King works as the Senior Systems Software Engineer for Kualo Web Hosting and has been using and administering databases for well over a decade. He is also an active developer specializing in system performance and the Linux kernel. He has been a contributor to the numerous Linux and open source projects as well as a member of several organizations, such as the League of Professional System Administrators (LOPSA) and the Free Software Foundation.

He works with cloud and high-availability solutions, as well as Windows and BSD platforms. He is a recipient of the LOPSA Professional Recognition award for excellence and professionalism in Information Technology, and has written papers on numerous subjects dealing with the performance and optimization of the Linux operating system.

He currently resides in Texas with his wife and children.

Daniel Parnell has been messing around with computers since a very early age. He started working with an AIM-65, through a Commodore VIC-20, Commodore 64, Apple IIe, Commodore Amiga, an ICL Concurrent CP/M86 machine, and Apple Mac Plus to various PCs and Macs today.

Of late, Daniel has been working on web applications for the health care industry using Ruby on Rails, and building a rich web application using a JavaScript frontend and an Erlang backend.

When Daniel is not coding or tinkering with electronic gadgets around the house, he is spending time with his family. His son died late last year at the age of 6 of an untreatable neurodegenerative disorder called Battens disease.

Giacomo Picchiarelli is a test and software engineer with 6 years of experience in designing data-driven applications and MySQL administration. He has a strong background in Linux systems and test-driven development.

Philipp Wollermann is a Software Engineer currently working for Google in Germany. His experience with MariaDB comes from having run his own Linux-based web hosting business for over 5 years, and from working for CyberAgent, Inc. in Tokyo, where he helped optimize web applications and database performance.

Previous Section
Next Chapter