MariaDB

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
(图集)
(存储引擎)
 
(未显示1个用户的32个中间版本)
第2行: 第2行:
 
[[Image:Mariadb-foundation.png|right]]
 
[[Image:Mariadb-foundation.png|right]]
  
Mariadb
+
MariaDB
 +
 
 +
[[文件:LAMP-stack.png|right|LAMP stack]]
  
 
==简介==
 
==简介==
第9行: 第11行:
 
版本策略:目前所有MariaDB发行版都基于 MySQL 5.1. 当 MySQL 5.5 或 MySQL 5.6 变成 RC , 将切换到 MariaDB beta 版并基于RC版本上.
 
版本策略:目前所有MariaDB发行版都基于 MySQL 5.1. 当 MySQL 5.5 或 MySQL 5.6 变成 RC , 将切换到 MariaDB beta 版并基于RC版本上.
 
[[文件:mariadb-mysql.jpg|right]]
 
[[文件:mariadb-mysql.jpg|right]]
 +
 
==新闻==
 
==新闻==
 
*Google 已将 MySQL 迁移 MariaDB,Google 将其主要用于广告业务。
 
*Google 已将 MySQL 迁移 MariaDB,Google 将其主要用于广告业务。
 
*[http://www.csdn.net/article/2013-04-25/2815038-Wikipedia-MySQL-MariaDB 维基百科正式从MySQL迁移到MariaDB数据库] 2013.04
 
*[http://www.csdn.net/article/2013-04-25/2815038-Wikipedia-MySQL-MariaDB 维基百科正式从MySQL迁移到MariaDB数据库] 2013.04
 
*[http://lists.wikimedia.org/pipermail/wikitech-l/2012-December/064994.html Wikipedia数据库开始从MySQL迁移到MariaDB] 2012.12
 
*[http://lists.wikimedia.org/pipermail/wikitech-l/2012-December/064994.html Wikipedia数据库开始从MySQL迁移到MariaDB] 2012.12
<rss>http://blog.mariadb.org/feed/|short|date|max=10</rss>
+
<rss>https://mariadb.org/planet-rss|short|date|max=10</rss>
  
 
==版本==
 
==版本==
第110行: 第113行:
  
 
===Debian===
 
===Debian===
 +
[https://www.linuxcapable.com/how-to-install-mariadb-10-7-on-debian-11-bullseye/ How to Install MariaDB 10.7 on Debian 11 Bullseye]
 
  $ sudo apt update
 
  $ sudo apt update
 
  $ sudo apt install mariadb-server
 
  $ sudo apt install mariadb-server
第129行: 第133行:
  
 
$ sudo mysql_secure_installation 设置 root 密码等
 
$ sudo mysql_secure_installation 设置 root 密码等
 +
 +
===[[Container]]===
 +
[https://mariadb.com/kb/en/creating-a-custom-docker-image/ Creating a Custom Docker Image]
 +
*[https://github.com/docker-library/mariadb Docker Official Image]
 +
*[https://github.com/docker-library/mysql MySQL Image]
  
 
===编译===
 
===编译===
第141行: 第150行:
 
  sudo /usr/local/mysql/bin/mysqld_safe --port=3307 --user=mysql &
 
  sudo /usr/local/mysql/bin/mysqld_safe --port=3307 --user=mysql &
 
  ./bin/mysqladmin -uroot password 'password'
 
  ./bin/mysqladmin -uroot password 'password'
 +
 +
==项目==
 +
*[https://github.com/MariaDB/server MariaDB @ GitHub]
 +
*[https://github.com/mariadb-corporation/ MariaDB Corporation @ GitHub]
 +
*[https://github.com/mariadb-developers Developer Code Central @ GitHub]
  
 
==存储引擎==
 
==存储引擎==
第148行: 第162行:
 
*[[InnoDB]]
 
*[[InnoDB]]
 
*[[Sphinx]]SE
 
*[[Sphinx]]SE
 +
 +
===Graph===
 +
[https://mariadb.com/kb/en/oqgraph-storage-engine/ OQGRAPH] [[graph database]]
 +
 +
===CONNECT===
 +
[https://mariadb.com/kb/en/connect/ CONNECT storage engine]
 +
sudo apt-get install mariadb-plugin-connect
 +
or sudo yum install MariaDB-connect-engine
 +
MariaDB [mysql]> show plugins;
 +
 +
===Archive===
 +
[https://mariadb.com/kb/en/archive/ ARCHIVE storage engine]
 +
MariaDB [mysql]> INSTALL PLUGIN Archive SONAME 'ha_archive.so';
 +
 +
===FederatedX===
 +
[https://mariadb.com/kb/en/federatedx-storage-engine/ FederatedX Storage Engine]
 +
MariaDB [mysql]> INSTALL SONAME 'ha_federatedx';
 +
 +
===MyRocks===
 +
[https://mariadb.com/kb/en/myrocks/ MyRocks] 是一个 MariaDB 存储引擎,它将 [[RocksDB]] 数据库添加到 MariaDB 中。RocksDB 是一个LSM数据库,具有很好的压缩比,针对闪存进行了优化。
 +
sudo apt-get install mariadb-plugin-rocksdb
 +
or sudo yum install MariaDB-rocksdb-engine
 +
MariaDB [mysql]> INSTALL SONAME 'ha_rocksdb';
 +
SHOW PLUGINS;
 +
SHOW VARIABLES LIKE 'rocksdb_supported_compression_types';
 +
 +
===Spider===
 +
[https://mariadb.com/kb/en/spider/ Spider storage engine]
 +
 +
[https://mariadb.com/docs/storage-engines/spider/spider-use-cases/#spider-use-cases Comparing Spider to Features in Other Databases]
 +
 +
{| class="wikitable"
 +
|-
 +
! Database
 +
! Feature
 +
|-
 +
| [[Oracle]]
 +
| Database Links
 +
|-
 +
| [[Microsoft SQL Server]]
 +
| Linked Servers
 +
|-
 +
| [[SAP]]/[[Sybase]]
 +
| Remote Servers and Proxy Tables
 +
|-
 +
| [[PostgreSQL]]
 +
| Foreign Data Wrappers
 +
|-
 +
| [[MySQL]]
 +
| FEDERATED Storage Engine
 +
|}
  
 
==Cassandra==
 
==Cassandra==
第155行: 第220行:
  
 
==ColumnStore==
 
==ColumnStore==
[https://mariadb.com/kb/en/mariadb-columnstore/ MariaDB ColumnStore]
+
*[https://github.com/mariadb-corporation/mariadb-columnstore-engine ColumnStore @ GitHub]
 
+
*[https://mariadb.com/kb/en/mariadb-columnstore/ MariaDB ColumnStore]
此列式存储是基于 [[InfiniDB]] 4.6.7 并移植到 MariaDB 的
+
*此列式存储是基于 [[InfiniDB]] 4.6.7 并移植到 MariaDB 的
  
 
==Amazon==
 
==Amazon==
第168行: 第233行:
 
==MaxScale==
 
==MaxScale==
 
*[https://github.com/mariadb-corporation/MaxScale MaxScale @ GitHub]
 
*[https://github.com/mariadb-corporation/MaxScale MaxScale @ GitHub]
 +
 +
==Xpand==
 +
*[https://mariadb.com/products/enterprise/xpand/ Distributed SQL Powered by MariaDB Xpand]
 +
*[https://mariadb.com/resources/blog/the-xpand-difference/ The Xpand Difference]
 +
 +
==连接器==
 +
*[https://github.com/mariadb-corporation/mariadb-connector-r2dbc MariaDB R2DBC connector] [https://github.com/r2dbc R2DBC – Reactive Relational Database Connectivity]
  
 
==管理==
 
==管理==
 
[https://mariadb.com/kb/en/graphical-and-enhanced-clients/ Graphical and Enhanced Clients]
 
[https://mariadb.com/kb/en/graphical-and-enhanced-clients/ Graphical and Enhanced Clients]
 +
*[https://github.com/webyog/sqlyog-community SQLyog Community Edition]
 
*[[phpMyAdmin]]
 
*[[phpMyAdmin]]
 
*[[Sequel Pro]]
 
*[[Sequel Pro]]
第178行: 第251行:
 
==解决方案==
 
==解决方案==
 
[[文件:MariaDB-Galera-Cluster.png|right]]
 
[[文件:MariaDB-Galera-Cluster.png|right]]
[https://mariadb.com/kb/en/replication-cluster-multi-master/ High Availability & Performance Tuning] replication, clustering, multi-master and performance tuning solutions.
+
[https://mariadb.com/kb/en/replication-cluster-multi-master/ High Availability & Performance Tuning] replication, clustering, multi-master and performance tuning solutions. OLTP(InnoDB),OLAP(ColumnStore),HTAP(MaxScale)解决方案:
 +
*[https://mariadb.com/kb/en/mariadb-platform-x3/ MariaDB Platform X3]
 
*[[Vitess]] MySQL Cluster  
 
*[[Vitess]] MySQL Cluster  
 
*[https://mariadb.com/products/solutions/oltp-database-tx MariaDB TX] for [[OLTP]]
 
*[https://mariadb.com/products/solutions/oltp-database-tx MariaDB TX] for [[OLTP]]
 
*[https://mariadb.com/products/solutions/olap-database-ax MariaDB AX] for [[OLAP]]
 
*[https://mariadb.com/products/solutions/olap-database-ax MariaDB AX] for [[OLAP]]
*[https://mariadb.com/kb/en/mariadb/what-is-mariadb-galera-cluster/ MariaDB Galera Cluster]
+
*[[Galera Cluster]] [https://mariadb.com/kb/en/galera-cluster/ MariaDB Galera Cluster]
*[[Galera Cluster]] [https://github.com/codership/galera Galera @ GitHub]
+
 
*[https://www.howtoforge.com/tutorial/how-to-setup-haproxy-as-load-balancer-for-mariadb-on-centos-7/ How to setup HAProxy as Load Balancer for MariaDB on CentOS 7]
 
*[https://www.howtoforge.com/tutorial/how-to-setup-haproxy-as-load-balancer-for-mariadb-on-centos-7/ How to setup HAProxy as Load Balancer for MariaDB on CentOS 7]
 +
 +
[[文件:Galera-4-Versions.png]]
 +
 +
===[https://mariadb.com/products/skysql/ SkySQL]===
 +
*[https://mariadb.com/kb/en/standard-replication/ MariaDB Replication]
 +
*[[Galera Cluster]] [https://github.com/codership/galera Galera @ GitHub]
 +
*[https://mariadb.com/resources/blog/uses-for-mariadb-and-the-spider-storage-engine/ Uses for MariaDB and the Spider Storage Engine]
 +
*[https://mariadb.com/resources/blog/how-mariadb-achieves-global-scale-with-xpand/ How MariaDB Achieves Global Scale with Xpand]
 +
 +
[https://mariadb.com/docs/storage-engines/ MariaDB Enterprise Server Storage Engines]
 +
 +
{| class="wikitable"
 +
|-
 +
! Engine
 +
! Target
 +
! Optimization
 +
! Availability
 +
|-
 +
| [https://mariadb.com/kb/en/aria/ Aria]
 +
| Read-Heavy
 +
| Reads
 +
| ES10.2+
 +
|-
 +
| [https://mariadb.com/kb/en/mariadb-columnstore/ ColumnStore]
 +
| Analytics, HTAP
 +
| Big Data, Analytical
 +
| ES10.4+
 +
|-
 +
| [https://mariadb.com/kb/en/innodb/ InnoDB]
 +
| General Purpose
 +
| Mixed Read/Write
 +
| ES10.2+
 +
|-
 +
| [https://mariadb.com/kb/en/myisam/ MyISAM]
 +
| Reads
 +
| Reads
 +
| ES10.2+
 +
|-
 +
| [https://mariadb.com/kb/en/myrocks/ MyRocks]
 +
| Write-Heavy
 +
| I/O Reduction, SSD
 +
| ES10.3+
 +
|-
 +
| [https://mariadb.com/kb/en/s3-storage-engine/ S3]
 +
| Cloud
 +
| Read-Only
 +
| ES10.3+
 +
|-
 +
| [https://mariadb.com/docs/storage-engines/spider Spider]
 +
| Federation
 +
| Sharding, Interlink
 +
| ES10.3+
 +
|-
 +
| [https://mariadb.com/docs/storage-engines/xpand Xpand]
 +
| Distributed SQL
 +
| Scale-Out, Fault Tolerance
 +
| ES10.5+
 +
|}
 +
 +
===GIS===
 +
[https://mariadb.com/kb/en/geographic-geometric-features/ Geographic & Geometric Features]
 +
*[https://programm.froscon.de/2016/system/event_attachments/attachments/000/000/388/original/MariaDB_MySQL_GIS_Features.pdf GIS features in MariaDB and MySQL]
 +
*[https://develdocs.phpmyadmin.net/phpmyadmin/PhpMyAdmin/Gis.html PhpMyAdmin Gis]
 +
 +
===安全加密===
 +
*[https://mariadb.com/kb/en/data-in-transit-encryption/ Data-in-Transit Encryption]
 +
*[https://mariadb.com/docs/security/encryption/at-rest Data-at-Rest Encryption] HashiCorp [[Vault]] Encryption Plugin
 +
*[https://mariadb.com/docs/security/ MariaDB Platform Security Guide]
 +
 +
===后端存储===
 +
*[https://github.com/letsencrypt/openzfs-nvme-databases ZFS datastore for MariaDB]
  
 
==书籍==
 
==书籍==
第207行: 第351行:
 
image:MariaDB-Galera-Cluster-Replication.png|Galera复制
 
image:MariaDB-Galera-Cluster-Replication.png|Galera复制
 
image:MariaDB-ColumnStore-Storage-Architecture.jpeg|列式存储架构
 
image:MariaDB-ColumnStore-Storage-Architecture.jpeg|列式存储架构
 +
image:mariadb-plugin.png|Plugins
 +
image:mariadb-authors.png|开发者
 +
image:State-Snapshot-Transfers-SST-Methods.png|状态快照传输方法
 
</gallery>
 
</gallery>
  
第213行: 第360行:
 
*[https://mariadb.com/ MariaDB商业]
 
*[https://mariadb.com/ MariaDB商业]
 
*[https://downloads.mariadb.org/ Downloads Source, Binaries, and Packages]
 
*[https://downloads.mariadb.org/ Downloads Source, Binaries, and Packages]
*[https://github.com/MariaDB/server MariaDB @ GitHub]
 
*[https://github.com/mariadb-corporation/ MariaDB Corporation @ GitHub]
 
 
*[https://launchpad.net/maria MariaDB Launchpad]
 
*[https://launchpad.net/maria MariaDB Launchpad]
 
*[https://mariadb.com/resources/blog/ Official MariaDB Blog]
 
*[https://mariadb.com/resources/blog/ Official MariaDB Blog]

2022年8月6日 (六) 14:35的最后版本

Wikipedia-35x35.png 您可以在Wikipedia上了解到此条目的英文信息 MariaDB Thanks, Wikipedia.
Mariadb-foundation.png

MariaDB

LAMP stack

目录

[编辑] 简介

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版本上.

Mariadb-mysql.jpg

[编辑] 新闻

自https://mariadb.org/planet-rss加载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)。

Mariadb-general-release-maintenance-periods.png

[编辑] 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)

升级

brew update
brew upgrade mariadb

[编辑] Debian

How to Install MariaDB 10.7 on Debian 11 Bullseye

$ 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

Creating a Custom Docker 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

[编辑] Graph

OQGRAPH graph database

[编辑] CONNECT

CONNECT storage engine

sudo apt-get install mariadb-plugin-connect
or sudo yum install MariaDB-connect-engine
MariaDB [mysql]> show plugins;

[编辑] Archive

ARCHIVE storage engine

MariaDB [mysql]> INSTALL PLUGIN Archive SONAME 'ha_archive.so';

[编辑] FederatedX

FederatedX Storage Engine

MariaDB [mysql]> INSTALL SONAME 'ha_federatedx';

[编辑] MyRocks

MyRocks 是一个 MariaDB 存储引擎,它将 RocksDB 数据库添加到 MariaDB 中。RocksDB 是一个LSM数据库,具有很好的压缩比,针对闪存进行了优化。

sudo apt-get install mariadb-plugin-rocksdb
or sudo yum install MariaDB-rocksdb-engine
MariaDB [mysql]> INSTALL SONAME 'ha_rocksdb';
SHOW PLUGINS;
SHOW VARIABLES LIKE 'rocksdb_supported_compression_types';

[编辑] Spider

Spider storage engine

Comparing Spider to Features in Other Databases

Database Feature
Oracle Database Links
Microsoft SQL Server Linked Servers
SAP/Sybase Remote Servers and Proxy Tables
PostgreSQL Foreign Data Wrappers
MySQL FEDERATED Storage Engine

[编辑] Cassandra

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

[编辑] ColumnStore

[编辑] Amazon

[编辑] .NET

[编辑] MaxScale

[编辑] Xpand

[编辑] 连接器

[编辑] 管理

Graphical and Enhanced Clients

[编辑] 解决方案

MariaDB-Galera-Cluster.png

High Availability & Performance Tuning replication, clustering, multi-master and performance tuning solutions. OLTP(InnoDB),OLAP(ColumnStore),HTAP(MaxScale)解决方案:

Galera-4-Versions.png

[编辑] SkySQL

MariaDB Enterprise Server Storage Engines

Engine Target Optimization Availability
Aria Read-Heavy Reads ES10.2+
ColumnStore Analytics, HTAP Big Data, Analytical ES10.4+
InnoDB General Purpose Mixed Read/Write ES10.2+
MyISAM Reads Reads ES10.2+
MyRocks Write-Heavy I/O Reduction, SSD ES10.3+
S3 Cloud Read-Only ES10.3+
Spider Federation Sharding, Interlink ES10.3+
Xpand Distributed SQL Scale-Out, Fault Tolerance ES10.5+

[编辑] GIS

Geographic & Geometric Features

[编辑] 安全加密

[编辑] 后端存储

[编辑] 书籍

[编辑] 用户

[编辑] 图集

[编辑] 链接

分享您的观点
个人工具
名字空间

变换
操作
导航
工具箱