Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
MariaDb Essentials

You're reading from   MariaDb Essentials Quickly get up to speed with MariaDB—the leading, drop-in replacement for MySQL, through this practical tutorial

Arrow left icon
Product type Paperback
Published in Oct 2015
Publisher
ISBN-13 9781783982868
Length 206 pages
Edition 1st Edition
Tools
Arrow right icon
Toc

Table of Contents (10) Chapters Close

Preface 1. Installing MariaDB 2. Databases and Tables FREE CHAPTER 3. Getting Started with SQL 4. Importing and Exporting Data 5. Views and Virtual Columns 6. Dynamic Columns 7. Full-Text Searches 8. Using the CONNECT Storage Engine Index

Choosing a MariaDB version

Choosing a MariaDB version is the first step to take. The MariaDB version numbers are composed of the following parts:

  • A major version
  • A minor version
  • A patch number

The major and the minor versions identify a tree, for example: 10.0. Each new tree adds some features that were not in the previous tree, but could also add minor incompatibilities. Each patch fixes some bugs, and may introduce some minor features.

We generally want to install the latest stable tree. Older trees can be useful in the rare case where we need to run an application that is not compatible, or runs slower, with the most recent trees. Development trees are not stable, and should not be used in production. However, they are useful for testing new features before they become stable.

Before becoming stable, a tree goes through the following states:

  • Alpha: In this state, the releases do not disturb the normal operations for most users, and contain the changes made in MySQL until at least the latest stable build
  • Beta: At this stage, the tree contains all the features that were planned for this tree, and the API and storage formats are stable
  • Release candidate: The tree is ready to be promoted as stable at this stage, but more testing is required.

At the time of writing, the most recent stable tree is 10.0, whereas a 10.1 development tree exists.

We always download the most recent release from the chosen tree. The older releases remain available for people who are affected by a recently introduced bug. However, before deciding to downgrade, consider that the recent versions may also fix security vulnerabilities.

The MariaDB documentation contains a list of the trees that are currently supported and a table showing when the support for current versions will be discontinued. The support also depends on the system on which MariaDB is installed, because very old versions of operating systems are not supported. This information is available at the following URL: https://mariadb.com/kb/en/mariadb/development/deprecation-policy/.

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image