MariaDB Cookbook
By Daniel Bartholomew
Publisher: Packt Publishing
Final Release Date: March 2014
Pages: 282

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.

Product Details
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyMariaDB Cookbook
 
5.0

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (3)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

  • Easy to understand (3)

Cons

    Best Uses

    • Intermediate (3)

    Reviewed by 3 customers

    Sort by

    Displaying reviews 1-3

    Back to top

     
    5.0

    This book is amazing

    By MinhKiller

    from Vietnam

    About Me Developer

    Verified Reviewer

    Pros

    • Accurate
    • Easy to understand
    • Helpful examples

    Cons

      Best Uses

      • Expert
      • Intermediate

      Comments about oreilly MariaDB Cookbook:

      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 MariaDB
      If 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

       
      5.0

      Good Recipe Book!

      By Big Daddy

      from NC

      About Me Sys Admin

      Verified Reviewer

      Pros

      • Concise
      • Easy to understand
      • Helpful examples

      Cons

        Best Uses

        • Intermediate

        Comments about oreilly MariaDB Cookbook:

        Easy read of intermediate/advanced recipes. Makes a good reference book after reading it.

         
        5.0

        Not your basic cookbook

        By The soccer playing DBA

        from Charlotte NC

        About Me Sys Admin

        Verified Reviewer

        Pros

        • Concise
        • Easy to understand

        Cons

          Best Uses

          • Expert
          • Intermediate

          Comments about oreilly MariaDB Cookbook:

          This book is not your basic "cookbook" . There are some basic topics covered, but instead of focusing on basic topics you can web search in a couple of minutes, the author chooses to concentrate on an overview advanced topics. These include changing storage engines (Tokudb, NoSQL , Connect) ,Sphinx text search, replication and dynamic and virtual columns.

          Displaying reviews 1-3

          Back to top

           
          Buy 2 Get 1 Free Free Shipping Guarantee
          Buying Options
          Immediate Access - Go Digital what's this?
          Ebook: $29.99
          Formats:  ePub, Mobi, PDF