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.
  • Book Overview & Buying MariaDb Essentials
  • Table Of Contents Toc
  • Feedback & Rating feedback
MariaDb Essentials

MariaDb Essentials

By : Kenler
4.5 (2)
Buy this Book
close
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
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
chevron up
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
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

Mroonga

If you try to perform full-text searches in a document in the Chinese, Japanese, or Korean languages, you will notice that it either doesn't work very well or not at all.

The default full-text search feature uses spaces to separate words in a document. However, these languages usually do not use spaces as delimiters. As a result, standard full-text search engines are ineffective with the CJK languages. Moreover, these languages contain many words with less than four characters. So, the standard search method is not adapted at all, as it ignores short words with four or less characters by default.

A project was started in 2008 to try and solve this problem. The project was called Senna, and it tried to add Japanese language support to the full-text search feature of MySQL.

From 2011 onwards, a new project called Groonga, presented as the successor of Senna, started providing regular releases of a generic library that provides connections to different DBMSs. Mroonga is the MySQL storage...

Unlock full access

Continue reading for free

A Packt free trial gives you instant online access to our library of over 7000 practical eBooks and videos, constantly updated with the latest in tech
Start a 7-day FREE trial
End of Section 6
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

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY