MariaDB

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
(图集)
(存储引擎)
 
(未显示1个用户的71个中间版本)
第1行: 第1行:
 
{{SeeWikipedia}}
 
{{SeeWikipedia}}
[[Image:Mariadb-90x90.gif|right]]
+
[[Image:Mariadb-foundation.png|right]]
  
Mariadb, a [[MySQL]] branch with the Maria storage engine
+
MariaDB
  
 +
[[文件:LAMP-stack.png|right|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 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 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>
 +
 
 +
==版本==
 +
[https://mariadb.com/kb/en/mariadb-releases/ MariaDB Releases]
 +
 
 +
{| class="wikitable"
 +
|-
 +
! 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
 +
|}
 +
 
 +
[https://mariadb.org/about MariaDB 每年会发布一个 GA 稳定版] MariaDB 基金会也保证每个版本都会至少维护5年,可以理解为 Long Term Support (LTS)。
 +
 
 +
[[文件:mariadb-general-release-maintenance-periods.png]]
  
==10.1==
+
===10.x===
 +
MariaDB 10.x 分支:
 +
*[https://github.com/MariaDB/server/tree/10.6 10.6]
 +
*[https://github.com/MariaDB/server/tree/10.5 10.5]
 +
*[https://github.com/MariaDB/server/tree/10.4 10.4]
 +
*[https://github.com/MariaDB/server/tree/10.3 10.3]
 +
*[https://github.com/MariaDB/server/tree/10.2 10.2]
 +
*[https://github.com/MariaDB/server/tree/10.1 10.1]
 
*[https://blog.mariadb.org/10-1-mio-qps/ MariaDB 10.1 can do 1 million queries per second]
 
*[https://blog.mariadb.org/10-1-mio-qps/ MariaDB 10.1 can do 1 million queries per second]
  
==10.0==
+
===10.0===
  
==5.5==
+
===5.5===
 
MariaDB 5.5.30 包含 MariaDB 5.3.12 和 [[MySQL]] 5.5.30
 
MariaDB 5.5.30 包含 MariaDB 5.3.12 和 [[MySQL]] 5.5.30
  
==5.4==
+
===5.4===
  
==5.3==
+
===5.3===
 
MariaDB 5.3 将基于 MySQL 5.1 或 MySQL 5.6
 
MariaDB 5.3 将基于 MySQL 5.1 或 MySQL 5.6
  
==5.2==
+
===5.2===
 
MariaDB 5.2 基于 MySQL 5.1
 
MariaDB 5.2 基于 MySQL 5.1
  
第38行: 第77行:
 
* New storage engines: OQGRAPH and Sphinx.
 
* New storage engines: OQGRAPH and Sphinx.
 
* Speed optimizations  
 
* Speed optimizations  
==5.1==
+
===5.1===
 
MariaDB 5.1 基于 MySQL 5.1
 
MariaDB 5.1 基于 MySQL 5.1
  
第47行: 第86行:
 
* Table elimination: Optimizer enhancement.
 
* Table elimination: Optimizer enhancement.
 
* More information in the logs for better troubleshooting.
 
* More information in the logs for better troubleshooting.
* Speed optimizations  
+
* Speed optimizations
  
==OS X==
+
==指南==
 +
===OS X===
 
  brew info mariadb
 
  brew info mariadb
 
  brew install mariadb // 通过 [[Homebrew]] 安装, brew services start mariadb 和 brew services stop mariadb
 
  brew install mariadb // 通过 [[Homebrew]] 安装, brew services start mariadb 和 brew services stop mariadb
第72行: 第112行:
 
  brew upgrade mariadb
 
  brew upgrade mariadb
  
==解决方案==
+
===Debian===
[[文件:MariaDB-Galera-Cluster.png|right]]
+
[https://www.linuxcapable.com/how-to-install-mariadb-10-7-on-debian-11-bullseye/ How to Install MariaDB 10.7 on Debian 11 Bullseye]
*[https://mariadb.com/products/solutions/oltp-database-tx MariaDB TX] for [[OLTP]]
+
$ sudo apt update
*[https://mariadb.com/products/solutions/olap-database-ax MariaDB AX] for [[OLAP]]
+
$ sudo apt install mariadb-server
*[https://mariadb.com/kb/en/mariadb/what-is-mariadb-galera-cluster/ MariaDB Galera Cluster]
+
$ sudo mysql_secure_installation
*[http://galeracluster.com/ Galera Cluster]
+
$ 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
  
==Cassandra==
+
选择其它仓库:[https://downloads.mariadb.org/mariadb/repositories Setting up MariaDB Repositories]
[http://www.infoq.com/cn/news/2012/11/Cassandra-SE MariaDB的Cassandra存储引擎],允许MariaDB通过标准SQL语法使用[[Apache Cassandra|Cassandra]]集群。
+
  
==Amazon==
+
===CentOS===
*[https://aws.amazon.com/cn/rds/mariadb/ Amazon RDS for MariaDB]
+
[https://www.digitalocean.com/community/tutorials/how-to-install-mariadb-on-centos-8 How To Install MariaDB on CentOS 8]
  
==管理==
+
$ sudo yum install libmariadb-dev 也安装上开发工具包
*[[Sequel Pro]]
+
*[[HeidiSQL]]
+
*[[DBeaver]]
+
  
==[[.NET]]==
+
$ sudo mysql_secure_installation 设置 root 密码等
*[https://dev.mysql.com/downloads/connector/net/ Connector/Net] is a fully-managed ADO.NET driver for MySQL.
+
*[https://github.com/noahvans/mariadb-connector-net MariaDB Connector/NET]
+
  
==MaxScale==
+
===[[Container]]===
*[https://github.com/mariadb-corporation/MaxScale MaxScale @ GitHub]
+
[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]
  
==Debian==
+
===编译===
apt-get install python-software-properties
+
apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
+
add-apt-repository 'deb http://mirrors.hustunique.com/mariadb/repo/10.1/debian wheezy main'
+
apt-get update
+
apt-get install mariadb-server mariadb-client
+
mysql -V
+
选择其它仓库:[https://downloads.mariadb.org/mariadb/repositories Setting up MariaDB Repositories]
+
 
+
==编译==
+
 
  cd $maria-source-dir  
 
  cd $maria-source-dir  
 
  BUILD/autorun.sh
 
  BUILD/autorun.sh
第117行: 第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]
 +
 +
==存储引擎==
 +
[https://mariadb.com/kb/en/storage-engines/ MariaDB Storage Engines]
 +
*[[XtraDB]]
 +
*[[TokuDB]]
 +
*[[InnoDB]]
 +
*[[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 Storage Engine is no longer actively being developed and has been removed in MariaDB 10.6
 +
*[https://mariadb.com/kb/en/library/cassandra/ MariaDB Cassandra Storage Engine]
 +
*[http://www.infoq.com/cn/news/2012/11/Cassandra-SE MariaDB的Cassandra存储引擎],允许MariaDB通过标准SQL语法使用[[Apache Cassandra|Cassandra]]集群。
 +
 +
==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 的
 +
 +
==Amazon==
 +
*[https://aws.amazon.com/cn/rds/mariadb/ Amazon RDS for MariaDB]
 +
 +
==[[.NET]]==
 +
*[https://dev.mysql.com/downloads/connector/net/ Connector/Net] is a fully-managed ADO.NET driver for MySQL.
 +
*[https://github.com/noahvans/mariadb-connector-net MariaDB Connector/NET]
 +
 +
==MaxScale==
 +
*[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://github.com/webyog/sqlyog-community SQLyog Community Edition]
 +
*[[phpMyAdmin]]
 +
*[[Sequel Pro]]
 +
*[[HeidiSQL]]
 +
*[[DBeaver]]
 +
 +
==解决方案==
 +
[[文件: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. OLTP(InnoDB),OLAP(ColumnStore),HTAP(MaxScale)解决方案:
 +
*[https://mariadb.com/kb/en/mariadb-platform-x3/ MariaDB Platform X3]
 +
*[[Vitess]] MySQL Cluster
 +
*[https://mariadb.com/products/solutions/oltp-database-tx MariaDB TX] for [[OLTP]]
 +
*[https://mariadb.com/products/solutions/olap-database-ax MariaDB AX] for [[OLAP]]
 +
*[[Galera Cluster]] [https://mariadb.com/kb/en/galera-cluster/ MariaDB Galera Cluster]
 +
*[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]
  
 
==书籍==
 
==书籍==
第122行: 第334行:
  
 
==用户==
 
==用户==
*[http://tdsql.org/ TDSQL]腾讯金融级分布式数据库
+
*[https://mariadb.org/thanks-tencent/ Tencent’s DB Kernel Team] 微信 [https://github.com/Tencent/phxsql PhxSQL] 基于 [[Percona Server|Percona]] 构建
 
*[http://galeracluster.com/2017/06/china-mobile-intel-deploy-galera-for-1000-node-openstack-cloud/ China Mobile & Intel Deploy Galera for 1000-Node OpenStack Cloud] [http://galeracluster.com/2017/04/39-of-openstack-users-run-galera-cluster-in-production-for-openstack-components-according-to-recent-survey/ 39% of OpenStack users run Galera Cluster in production for OpenStack components according to recent survey]
 
*[http://galeracluster.com/2017/06/china-mobile-intel-deploy-galera-for-1000-node-openstack-cloud/ China Mobile & Intel Deploy Galera for 1000-Node OpenStack Cloud] [http://galeracluster.com/2017/04/39-of-openstack-users-run-galera-cluster-in-production-for-openstack-components-according-to-recent-survey/ 39% of OpenStack users run Galera Cluster in production for OpenStack components according to recent survey]
  
 
==图集==
 
==图集==
 
<gallery>
 
<gallery>
 +
image:MariaDB-Architecture.png|架构
 +
image:mariadb-foss-success.png|MariaDB Foundation
 +
image:mariadb-platform-x3-routing-streaming.png|MariaDB Platform X3
 +
image:mariadb-platform-x3-scaleout.png|MariaDB Platform X3
 +
image:mariadb-platform-x3-htap-routing.png|MariaDB Platform X3
 
image:MariaDB-TX-for-OLTP.png|MariaDB TX for OLTP
 
image:MariaDB-TX-for-OLTP.png|MariaDB TX for OLTP
 
image:MariaDB-AX-for-OLAP.png|MariaDB AX for OLAP
 
image:MariaDB-AX-for-OLAP.png|MariaDB AX for OLAP
 
image:MariaDB-Galera-Cluster-on-OpenStack-April-2017.png|OpenStack
 
image:MariaDB-Galera-Cluster-on-OpenStack-April-2017.png|OpenStack
 +
image:mariadb-cassandra-storage-engine.png|Cassandra存储引擎
 +
image:mariadb-compatibility-mysql.png|MySQL兼容性
 +
image:MariaDB-Galera-Cluster-Replication.png|Galera复制
 +
image:MariaDB-ColumnStore-Storage-Architecture.jpeg|列式存储架构
 +
image:mariadb-plugin.png|Plugins
 +
image:mariadb-authors.png|开发者
 +
image:State-Snapshot-Transfers-SST-Methods.png|状态快照传输方法
 
</gallery>
 
</gallery>
  
第135行: 第359行:
 
*[https://mariadb.org/ MariaDB官网]
 
*[https://mariadb.org/ MariaDB官网]
 
*[https://mariadb.com/ MariaDB商业]
 
*[https://mariadb.com/ MariaDB商业]
*[https://github.com/MariaDB/server https://github.com/MariaDB MariaDB @ GitHub]
+
*[https://downloads.mariadb.org/ Downloads Source, Binaries, and Packages]
 
*[https://launchpad.net/maria MariaDB Launchpad]
 
*[https://launchpad.net/maria MariaDB Launchpad]
*[http://kb.askmonty.org/ MariaDB KnowledgeBase]
+
*[https://mariadb.com/resources/blog/ Official MariaDB Blog]
*[http://askmonty.org/wiki MariaDB Wiki]
+
*[https://mariadb.com/kb/ MariaDB KnowledgeBase]
*[http://askmonty.org/blog/ MariaDB Blog]
+
*[http://askmonty.org/worklog/ MariaDB WorkLog]
+
 
*[https://mariadb.atlassian.net MariaDB JIRA]
 
*[https://mariadb.atlassian.net MariaDB JIRA]
 
*[http://montyprogram.com/ Monty Program]
 
*[http://montyprogram.com/ Monty Program]
第149行: 第371行:
 
[[category:database]]
 
[[category:database]]
 
[[category:c++]]
 
[[category:c++]]
[[category:huihoo]]
+
[[category:Huihoo Foundation]]

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

[编辑] 安全加密

[编辑] 后端存储

[编辑] 书籍

[编辑] 用户

[编辑] 图集

[编辑] 链接

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

变换
操作
导航
工具箱