|Also available on:|
- Enable performance-enhancing optimizations
- Connect to different databases and file formats
- Filled with clear step-by-step instructions that can be run on a live database
Book DetailsLanguage : English
Paperback : 282 pages [ 235mm x 191mm ]
Release Date : March 2014
ISBN : 1783284390
ISBN 13 : 9781783284399
Author(s) : Daniel Bartholomew
Topics and Technologies : All Books, Big Data and Business Intelligence, Cookbooks, Open Source
Table of Contents
Chapter 1: Getting Started with MariaDB
Chapter 2: Diving Deep into MariaDB
Chapter 3: Optimizing and Tuning MariaDB
Chapter 4: The TokuDB Storage Engine
Chapter 5: The CONNECT Storage Engine
Chapter 6: Replication in MariaDB
Chapter 7: Replication with MariaDB Galera Cluster
Chapter 8: Performance and Usage Statistics
Chapter 9: Searching Data Using Sphinx
Chapter 10: Exploring Dynamic and Virtual Columns in MariaDB
Chapter 11: NoSQL with HandlerSocket
Chapter 12: NoSQL with the Cassandra Storage Engine
Chapter 13: MariaDB Security
Download the code and support files for this book.
Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.
What you will learn from this book
- Enable various MariaDB optimizations
- Link MariaDB to a Cassandra cluster
- Enable and use the TokuDB storage engine
- Read from and write to various data formats including XML and CSV
- Search through your data with Sphinx
- Connect to other databases with ODBC
- Tune MariaDB for the best performance
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.
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.