What do you think?
Rate this book
MariaDB Cookbook
Over 95 recipes to unlock the power of MariaDB 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. 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.
282 pages, Paperback
First published January 1, 2014
9 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 5 of 5 reviews
May 26, 2014
The MariaDB Cookbook says it's a book for people wanting to get to know MariaDB, specifically if they already have experience with databases and want to know what sets MariaDB apart. True to its word, the book starts by introducing a concise but comprehensive set of recipes ranging from simple backups to the first steps in setting up a highly performant, secure and scalable database infrastructure.
I would highly recommend this book to anyone who already has set up and/or administrated a database and is considering taking a closer look at MariaDB, or for anyone who has done simple things with MariaDB and would like to see a few options on how to scale their infrastructure. I found the book contained quite a few inspiring chapters on how to tune performance or usability in ways tailored to your specific needs. It also has some really interesting sections on setting up durable database clusters for the purpose of redundance, load balancing, etc. I would not recommend it to anybody who is unfamiliar with databases in general or to people who already know what they want to do and are wanting to understand the theory and processes involved on a more in-depth level. This is not the MariaDB Cookbook's intended audience.
That said, if you are looking for quick tutorials that explain exactly what you need to know - and not more - in order to familiarize yourself with MariaDB, you'll find the MariaDB Cookbook fits your needs precisely. It gives you a well-organized and concise glimpse into the world of MariaDB and also tells you where you can find additional information if you're interested in pursuing the background.
Although the author did a good job of explaining the basics, like how to install MariaDB on the various major OS, my favorite chapters were the somewhat more advanced topics. There's lots there about checking and optimizing tables, optimizing queries, installing plugins, switching to different storage engines, avoiding deadlocks and managing your threadpool in the first chapters. They're followed by (among other topics) sections on the very interesting CONNECT engine, which allows accessing data from heterogeneous sources from MariaDB, and various strategies for replicating the database and working with clusters. Shortly afterwards, the author discusses auditing before moving on to more exotic topics, such as virtual and dynamic columns,as well as full-text searches with Sphinx. The book ends by explaining some basic ways of securing your database on different platforms.
All in all, a fast read that's well worth your time if you have intermediate database knowledge at the get-go. I will definitely be looking things up in it again when I start my next project requiring a relational database.
I would highly recommend this book to anyone who already has set up and/or administrated a database and is considering taking a closer look at MariaDB, or for anyone who has done simple things with MariaDB and would like to see a few options on how to scale their infrastructure. I found the book contained quite a few inspiring chapters on how to tune performance or usability in ways tailored to your specific needs. It also has some really interesting sections on setting up durable database clusters for the purpose of redundance, load balancing, etc. I would not recommend it to anybody who is unfamiliar with databases in general or to people who already know what they want to do and are wanting to understand the theory and processes involved on a more in-depth level. This is not the MariaDB Cookbook's intended audience.
That said, if you are looking for quick tutorials that explain exactly what you need to know - and not more - in order to familiarize yourself with MariaDB, you'll find the MariaDB Cookbook fits your needs precisely. It gives you a well-organized and concise glimpse into the world of MariaDB and also tells you where you can find additional information if you're interested in pursuing the background.
Although the author did a good job of explaining the basics, like how to install MariaDB on the various major OS, my favorite chapters were the somewhat more advanced topics. There's lots there about checking and optimizing tables, optimizing queries, installing plugins, switching to different storage engines, avoiding deadlocks and managing your threadpool in the first chapters. They're followed by (among other topics) sections on the very interesting CONNECT engine, which allows accessing data from heterogeneous sources from MariaDB, and various strategies for replicating the database and working with clusters. Shortly afterwards, the author discusses auditing before moving on to more exotic topics, such as virtual and dynamic columns,as well as full-text searches with Sphinx. The book ends by explaining some basic ways of securing your database on different platforms.
All in all, a fast read that's well worth your time if you have intermediate database knowledge at the get-go. I will definitely be looking things up in it again when I start my next project requiring a relational database.
May 15, 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 Security
Precisely 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
Precisely 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
June 24, 2014
Even though I've been working with MariaDB for over a year now, I sometimes found myself get stuck in some cases where the normal SQL statements could not help. Then I got this MariaDB Cookbook from the PacktPub. It contains a lot of tricks which can help me overcome any situation. The book has over 95 recipes to help the reader, the DB Admin, to unlock the power of MariaDB. It will show you a lot of techniques from how to set up MariaDB the right way in multiple platform to using MariaDB with modern storage engines like TokuDB or Cassandra to speed up the database.
Trust me, If you want to get the most out of MariaDB, you need to read this book.
Trust me, If you want to get the most out of MariaDB, you need to read this book.
April 21, 2014
I really enjoyed this book! Unfortunately most books of this type take the standard approach of rehashing the basics that you can find on the web. The author decided to take a different path with this book. He covers features that you may not have been aware of but that you may find useful. This includes different storage engines, full text indexing , virtual columns, advance replication. Check out the table of contents!
May 7, 2014
Easy read on intermediate/advance recipes that makes a great reference book after read. Good information in a practical format.
Displaying 1 - 5 of 5 reviews