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

MariaDB resources

We have covered a lot of topics in this book, but not everything. Here is a list of useful resources for finding more information on the topics discussed in this book, to discover other features, or to get help from the MariaDB experts.

The MariaDB website (https://mariadb.org) is the first place you should search. You can find the download links for MariaDB, the MariaDB blog, and other official MariaDB information at this website.

The second source of information is the MariaDB Knowledge Base (https://mariadb.com/kb/en/). The complete documentation, the release notes, and change logs can be found in the Knowledge Base. The documentation is often updated and you will always find information about the most recent features.

If you want to get in touch with other MariaDB users, there are several ways to do so.

You can use the IRC channel, where you can start a real-time chat with other people. As indicated in the Knowledge Base (https://mariadb.com/kb/en/meta/irc/), the official...

End of Section 8
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