Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.

Advanced MariaDB

  • Course Code: Database Advanced MariaDB
  • Course Dates: Contact us to schedule.
  • Course Category: Big Data & Data Science Duration: 5 Days Audience: This course is for anyone who wants to explore and learn how to use features that make MariaDB different from other databases in its class in a practical, hands-on way

About this Course  

MariaDB is a mature, stable, open source relational database. From its beginning in 2009 as a branch or fork of the MySQL database, to its status today as the default version of that database in most Linux distributions, and the database of choice for many companies large and small, MariaDB has proven that communities of users and developers, working and collaborating together, can do more than a single company could ever do. 

MariaDB shares many features and capabilities of its parent database, but like most children it has also surpassed its parent in many ways. The recipes in this course tread some common ground, but they are mostly about the features that are unique to or were introduced first in MariaDB. 

The why of certain features is there, to a small degree, but the main emphasis in each recipe is on the what and the how.  The information you need to know to actually do something always trumps the theory behind it. 

This 5-day class takes you far beyond the basics, and gives you a practical, hands-on experience with this powerful, feature-rich database. 

What You Will Learn 

  • Install MariaBD on Windows, Mac OS X, and Linux 
  • Configure MariaDB for better performance using the features of version 10 
  • Get familiar with the usage of operators for retrieving rows more selectively 
  • Use MariaDB 10’s powerful tools to store, retrieve, and analyze data 
  • Secure MariaDB from unauthorized access 
  • Maintain the databases associated with MariaDB to ensure efficient and optimum functioning 
  • Retrieve data and learn how to sort, summarize, group, and manipulate it 

Audience 

This course is for anyone who wants to explore and learn how to use features that make MariaDB different from other databases in its class in a practical, hands-on way  

Course Outline 

Module 1: Getting Started with MariaDB 

  • 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 

Module 2: Diving Deep into MariaDB 

  • 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 

Module 3: Optimizing and Tuning MariaDB 

  • 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 

Module 4: The TokuDB Storage Engine 

  • Installing TokuDB 
  • Configuring TokuDB 
  • Creating TokuDB tables 
  • Migrating to TokuDB 
  • Adding indexes to TokuDB tables 
  • Modifying the compression of a TokuDB table 

Module 5: The CONNECT Storage Engine 

  • 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 

Module 6: Replication in MariaDB 

  • 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 

Module 7: Replication with MariaDB Galera Cluster 

  • Installing MariaDB Galera Cluster 
  • Dropping a node from MariaDB Galera Cluster 
  • Shutting down MariaDB Galera Cluster 

Module 8: Performance and Usage Statistics 

  • Installing the Audit Plugin 
  • Using the Audit Plugin 
  • Using engine-independent table statistics 
  • Using extended statistics 
  • Enabling the performance schema 
  • Using the performance schema 

Module 9: Searching Data Using Sphinx 

  • 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 

Module 10: Exploring Dynamic and Virtual Columns in MariaDB 

  • Creating tables with dynamic columns 
  • Inserting, updating, and deleting dynamic column data 
  • Reading data from a dynamic column 
  • Using virtual columns 

Module 11: NoSQL with HandlerSocket 

  • 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 

Module 12: NoSQL with the Cassandra Storage Engine 

  • 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 

Module 13: MariaDB Security 

  • 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 
View All Courses

    Course Inquiry

    Fill in the details below and we will get back to you as quickly as we can.

    Interested in any of these related courses?