MariaDB Cookbook: Learn how to use the database that's growing in popularity as a drop-in replacement for MySQL. The MariaDB Cookbook is overflowing with handy recipes and code examples to help you become an expert simply and speedily.

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

MariaDB Cookbook

Chapter 2. Diving Deep into MariaDB

In this chapter, we will cover the following recipes:

Importing the data exported by mysqldump
Using SHOW EXPLAIN with running queries
Using LIMIT ROWS EXAMINED
Using INSTALL SONAME
Producing HTML output
Producing XML output
Migrating a table from MyISAM to Aria
Migrating a table from MyISAM or Aria to InnoDB or XtraDB

What you will learn

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

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

Frequently bought together

$48.99

$54.99

$54.99

Total $ 158.97

Filter reviews by

All

Amazon verified reviews

123monkey45 Apr 16, 2014

This is a very useful book but the title is not exactly correct. This is not what one usually thinks of as a cookbook and to be fair the author states this in the introduction.This book isn't chock full of the usual how to create users. how to create tables ......, rather the author recommends you get an intro book for that. What this book does have is good coverage of advanced features of MariaDB. To name a few , changing storage engines (Tokudb,Connect,NoSQL), replication including Galera cluster, Sphinx text search, dynamic and virtual columns.This book is excellent in this regard it will make you aware of features you may not have known even existed and for that reason I would recommend buying it.

Amazon Verified review

Minh Tran May 18, 2014

I worked for MySQL for 7, 8 years and i am very interesting to read this book. The author has very much experience on Maria DB. He explained most of the thing short and clear that you could follow immediately.You could found most of good stuffs related to MariaDB like: * Migrate your current MySQL database to MariaDB * Talked about some interesting engines: Aria, CONNECT, TokuDB engines. * Optimization and Tuning are also mentioned * Some very specific features for MariaDB like Dynamic & Virtual Columns are understandable and able to apply easily.Besides talking about normal full text search support like other normal database, author also shows us about the search feature with Sphinx.For someone who wants to set up your database as clustering, you could found in a chapter with MariaDB Cluster. Author puts every detail for you that could follow quickly.Even author has a chapter talks about HandlerSocket plugin that allows programming languages (Perl, Python, Ruby) to interact with MariaDB directly. I would like to see more about other programming languages like Java and .NET, how do they interact with MariaDBIf author could provide some comparison for Dynamic & Virtual Columns from Maria DB with Schema less feature from NoSQL database, that would help much for us to choose the right database.This book is a very good start for Developers, DBAs, Consultants working with MariaDB. This is definitely in my must-read-book collection

LM Baker May 03, 2014

Written by someone who has been on board since the MariaDB project started, this cookbook is the ideal guide for those who want to unlock advanced features of MariaDB.

Pethuru Raj May 14, 2014

MariaDB is being prescribed as a venerable offshoot of the proven MySQL database technology yet it has surpassed comfortably its parent on several aspects in order to be a quick choice for many kinds of enterprise-scale and multi-tier applications. This book, not only provides a comprehensive introduction but also details all the latest developments around and on this fast-evolving database system. Besides the explanation of the installation, configuration, optimization and tuning of MariaDB, the author had tried to convey a lot of advanced topics that have a direct synchronization with the database in a seamless and sequential fashion. For example, he has described about the replication aspect in MariaDB. The chapter titled as "Replication with MariaDB Galera Cluster" includes recipes that cover how to install and use this new clustering solution. It seems that the author has a leaning towards multiple search engines (TokuDB Storage Engine CONNECT Storage Engine and Cassandra Storage Engine) and has explained the nitty-gritty in a spectacular style. There is an interesting chapter "Searching Data Using Sphinx" that covers how to install and use this useful full-text database indexer and search engine. Finally there is a separate chapter for MariaDB SecurityPrecisely speaking, this book is telling a compact and convincing story about the new database "MariaDB". I am doubly sure that this book is an awesome for developers, architects, evangelists, DB administrators, and consultants.

David Villalobos Jul 02, 2014

It is a bit complicated give my opinion about this book, the thing is that I expected more, let's see it this way, I bought the digital copy and it is OK, but, I will be very disappointed if I had bought the printed book since I think $45 is to much for this book.All the recipes are good, but I like a bit more technical explanation since I like to understand the thinks I am doing.