MariaDB Cookbook
eBook - ePub

MariaDB Cookbook

Daniel Bartholomew

Buch teilen
  1. 282 Seiten
  2. English
  3. ePUB (handyfreundlich)
  4. Über iOS und Android verfügbar
eBook - ePub

MariaDB Cookbook

Daniel Bartholomew

Angaben zum Buch
Buchvorschau
Inhaltsverzeichnis
Quellenangaben

Über dieses Buch

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.

Häufig gestellte Fragen

Wie kann ich mein Abo kündigen?
Gehe einfach zum Kontobereich in den Einstellungen und klicke auf „Abo kündigen“ – ganz einfach. Nachdem du gekündigt hast, bleibt deine Mitgliedschaft für den verbleibenden Abozeitraum, den du bereits bezahlt hast, aktiv. Mehr Informationen hier.
(Wie) Kann ich Bücher herunterladen?
Derzeit stehen all unsere auf Mobilgeräte reagierenden ePub-Bücher zum Download über die App zur Verfügung. Die meisten unserer PDFs stehen ebenfalls zum Download bereit; wir arbeiten daran, auch die übrigen PDFs zum Download anzubieten, bei denen dies aktuell noch nicht möglich ist. Weitere Informationen hier.
Welcher Unterschied besteht bei den Preisen zwischen den Aboplänen?
Mit beiden Aboplänen erhältst du vollen Zugang zur Bibliothek und allen Funktionen von Perlego. Die einzigen Unterschiede bestehen im Preis und dem Abozeitraum: Mit dem Jahresabo sparst du auf 12 Monate gerechnet im Vergleich zum Monatsabo rund 30 %.
Was ist Perlego?
Wir sind ein Online-Abodienst für Lehrbücher, bei dem du für weniger als den Preis eines einzelnen Buches pro Monat Zugang zu einer ganzen Online-Bibliothek erhältst. Mit über 1 Million Büchern zu über 1.000 verschiedenen Themen haben wir bestimmt alles, was du brauchst! Weitere Informationen hier.
Unterstützt Perlego Text-zu-Sprache?
Achte auf das Symbol zum Vorlesen in deinem nächsten Buch, um zu sehen, ob du es dir auch anhören kannst. Bei diesem Tool wird dir Text laut vorgelesen, wobei der Text beim Vorlesen auch grafisch hervorgehoben wird. Du kannst das Vorlesen jederzeit anhalten, beschleunigen und verlangsamen. Weitere Informationen hier.
Ist MariaDB Cookbook als Online-PDF/ePub verfügbar?
Ja, du hast Zugang zu MariaDB Cookbook von Daniel Bartholomew im PDF- und/oder ePub-Format sowie zu anderen beliebten Büchern aus Computer Science & Desktop Applications. Aus unserem Katalog stehen dir über 1 Million Bücher zur Verfügung.

Information

Jahr
2014
ISBN
9781783284399

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 ...

Inhaltsverzeichnis