Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Posts
    44

    Unanswered: 'MariaDB Cookbook' also valid for Oracle MySQL 5.6?

    Hi

    this book from Daniel Bartholomew seems very interesting.

    Can I practise this book also with MySQL 5.6? Are there things in die book that don't work with MySQL 5.6?


    Chapter 1: Getting Started with MariaDB
    Introduction
    Installing MariaDB on Windows
    Installing MariaDB on Linux
    Installing MariaDB on Mac OS X
    Enabling the Feedback plugin
    Switching between InnoDB and XtraDB
    Creating a backup user
    Making backups with XtraBackup
    Making backups with mysqldump
    Checking and optimizing tables automatically with mysqlcheck and cron
    Using progress reporting in the mysql client

    Up

    Chapter 2: Diving Deep into MariaDB
    Introduction
    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

    Up

    Chapter 3: Optimizing and Tuning MariaDB
    Introduction
    Using SHOW STATUS to check if a feature is being used
    Controlling MariaDB optimizer strategies
    Using extended keys with InnoDB and XtraDB
    Configuring the Aria two-step deadlock detection
    Configuring the MyISAM segmented key cache
    Configuring threadpool
    Configuring the Aria pagecache
    Optimizing queries with the subquery cache
    Optimizing semijoin subqueries
    Creating an index
    Creating a full-text index
    Removing an index
    Using JOINs
    Using microseconds in the DATETIME columns
    Updating DATETIME and TIMESTAMP columns automatically

    Up

    Chapter 4: The TokuDB Storage Engine
    Introduction
    Installing TokuDB
    Configuring TokuDB
    Creating TokuDB tables
    Migrating to TokuDB
    Adding indexes to TokuDB tables
    Modifying the compression of a TokuDB table

    Up

    Chapter 5: The CONNECT Storage Engine
    Introduction
    Installing the CONNECT storage engine
    Creating and dropping CONNECT tables
    Reading and writing CSV data using CONNECT
    Reading and writing XML data using CONNECT
    Accessing MariaDB tables using CONNECT
    Using the XCOL table type
    Using the PIVOT table type
    Using the OCCUR table type
    Using the WMI table type
    Using the MAC address table type

    Up

    Chapter 6: Replication in MariaDB
    Introduction
    Setting up replication
    Using global transaction IDs
    Using multisource replication
    Enhancing the binlog with row event annotations
    Configuring binlog event checksums
    Selectively skipping the replication of binlog events

    Up

    Chapter 7: Replication with MariaDB Galera Cluster
    Introduction
    Installing MariaDB Galera Cluster
    Dropping a node from MariaDB Galera Cluster
    Shutting down MariaDB Galera Cluster

    Up

    Chapter 8: Performance and Usage Statistics
    Introduction
    Installing the Audit Plugin
    Using the Audit Plugin
    Using engine-independent table statistics
    Using extended statistics
    Enabling the performance schema
    Using the performance schema

    Up

    Chapter 9: Searching Data Using Sphinx
    Introduction
    Installing SphinxSE in MariaDB
    Installing the Sphinx daemon on Linux
    Installing the Sphinx daemon on Windows
    Configuring the Sphinx daemon
    Searching with the Sphinx daemon and SphinxSE

    Up

    Chapter 10: Exploring Dynamic and Virtual Columns in MariaDB
    Introduction
    Creating tables with dynamic columns
    Inserting, updating, and deleting dynamic column data
    Reading data from a dynamic column
    Using virtual columns

    Up

    Chapter 11: NoSQL with HandlerSocket
    Introduction
    Installing and configuring HandlerSocket
    Installing the libhsclient library
    Installing the HandlerSocket PERL client libraries
    Reading data using HandlerSocket and PERL
    Inserting data using HandlerSocket and PERL
    Updating and deleting data using HandlerSocket and PERL
    Installing the HandlerSocket Python client libraries
    Reading data using HandlerSocket and Python
    Inserting data using HandlerSocket and Python
    Updating and deleting data using HandlerSocket and Python
    Installing the HandlerSocket Ruby client libraries
    Reading data using HandlerSocket and Ruby
    Inserting data using HandlerSocket and Ruby
    Updating and deleting data using HandlerSocket and Ruby
    Using HandlerSocket directly with Telnet

    Up

    Chapter 12: NoSQL with the Cassandra Storage Engine
    Introduction
    Installing the Cassandra storage engine
    Mapping data between MariaDB and Cassandra
    Using INSERT, UPDATE, and DELETE with the Cassandra storage engine
    Using SELECT with the Cassandra storage engine

    Up

    Chapter 13: MariaDB Security
    Introduction
    Securing MariaDB with mysql_secure_installation
    Securing MariaDB files on Linux
    Securing MariaDB files on Windows
    Checking for users with insecure passwords
    Encrypting connections with SSL
    Using roles to control user permissions
    Authenticating using the PAM authentication plugin
    MariaDB Cookbook | Packt Publishing

    Language : 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

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    maria is a fork of MySQL (started when Oracle bought out Sun who had in turn recently accquired MySQL
    MariaDB - Wikipedia, the free encyclopedia sugegsts that the fork happened after version 5.5 of MySQL
    MariaDB version numbers, until 5.5, followed MySQL's numbers. Thus, if one uses MariaDB 5.5 one knows that all features from MySQL 5.5 are available.
    , so most if not all features of the book should be dooable in MySQL 5.6. to find the definitive list look at the change log for MYSQL 5.6

    Bear in mind that MySQL doesn't use INNODB engine, its replaced with XtraDB in place, Maria also offers the Cassandra engine.

    Havign said that, in all honesty if you are using a book that uses maria, why the heck would you want to use MySQL as your testbed?

    short of reading the book in detail no one here is going to be abel to give you a defintive answer
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2012
    Posts
    44
    Bear in mind that MySQL doesn't use INNODB engine, its replaced with XtraDB in place, Maria also offers the Cassandra engine.
    you mean MariaDB? Not MySQL?

    Havign said that, in all honesty if you are using a book that uses maria, why the heck would you want to use MySQL as your testbed?
    There almost no MySQL books for 5.6 version. I own "'MySQL', by Paul DuBois, Addison-Wesley Professional", but it's very basic level.

    I use MySQL 5.6 at work and wish to prepare for MySQL 5.6 exams. Sadly there is no study guide for

    1Z0-882 Oracle Certified Professional, MySQL 5.6 Developer
    1Z0-883 Oracle Certified Professional, MySQL 5.6 Database Administrator

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •