MariaDB Cookbook
eBook - ePub

MariaDB Cookbook

Daniel Bartholomew

Partager le livre
  1. 282 pages
  2. English
  3. ePUB (adapté aux mobiles)
  4. Disponible sur iOS et Android
eBook - ePub

MariaDB Cookbook

Daniel Bartholomew

DĂ©tails du livre
Aperçu du livre
Table des matiĂšres
Citations

À propos de ce livre

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.

Foire aux questions

Comment puis-je résilier mon abonnement ?
Il vous suffit de vous rendre dans la section compte dans paramĂštres et de cliquer sur « RĂ©silier l’abonnement ». C’est aussi simple que cela ! Une fois que vous aurez rĂ©siliĂ© votre abonnement, il restera actif pour le reste de la pĂ©riode pour laquelle vous avez payĂ©. DĂ©couvrez-en plus ici.
Puis-je / comment puis-je télécharger des livres ?
Pour le moment, tous nos livres en format ePub adaptĂ©s aux mobiles peuvent ĂȘtre tĂ©lĂ©chargĂ©s via l’application. La plupart de nos PDF sont Ă©galement disponibles en tĂ©lĂ©chargement et les autres seront tĂ©lĂ©chargeables trĂšs prochainement. DĂ©couvrez-en plus ici.
Quelle est la différence entre les formules tarifaires ?
Les deux abonnements vous donnent un accĂšs complet Ă  la bibliothĂšque et Ă  toutes les fonctionnalitĂ©s de Perlego. Les seules diffĂ©rences sont les tarifs ainsi que la pĂ©riode d’abonnement : avec l’abonnement annuel, vous Ă©conomiserez environ 30 % par rapport Ă  12 mois d’abonnement mensuel.
Qu’est-ce que Perlego ?
Nous sommes un service d’abonnement Ă  des ouvrages universitaires en ligne, oĂč vous pouvez accĂ©der Ă  toute une bibliothĂšque pour un prix infĂ©rieur Ă  celui d’un seul livre par mois. Avec plus d’un million de livres sur plus de 1 000 sujets, nous avons ce qu’il vous faut ! DĂ©couvrez-en plus ici.
Prenez-vous en charge la synthÚse vocale ?
Recherchez le symbole Écouter sur votre prochain livre pour voir si vous pouvez l’écouter. L’outil Écouter lit le texte Ă  haute voix pour vous, en surlignant le passage qui est en cours de lecture. Vous pouvez le mettre sur pause, l’accĂ©lĂ©rer ou le ralentir. DĂ©couvrez-en plus ici.
Est-ce que MariaDB Cookbook est un PDF/ePUB en ligne ?
Oui, vous pouvez accĂ©der Ă  MariaDB Cookbook par Daniel Bartholomew en format PDF et/ou ePUB ainsi qu’à d’autres livres populaires dans Computer Science et Desktop Applications. Nous disposons de plus d’un million d’ouvrages Ă  dĂ©couvrir dans notre catalogue.

Informations

Année
2014
ISBN
9781783284399
Édition
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 des matiĂšres