MariaDB Cookbook
eBook - ePub

MariaDB Cookbook

Daniel Bartholomew

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

MariaDB Cookbook

Daniel Bartholomew

Book details
Book preview
Table of contents
Citations

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.

Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
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 1000+ topics, we’ve got you covered! Learn more here.
Do you support text-to-speech?
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 here.
Is MariaDB Cookbook an online PDF/ePUB?
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.

Information

Year
2014
ISBN
9781783284399
Edition
1

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