Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying MariaDB Cookbook
  • Table Of Contents Toc
MariaDB Cookbook

MariaDB Cookbook

By : Daniel Bartholomew
4.2 (9)
Buy this Book
close
close
MariaDB Cookbook

MariaDB Cookbook

4.2 (9)
By: Daniel Bartholomew
Buy this Book

Overview of this book

Table of Contents (20 chapters)
close
close
close
MariaDB Cookbook
Icon
MariaDB Cookbook
Credits
Icon
Credits
About the Author
Icon
About the Author
About the Reviewers
Icon
About the Reviewers
www.PacktPub.com
Icon
www.PacktPub.com
Preface
Icon
Preface
Lock Free Chapter
1
Getting Started with MariaDB
chevron up
Icon
Getting Started with MariaDB
Icon
Introduction
Icon
Installing MariaDB on Windows
Icon
Installing MariaDB on Linux
Icon
Installing MariaDB on Mac OS X
Icon
Enabling the Feedback plugin
Icon
Switching between InnoDB and XtraDB
Icon
Creating a backup user
Icon
Making backups with XtraBackup
Icon
Making backups with mysqldump
Icon
Checking and optimizing tables automatically with mysqlcheck and cron
Icon
Using progress reporting in the mysql client
2
Diving Deep into MariaDB
Icon
Diving Deep into MariaDB
Icon
Introduction
Icon
Importing the data exported by mysqldump
Icon
Using SHOW EXPLAIN with running queries
Icon
Using LIMIT ROWS EXAMINED
Icon
Using INSTALL SONAME
Icon
Producing HTML output
Icon
Producing XML output
Icon
Migrating a table from MyISAM to Aria
Icon
Migrating a table from MyISAM or Aria to InnoDB or XtraDB
3
Optimizing and Tuning MariaDB
Icon
Optimizing and Tuning MariaDB
Icon
Introduction
Icon
Using SHOW STATUS to check if a feature is being used
Icon
Controlling MariaDB optimizer strategies
Icon
Using extended keys with InnoDB and XtraDB
Icon
Configuring the Aria two-step deadlock detection
Icon
Configuring the MyISAM segmented key cache
Icon
Configuring threadpool
Icon
Configuring the Aria pagecache
Icon
Optimizing queries with the subquery cache
Icon
Optimizing semijoin subqueries
Icon
Creating an index
Icon
Creating a full-text index
Icon
Removing an index
Icon
Using JOINs
Icon
Using microseconds in the DATETIME columns
Icon
Updating DATETIME and TIMESTAMP columns automatically
4
The TokuDB Storage Engine
Icon
The TokuDB Storage Engine
Icon
Introduction
Icon
Installing TokuDB
Icon
Configuring TokuDB
Icon
Creating TokuDB tables
Icon
Migrating to TokuDB
Icon
Adding indexes to TokuDB tables
Icon
Modifying the compression of a TokuDB table
5
The CONNECT Storage Engine
Icon
The CONNECT Storage Engine
Icon
Introduction
Icon
Installing the CONNECT storage engine
Icon
Creating and dropping CONNECT tables
Icon
Reading and writing CSV data using CONNECT
Icon
Reading and writing XML data using CONNECT
Icon
Accessing MariaDB tables using CONNECT
Icon
Using the XCOL table type
Icon
Using the PIVOT table type
Icon
Using the OCCUR table type
Icon
Using the WMI table type
Icon
Using the MAC address table type
6
Replication in MariaDB
Icon
Replication in MariaDB
Icon
Introduction
Icon
Setting up replication
Icon
Using global transaction IDs
Icon
Using multisource replication
Icon
Enhancing the binlog with row event annotations
Icon
Configuring binlog event checksums
Icon
Selectively skipping the replication of binlog events
7
Replication with MariaDB Galera Cluster
Icon
Replication with MariaDB Galera Cluster
Icon
Introduction
Icon
Installing MariaDB Galera Cluster
Icon
Dropping a node from MariaDB Galera Cluster
Icon
Shutting down MariaDB Galera Cluster
8
Performance and Usage Statistics
Icon
Performance and Usage Statistics
Icon
Introduction
Icon
Installing the Audit Plugin
Icon
Using the Audit Plugin
Icon
Using engine-independent table statistics
Icon
Using extended statistics
Icon
Enabling the performance schema
Icon
Using the performance schema
9
Searching Data Using Sphinx
Icon
Searching Data Using Sphinx
Icon
Introduction
Icon
Installing SphinxSE in MariaDB
Icon
Installing the Sphinx daemon on Linux
Icon
Installing the Sphinx daemon on Windows
Icon
Configuring the Sphinx daemon
Icon
Searching with the Sphinx daemon and SphinxSE
10
Exploring Dynamic and Virtual Columns in MariaDB
Icon
Exploring Dynamic and Virtual Columns in MariaDB
Icon
Introduction
Icon
Creating tables with dynamic columns
Icon
Inserting, updating, and deleting dynamic column data
Icon
Reading data from a dynamic column
Icon
Using virtual columns
11
NoSQL with HandlerSocket
Icon
NoSQL with HandlerSocket
Icon
Introduction
Icon
Installing and configuring HandlerSocket
Icon
Installing the libhsclient library
Icon
Installing the HandlerSocket PERL client libraries
Icon
Reading data using HandlerSocket and PERL
Icon
Inserting data using HandlerSocket and PERL
Icon
Updating and deleting data using HandlerSocket and PERL
Icon
Installing the HandlerSocket Python client libraries
Icon
Reading data using HandlerSocket and Python
Icon
Inserting data using HandlerSocket and Python
Icon
Updating and deleting data using HandlerSocket and Python
Icon
Installing the HandlerSocket Ruby client libraries
Icon
Reading data using HandlerSocket and Ruby
Icon
Inserting data using HandlerSocket and Ruby
Icon
Updating and deleting data using HandlerSocket and Ruby
Icon
Using HandlerSocket directly with Telnet
12
NoSQL with the Cassandra Storage Engine
Icon
NoSQL with the Cassandra Storage Engine
Icon
Introduction
Icon
Installing the Cassandra storage engine
Icon
Mapping data between MariaDB and Cassandra
Icon
Using INSERT, UPDATE, and DELETE with the Cassandra storage engine
Icon
Using SELECT with the Cassandra storage engine
13
MariaDB Security
Icon
MariaDB Security
Icon
Introduction
Icon
Securing MariaDB with mysql_secure_installation
Icon
Securing MariaDB files on Linux
Icon
Securing MariaDB files on Windows
Icon
Checking for users with insecure passwords
Icon
Encrypting connections with SSL
Icon
Using roles to control user permissions
Icon
Authenticating using the PAM authentication plugin
1
Index
Icon
Index

Installing MariaDB on Windows

There was a time when installing MariaDB on Windows meant downloading and unpacking a ZIP file. From then on, it was up to us to set up a system service, making sure that the paths were correct, and so on. Today, the process is completely automated with the MariaDB MSI package. The ZIP file is still available, but unless we know we want it (and we might!), there is no reason to use it.

How to do it...

Let's get started by following these steps:

  1. Visit http://mariadb.org/downloads and select the version of MariaDB we are interested in. There will be a development version and a stable version. For most users, the stable version is recommended.

  2. After choosing the version of MariaDB that we want, select either the 32-bit or 64-bit version of the MariaDB MSI package for Windows. For most computers, the 64-bit version will work fine; but if we are on an older computer, we may need to use the 32-bit version.

  3. Once it is downloaded, the installer may launch automatically, or depending on our settings, we may need to manually launch it, as shown in the following screenshot:

  4. Once the installer starts, click through the defaults. We can change them if we want, but there is no need.

  5. After the installation has finished, MariaDB will be up and running on our Windows computer.

How it works...

MSI stands for Microsoft installer. It's a standard package format for software installers on the Windows operating system. The MariaDB MSI package encapsulates all of the common manual steps for installing MariaDB. This includes steps such as setting up a Windows service so that MariaDB can be started automatically at boot time, creating the data directory, and so on.

There's more...

While clicking through the installer, there are some choices that we may wonder about. Two of them are HeidiSQL and the Feedback plugin.

HeidiSQL

In addition to installing MariaDB, the MSI package also, by default installs the HeidiSQL graphical client. This open source graphical client is a great way to interact with MariaDB, and the MariaDB and HeidiSQL developers have worked together to make sure that it supports all MariaDB features and options.

The Feedback plugin

One of the screens of the installer offers the option to turn on the Feedback plugin if we want to. Refer to the Enabling the Feedback plugin recipe later in this chapter for more information on this plugin and to know why it's a good idea to enable it.

See also

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
MariaDB Cookbook
End of Section 1
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon