MariaDB Cookbook

Authenticating using the PAM authentication plugin

Using roles to control user permissions

Encrypting connections with SSL

Checking for users with insecure passwords

Securing MariaDB files on Windows

Securing MariaDB files on Linux

Securing MariaDB with mysql_secure_installation

Introduction

Chapter 13. MariaDB Security

Using SELECT with the Cassandra storage engine

Using INSERT UPDATE and DELETE with the Cassandra storage engine

Mapping data between MariaDB and Cassandra

Installing the Cassandra storage engine

Introduction

Chapter 12. NoSQL with the Cassandra Storage Engine

Using HandlerSocket directly with Telnet

Updating and deleting data using HandlerSocket and Ruby

Inserting data using HandlerSocket and Ruby

Reading data using HandlerSocket and Ruby

Installing the HandlerSocket Ruby client libraries

Updating and deleting data using HandlerSocket and Python

Inserting data using HandlerSocket and Python

Reading data using HandlerSocket and Python

Installing the HandlerSocket Python client libraries

Updating and deleting data using HandlerSocket and PERL

Inserting data using HandlerSocket and PERL

Reading data using HandlerSocket and PERL

Installing the HandlerSocket PERL client libraries

Installing the libhsclient library

Installing and configuring HandlerSocket

Introduction

Chapter 11. NoSQL with HandlerSocket

Using virtual columns

Reading data from a dynamic column

Inserting updating and deleting dynamic column data

Creating tables with dynamic columns

Introduction

Chapter 10. Exploring Dynamic and Virtual Columns in MariaDB

Searching with the Sphinx daemon and SphinxSE

Configuring the Sphinx daemon

Installing the Sphinx daemon on Windows

Installing the Sphinx daemon on Linux

Installing SphinxSE in MariaDB

Introduction

Chapter 9. Searching Data Using Sphinx

Using the performance schema

Enabling the performance schema

Using extended statistics

Using engine-independent table statistics

Using the Audit Plugin

Installing the Audit Plugin

Introduction

Chapter 8. Performance and Usage Statistics

Shutting down MariaDB Galera Cluster

Dropping a node from MariaDB Galera Cluster

Installing MariaDB Galera Cluster

Introduction

Chapter 7. Replication with MariaDB Galera Cluster

Selectively skipping the replication of binlog events

Configuring binlog event checksums

Enhancing the binlog with row event annotations

Using multisource replication

Using global transaction IDs

Setting up replication

Introduction

Chapter 6. Replication in MariaDB

Using the MAC address table type

Using the WMI table type

Using the OCCUR table type

Using the PIVOT table type

Using the XCOL table type

Accessing MariaDB tables using CONNECT

Reading and writing XML data using CONNECT

Reading and writing CSV data using CONNECT

Creating and dropping CONNECT tables

Installing the CONNECT storage engine

Introduction

Chapter 5. The CONNECT Storage Engine

Modifying the compression of a TokuDB table

Adding indexes to TokuDB tables

Migrating to TokuDB

Creating TokuDB tables

Configuring TokuDB

Installing TokuDB

Introduction

Chapter 4. The TokuDB Storage Engine

Updating DATETIME and TIMESTAMP columns automatically

Using microseconds in the DATETIME columns

Using JOINs

Removing an index

Creating a full-text index

Creating an index

Optimizing semijoin subqueries

Optimizing queries with the subquery cache

Configuring the Aria pagecache

Configuring threadpool

Configuring the MyISAM segmented key cache

Configuring the Aria two-step deadlock detection

Using extended keys with InnoDB and XtraDB

Controlling MariaDB optimizer strategies

Using SHOW STATUS to check if a feature is being used

Introduction

Chapter 3. Optimizing and Tuning MariaDB

Migrating a table from MyISAM or Aria to InnoDB or XtraDB

Migrating a table from MyISAM to Aria

Producing XML output

Producing HTML output

Using INSTALL SONAME

Using LIMIT ROWS EXAMINED

Using SHOW EXPLAIN with running queries

Importing the data exported by mysqldump

Introduction

Chapter 2. Diving Deep into MariaDB

Using progress reporting in the mysql client

Checking and optimizing tables automatically with mysqlcheck and cron

Making backups with mysqldump

Making backups with XtraBackup

Creating a backup user

Switching between InnoDB and XtraDB

Enabling the Feedback plugin

Installing MariaDB on Mac OS X

Installing MariaDB on Linux

Installing MariaDB on Windows

Introduction

Chapter 1. Getting Started with MariaDB

Customer support

Reader feedback

Conventions

Who this book is for

What you need for this book

What this book covers

Preface

Support files eBooks discount offers and more

www.PacktPub.com

About the Reviewers

About the Author

Credits

MariaDB Cookbook

coverpage

coverpage

MariaDB Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files eBooks discount offers and more

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Chapter 1. Getting Started with MariaDB

Introduction

Installing MariaDB on Windows

Installing MariaDB on Linux

Installing MariaDB on Mac OS X

Enabling the Feedback plugin

Switching between InnoDB and XtraDB

Creating a backup user

Making backups with XtraBackup

Making backups with mysqldump

Checking and optimizing tables automatically with mysqlcheck and cron

Using progress reporting in the mysql client

Chapter 2. Diving Deep into MariaDB

Introduction

Importing the data exported by mysqldump

Using SHOW EXPLAIN with running queries

Using LIMIT ROWS EXAMINED

Using INSTALL SONAME

Producing HTML output

Producing XML output

Migrating a table from MyISAM to Aria

Migrating a table from MyISAM or Aria to InnoDB or XtraDB

Chapter 3. Optimizing and Tuning MariaDB

Introduction

Using SHOW STATUS to check if a feature is being used

Controlling MariaDB optimizer strategies

Using extended keys with InnoDB and XtraDB

Configuring the Aria two-step deadlock detection

Configuring the MyISAM segmented key cache

Configuring threadpool

Configuring the Aria pagecache

Optimizing queries with the subquery cache

Optimizing semijoin subqueries

Creating an index

Creating a full-text index

Removing an index

Using JOINs

Using microseconds in the DATETIME columns

Updating DATETIME and TIMESTAMP columns automatically

Chapter 4. The TokuDB Storage Engine

Introduction

Installing TokuDB

Configuring TokuDB

Creating TokuDB tables

Migrating to TokuDB

Adding indexes to TokuDB tables

Modifying the compression of a TokuDB table

Chapter 5. The CONNECT Storage Engine

Introduction

Installing the CONNECT storage engine

Creating and dropping CONNECT tables

Reading and writing CSV data using CONNECT

Reading and writing XML data using CONNECT

Accessing MariaDB tables using CONNECT

Using the XCOL table type

Using the PIVOT table type

Using the OCCUR table type

Using the WMI table type

Using the MAC address table type

Chapter 6. Replication in MariaDB

Introduction

Setting up replication

Using global transaction IDs

Using multisource replication

Enhancing the binlog with row event annotations

Configuring binlog event checksums

Selectively skipping the replication of binlog events

Chapter 7. Replication with MariaDB Galera Cluster

Introduction

Installing MariaDB Galera Cluster

Dropping a node from MariaDB Galera Cluster

Shutting down MariaDB Galera Cluster

Chapter 8. Performance and Usage Statistics

Introduction

Installing the Audit Plugin

Using the Audit Plugin

Using engine-independent table statistics

Using extended statistics

Enabling the performance schema

Using the performance schema

Chapter 9. Searching Data Using Sphinx

Introduction

Installing SphinxSE in MariaDB

Installing the Sphinx daemon on Linux

Installing the Sphinx daemon on Windows

Configuring the Sphinx daemon

Searching with the Sphinx daemon and SphinxSE

Chapter 10. Exploring Dynamic and Virtual Columns in MariaDB

Introduction

Creating tables with dynamic columns

Inserting updating and deleting dynamic column data

Reading data from a dynamic column

Using virtual columns

Chapter 11. NoSQL with HandlerSocket

Introduction

Installing and configuring HandlerSocket

Installing the libhsclient library

Installing the HandlerSocket PERL client libraries

Reading data using HandlerSocket and PERL

Inserting data using HandlerSocket and PERL

Updating and deleting data using HandlerSocket and PERL

Installing the HandlerSocket Python client libraries

Reading data using HandlerSocket and Python

Inserting data using HandlerSocket and Python

Updating and deleting data using HandlerSocket and Python

Installing the HandlerSocket Ruby client libraries

Reading data using HandlerSocket and Ruby

Inserting data using HandlerSocket and Ruby

Updating and deleting data using HandlerSocket and Ruby

Using HandlerSocket directly with Telnet

Chapter 12. NoSQL with the Cassandra Storage Engine

Introduction

Installing the Cassandra storage engine

Mapping data between MariaDB and Cassandra

Using INSERT UPDATE and DELETE with the Cassandra storage engine

Using SELECT with the Cassandra storage engine

Chapter 13. MariaDB Security

Introduction

Securing MariaDB with mysql_secure_installation

Securing MariaDB files on Linux

Securing MariaDB files on Windows

Checking for users with insecure passwords

Encrypting connections with SSL

Using roles to control user permissions

Authenticating using the PAM authentication plugin