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

Preface

Nowadays, computers are present everywhere, and they are all connected to each other. A lot of information is exchanged between them, but this data needs to be stored somewhere.

MariaDB is a fork of MySQL, started when MySQL was acquired by Sun Microsystems in 2008. Sun Microsytems and MySQL were then acquired by Oracle in 2009.

In most Linux distributions, MariaDB is now the default package, providing a relational database that is compatible with MySQL.

MariaDB has interesting new features, better testing, performance improvement, and bug fixes that are not available in MySQL.

This book provides an introduction to the SQL language. It presents some advanced features of MariaDB and features that aren't present in MySQL but come with MariaDB. By the end of this book, you should be able get your own MariaDB database server running and take advantage of its features.

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