Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • MariaDb Essentials
  • Toc
  • feedback
MariaDb Essentials

MariaDb Essentials

By : Kenler
4.5 (2)
close
MariaDb Essentials

MariaDb Essentials

4.5 (2)
By: Kenler

Overview of this book

This book will take you through all the nitty-gritty parts of MariaDB, right from the creation of your database all the way to using MariaDB’s advanced features. At the very beginning, we show you the basics, that is, how to install MariaDB. Then, we walk you through the databases and tables of MariaDB, and introduce SQL in MariaDB. You will learn about all the features that have been added in MariaDB but are absent in MySQL. Moving on, you’ll learn to import and export data, views, virtual columns, and dynamic columns in MariaDB. Then, you’ll get to grips with full-text searches and queries in MariaDb. You’ll also be familiarized with the CONNECT storage engine. At the end of the book, you’ll be introduced to the community of MariaDB.
Table of Contents (10 chapters)
close
close
Preface
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Free Chapter
1
1. Installing MariaDB
1. Installing MariaDB
Choosing a MariaDB version
Installing MariaDB
Starting and stopping MariaDB
Getting started with the mysql client
Configuring MariaDB
Upgrading MariaDB
Managing plugins
Summary
2
2. Databases and Tables
2. Databases and Tables
Working with databases
Working with tables
Working with columns
Storage engines
Indexing
Using comments
Working with metadata
Creating an installation script
Summary
3
3. Getting Started with SQL
3. Getting Started with SQL
Working with rows
Understanding transactions
Foreign keys
Dealing with duplicates and consistency errors
Reading rows
Joining tables
Working with operators
Working with times and dates
Using comments to annotate your database schema
Summary
4
4. Importing and Exporting Data
4. Importing and Exporting Data
The basics of importing and exporting data
Creating and importing CSV files
Creating and importing a dump file
Speeding up data import
Summary
5
5. Views and Virtual Columns
5. Views and Virtual Columns
Views
Virtual and persistent columns
Summary
6
6. Dynamic Columns
6. Dynamic Columns
The problem: storing non-homogeneous data
Dynamic columns
Summary
7
7. Full-Text Searches
7. Full-Text Searches
Defining a full-text search
Full-text searches in MySQL and MariaDB
Working with full-text indexes
Full-text queries
Mroonga
Connecting MariaDB to Sphinx
Summary
8
8. Using the CONNECT Storage Engine
chevron up
8. Using the CONNECT Storage Engine
Understanding the CONNECT storage engine
Accessing CSV files
Accessing XML and HTML files
Using the XCOL table type
Using the OCCUR table type
Using the PIVOT table type
The MariaDB community
MariaDB resources
Included storage engines
Summary
9
Index
Index

Understanding the CONNECT storage engine

The CONNECT storage engine has been designed for accessing data from external sources using MariaDB. This engine is not designed for OLTP, that is, you should not use it as the main engine for storing the data in your application. In fact, the data are never stored in MariaDB. The CONNECT storage engine should be used for Business Intelligence tasks such as creating data from the different sources available in one place.

Usually, the BI tasks are done through an ETL, then the data are computed, and specific tools are used for the reporting. Thanks to the CONNECT storage engine, standard tables can be used to access external data from MariaDB.

In other words, the CONNECT storage engine allows you to query external data by using the SQL language.

On some distributions, the library for the engine is not packaged directly with MariaDB. For example, for Debian and Ubuntu, you need to install the mariadb-connect-engine-10.0 package.

To enable the CONNECT storage...

End of Section 1
Next Section
bookmark search playlist font-size

Change the font size

margin-width

Change margin width

day-mode

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Delete Bookmark

Modal Close icon
Are you sure you want to delete it?
Cancel
Yes, Delete