MariaDB

2021年1月30日 (六) 00:24的版本

您可以在Wikipedia上了解到此条目的英文信息 MariaDB Thanks, Wikipedia.

Mariadb

简介

MariaDB is a community developed branch of MySQL. It's a branch of MySQL (ie, we are keeping our code in sync with MySQL) and contains in addition the Maria storage engine, updated version of other storage engines and extensions.

版本策略:目前所有MariaDB发行版都基于 MySQL 5.1. 当 MySQL 5.5 或 MySQL 5.6 变成 RC , 将切换到 MariaDB beta 版并基于RC版本上.

新闻

Google 已将 MySQL 迁移 MariaDB，Google 将其主要用于广告业务。
维基百科正式从MySQL迁移到MariaDB数据库 2013.04
Wikipedia数据库开始从MySQL迁移到MariaDB 2012.12

自http://blog.mariadb.org/feed/加载RSS失败或RSS源被墙

版本

MariaDB Releases

MariaDB tree	MySQL tree
5.1	5.1
5.2	5.1
5.3	5.1
5.5	5.5
10.0	5.5, partly 5.6

MariaDB 每年会发布一个 GA 稳定版 MariaDB 基金会也保证每个版本都会至少维护5年，可以理解为 Long Term Support (LTS)。

10.x

MariaDB 10.x 分支：

10.0

5.5

MariaDB 5.5.30 包含 MariaDB 5.3.12 和 MySQL 5.5.30

5.4

5.3

MariaDB 5.3 将基于 MySQL 5.1 或 MySQL 5.6

5.2

MariaDB 5.2 基于 MySQL 5.1

主要的新功能有:

Storage-engine-specific CREATE TABLE
Pluggable Authentication
Segmented Key Cache; Speeds up MyISAM tables a LOT!
Extended User Statistics
Virtual Columns
New storage engines: OQGRAPH and Sphinx.
Speed optimizations

5.1

MariaDB 5.1 基于 MySQL 5.1

主要的新功能有:

XtraDB a drop-in replacement for InnoDB based on the InnoDB_plugin. This is enabled by default and gives you the speed comparable to MySQL 5.5 today.
New storage engines: PBXT, FederatedX (drop-in replacement for Federated) and Aria.
Pool of Threads: Allows you to have 100,000+ connections.
Table elimination: Optimizer enhancement.
More information in the logs for better troubleshooting.
Speed optimizations

指南

OS X

brew info mariadb
brew install mariadb // 通过 Homebrew 安装, brew services start mariadb 和 brew services stop mariadb
unset TMPDIR
cd /usr/local/Cellar/mariadb/10.0.14_1/
mysql_install_db
mysql.server start
mysql_secure_installation
mysql -u root -p
MariaDB [(none)]> select @@version;
+-----------------+
| @@version       |
+-----------------+
| 10.0.14-MariaDB |
+-----------------+
1 row in set (0.00 sec)

Installing MariaDB 10.0.10 on Mac OS X with Homebrew

升级

brew update
brew upgrade mariadb

Debian

$ sudo apt update
$ sudo apt install mariadb-server
$ sudo mysql_secure_installation
$ sudo mysql
MariaDB [(none)]> GRANT ALL ON *.* TO 'admin'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> exit
$ sudo systemctl status mariadb
$ sudo mysqladmin version
$ mysqladmin -u admin -p version

选择其它仓库：Setting up MariaDB Repositories

CentOS

How To Install MariaDB on CentOS 8

$ sudo yum install libmariadb-dev 也安装上开发工具包

$ sudo mysql_secure_installation 设置 root 密码等

Container

Docker Official Image

编译

cd $maria-source-dir 
BUILD/autorun.sh
./configure
make
sudo make install

sudo chown -R mysql /usr/local/mysql/
sudo scripts/mysql_install_db --user=mysql
sudo /usr/local/mysql/bin/mysqld_safe --port=3307 --user=mysql &
./bin/mysqladmin -uroot password 'password'

存储引擎

MariaDB Storage Engines

Cassandra

Cassandra Storage Engine is no longer actively being developed and has been removed in MariaDB 10.6

MariaDB Cassandra Storage Engine
MariaDB的Cassandra存储引擎，允许MariaDB通过标准SQL语法使用Cassandra集群。

ColumnStore

MariaDB ColumnStore

此列式存储是基于 InfiniDB 4.6.7 并移植到 MariaDB 的

Amazon

Amazon RDS for MariaDB

.NET

Connector/Net is a fully-managed ADO.NET driver for MySQL.
MariaDB Connector/NET

MaxScale

MaxScale @ GitHub

管理

Graphical and Enhanced Clients

解决方案

High Availability & Performance Tuning replication, clustering, multi-master and performance tuning solutions. OLTP（InnoDB），OLAP（ColumnStore），HTAP（MaxScale）解决方案：

MariaDB Platform X3
Vitess MySQL Cluster
MariaDB TX for OLTP
MariaDB AX for OLAP
MariaDB Galera Cluster
Galera Cluster Galera @ GitHub
How to setup HAProxy as Load Balancer for MariaDB on CentOS 7

书籍

《MariaDB原理与实现》

用户

图集

架构
MariaDB Foundation
MariaDB Platform X3
MariaDB Platform X3
MariaDB Platform X3
MariaDB TX for OLTP
MariaDB AX for OLAP
OpenStack
Cassandra存储引擎
MySQL兼容性
Galera复制
列式存储架构

链接

@@ 第129行： / 第129行： @@
 $ sudo mysql_secure_installation 设置 root 密码等
+===[[Container]]===
+*[https://github.com/docker-library/mariadb Docker Official Image]
 ===编译===