Getting Started with MariaDB | MariaDB Cookbook

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

MariaDB Cookbook

By : Daniel Bartholomew

4.2 (9)

MariaDB Cookbook

4.2 (9)

By: Daniel Bartholomew

Overview of this book

MariaDB Cookbook

MariaDB Cookbook

Credits

Credits

About the Author

About the Author

About the Reviewers

About the Reviewers

www.PacktPub.com

www.PacktPub.com

Preface

Preface

Free Chapter

Getting Started with MariaDB

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

Diving Deep into MariaDB

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

Optimizing and Tuning MariaDB

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

The TokuDB Storage Engine

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

The CONNECT Storage Engine

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

Replication in MariaDB

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

Replication with MariaDB Galera Cluster

Replication with MariaDB Galera Cluster

Introduction

Installing MariaDB Galera Cluster

Dropping a node from MariaDB Galera Cluster

Shutting down MariaDB Galera Cluster

Performance and Usage Statistics

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

Searching Data Using Sphinx

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

Exploring Dynamic and Virtual Columns in MariaDB

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

NoSQL with HandlerSocket

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

NoSQL with the Cassandra Storage Engine

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

MariaDB Security

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

Index

Index

Enabling the Feedback plugin

The Feedback plugin gathers and submits anonymous usage information to the MariaDB developers. Enabling it is an easy way to help out the project.

Getting ready

We'll need a running install of MariaDB. Refer to the previous recipes for instructions on how to do this.

How to do it...

Let's get started by following the ensuing steps:

Stop MariaDB by following the directions in the recipe that we followed when installing MariaDB.
Open our my.cnf or my.ini file in a text editor such as Vim, Emacs, TextWrangler, or Notepad. On Windows, there is a helpful link under the MariaDB group that will automatically open the my.ini file in Notepad. On Linux, the my.cnf file is located at either /etc/mysql/my.cnf or /etc/my.cnf depending on the Linux distribution we are using.
Add the following line of code to the [mysqld] section of the system's my.cnf or my.ini file (if the section does not exist, create it):
```
feedback=on
```
Save the file and then start MariaDB by following the instructions in the recipe we followed when installing MariaDB, and the plugin will be enabled.

How it works...

The Feedback plugin is turned off by default. Adding feedback=on to the configuration file lets MariaDB know that we want it enabled.

This plugin automatically sends anonymous usage data to the MariaDB developers, which helps them to prioritize development resources. Examples of the type of data it collects includes what operating system we're running, how much memory we have, what plugins we have enabled, and so on.

The collected data can be viewed at http://mariadb.org/feedback_plugin.

There's more...

The Feedback plugin can be customized in various ways. For example, we can choose the data that we want to send back. We can also configure the plugin to send the data to our own server instead of sending it to the MariaDB developers.

See also

The full documentation of the Feedback plugin is available at https://mariadb.com/kb/en/feedback-plugin/

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

MariaDB Cookbook

Search

Your notes and bookmarks