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

The MariaDB community

MariaDB has been created by Michael "Monty" Widenius, the founder of MySQL, Monty Program Ab (which is now the MariaDB Corporation), and a founding member of the MariaDB Foundation, with the aim of being a backward compatible drop-in replacement for MySQL.

The goal of the MariaDB Foundation is to ensure that there is not just one entity that drives the development of MariaDB, and that the official MariaDB development tools stay open to the MariaDB developer community.

The core team is not only composed of members of the MariaDB Foundation, but of outsiders as well. Most companies and people working on MariaDB have joined the Foundation. This is the case because participating or committing code is not a prerequisite for being a part of the Foundation.

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