MariaDB Cookbook
eBook - ePub

MariaDB Cookbook

  1. 282 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

MariaDB Cookbook

About this book

In Detail

MariaDB is a new database that has become very popular. It is easy to install and use, even on personal systems. It is evolving and expanding to meet the database needs of today, tomorrow, and into the future. MariaDB is a drop in replacement for MySQL it also has a lot of new features and performance enhancements that differentiate it from MySQL. It is also powerful enough to be the database of choice for some of the biggest and most popular websites in the world.

This practical guide unlocks the advanced features of MariaDB's capabilities, including new storage engines, performance enhancing optimizations, and other advanced abilities. If you're looking to backend your enterprise, cloud, or embedded or mobile apps with a fast, free, open source, and familiar SQL database, MariaDB is perfect for you.

We begin with installing MariaDB and configuring it to unlock powerful optimizations that can speed up certain queries exponentially. We will then move on to using the extra storage engines included with MariaDB, such as TokuDB and the CONNECT engine. With those mastered, it's then time to branch out from single to multi-server installations, so we will dive into MariaDB's clustering and replication features, learning how to efficiently search and index our data, work with NoSQL-style data, and connect MariaDB with a Cassandra cluster. It's a dangerous world out there, so last of all, we wrap things up with recipes on securing MariaDB.

This is your ideal guide for getting the most out of MariaDB.

Approach

A practical cookbook, filled with advanced recipes , and plenty of code and commands used for illustration,which will make your learning curve easy and quick.

Who this book is for

This book is for anyone who wants to learn more about databases in general or MariaDB in particular. Some familiarity with SQL databases is assumed, but the recipes are approachable to almost anyone with basic database skills.

Tools to learn more effectively

Saving Books

Saving Books

Keyword Search

Keyword Search

Annotating Text

Annotating Text

Listen to it instead

Listen to it instead

Information

MariaDB Cookbook


Table of Contents

MariaDB Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
1. Getting Started with MariaDB
Introduction
Installing MariaDB on Windows
How to do it...
How it works...
There's more...
HeidiSQL
The Feedback plugin
See also
Installing MariaDB on Linux
Getting ready
How to do it...
How it works...
See also
Installing MariaDB on Mac OS X
Getting ready
How to do it…
How it works...
Enabling the Feedback plugin
Getting ready
How to do it...
How it works...
There's more...
See also
Switching between InnoDB and XtraDB
How to do it...
How it works...
See also
Creating a backup user
How to do it…
How it works...
Making backups with XtraBackup
Getting ready
How to do it...
How it works...
There's more...
Restoring from a backup
XtraBackup and NFS
Making backups with mysqldump
Getting ready
How to do it…
How it works...
There's more...
--add-drop-database
--add-drop-table
--add-locks
Checking and optimizing tables automatically with mysqlcheck and cron
How to do it…
How it works...
There's more…
Security
Using progress reporting in the mysql client
How to do it…
How it works...
There's more…
Disabling progress reporting
Progress reporting in mytop
2. Diving Deep into MariaDB
Introduction
Importing the data exported by mysqldump
How to do it...
How it works...
There's more...
See also
Using SHOW EXPLAIN with running queries
Getting ready
How to do it...
How it works...
There's more...
See also
Using LIMIT ROWS EXAMINED
Getting ready
How to do it...
How it works...
There's more...
Using LIMIT with LIMIT ROWS EXAMINED
Warning of incomplete results
Using INSTALL SONAME
How to do it...
How it works...
There's more...
Plugin names versus filenames
INSTALL SONAME versus INSTALL PLUGIN
See also
Producing HTML output
Getting ready
How to do it...
How it works...
There's more...
See also
Producing XML output
Getting ready
How to do it...
How it works...
See also
Migrating a table from MyISAM to Aria
Getting ready
How to do it...
How it works...
See also
Migrating a table from MyISAM or Aria to InnoDB or XtraDB
Getting ready
How to do it...
How it works...
There's more...
See also
3. Optimizing and Tuning MariaDB
Introduction
Using SHOW STATUS to check if a feature is being used
How to do it...
How it works...
There's more...
See also
Controlling MariaDB optimizer strategies
How to do it...
How it works...
There's more...
See also
Using extended keys with InnoDB and XtraDB
How to do it...
How it works...
There's more...
See also
Configuring the Aria two-step deadlock detection
How to do it...
How it works...
There's more...
See also
Configuring the MyISAM segmented key cache
How to do it...
How it works...
There's more...
Setting the number of segments to 1
Determining the optimal number of segments
Other key cache variables
See also
Configuring threadpool
How to do it...
How it works...
There's more...
The thread_pool_stall_limit, thread_pool_max_threads, and extra_port variables
The thread_pool_idle_timeout variable
Pool-of-threads differences on Windows and Linux
See also
Configuring the Aria pagecache
How to do it...
How it works...
There's more...
See also
Optimizing queries with the subquery cache
Getting ready
How to do it...
How it works...
There's more...
See also
Optimizing semijoin subqueries
How to do it...
How it works...
There's more...
See also
Creating an index
Getting ready
How to do it...
How it works...
There's more...
See also
Creating a full-text index
Getting ready
How to do it...
How it works...
There's more...
See also
Removing an index
Getting ready
How to do it...
How it works...
There's more...
See also
Using ...

Table of contents

  1. MariaDB Cookbook

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn how to download books offline
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 990+ topics, we’ve got you covered! Learn about our mission
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more about Read Aloud
Yes! You can use the Perlego app on both iOS and Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Yes, you can access MariaDB Cookbook by Daniel Bartholomew in PDF and/or ePUB format, as well as other popular books in Computer Science & Desktop Applications. We have over one million books available in our catalogue for you to explore.