欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜:Formal mathematics/Isabelle/ML, Formal verification/Coq/ACL2, C++/F#/Lisp
MariaDB
小 (→新闻) |
小 (→存储引擎) |
||
(未显示1个用户的94个中间版本) | |||
第1行: | 第1行: | ||
{{SeeWikipedia}} | {{SeeWikipedia}} | ||
− | [[Image:Mariadb- | + | [[Image:Mariadb-foundation.png|right]] |
− | + | 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 迁移 | + | *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> | + | <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. | + | ===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 install mariadb // 通过 [[Homebrew]] 安装, brew services start mariadb 和 brew services stop mariadb |
unset TMPDIR | unset TMPDIR | ||
cd /usr/local/Cellar/mariadb/10.0.14_1/ | cd /usr/local/Cellar/mariadb/10.0.14_1/ | ||
第72行: | 第112行: | ||
brew upgrade mariadb | brew upgrade mariadb | ||
− | == | + | ===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 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 | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
选择其它仓库:[https://downloads.mariadb.org/mariadb/repositories Setting up MariaDB Repositories] | 选择其它仓库:[https://downloads.mariadb.org/mariadb/repositories Setting up MariaDB Repositories] | ||
− | ==编译== | + | ===CentOS=== |
+ | [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 也安装上开发工具包 | ||
+ | |||
+ | $ 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] | ||
+ | |||
+ | ===编译=== | ||
cd $maria-source-dir | cd $maria-source-dir | ||
BUILD/autorun.sh | BUILD/autorun.sh | ||
第95行: | 第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] | ||
==书籍== | ==书籍== | ||
*[http://www.amazon.cn/gp/product/B00V4B2L0Q 《MariaDB原理与实现》] | *[http://www.amazon.cn/gp/product/B00V4B2L0Q 《MariaDB原理与实现》] | ||
+ | |||
+ | ==用户== | ||
+ | *[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] | ||
+ | |||
+ | ==图集== | ||
+ | <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-AX-for-OLAP.png|MariaDB AX for OLAP | ||
+ | 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> | ||
==链接== | ==链接== | ||
*[https://mariadb.org/ MariaDB官网] | *[https://mariadb.org/ MariaDB官网] | ||
*[https://mariadb.com/ MariaDB商业] | *[https://mariadb.com/ MariaDB商业] | ||
+ | *[https://downloads.mariadb.org/ Downloads Source, Binaries, and Packages] | ||
*[https://launchpad.net/maria MariaDB Launchpad] | *[https://launchpad.net/maria MariaDB Launchpad] | ||
− | *[ | + | *[https://mariadb.com/resources/blog/ Official MariaDB Blog] |
− | + | *[https://mariadb.com/kb/ MariaDB KnowledgeBase] | |
− | + | ||
− | *[ | + | |
*[https://mariadb.atlassian.net MariaDB JIRA] | *[https://mariadb.atlassian.net MariaDB JIRA] | ||
*[http://montyprogram.com/ Monty Program] | *[http://montyprogram.com/ Monty Program] | ||
*[http://www.skysql.com/ SkySQL] | *[http://www.skysql.com/ SkySQL] | ||
− | |||
− | |||
[[category:MySQL]] | [[category:MySQL]] | ||
+ | [[category:MariaDB]] | ||
[[category:database]] | [[category:database]] | ||
+ | [[category:c++]] | ||
+ | [[category:Huihoo Foundation]] |
2022年8月6日 (六) 14:35的最后版本
您可以在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
自https://mariadb.org/planet-rss加载RSS失败或RSS源被墙
[编辑] 版本
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)
升级
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'
[编辑] 项目
[编辑] 存储引擎
[编辑] Graph
[编辑] CONNECT
sudo apt-get install mariadb-plugin-connect or sudo yum install MariaDB-connect-engine MariaDB [mysql]> show plugins;
[编辑] Archive
MariaDB [mysql]> INSTALL PLUGIN Archive SONAME 'ha_archive.so';
[编辑] FederatedX
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
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
- MariaDB Cassandra Storage Engine
- MariaDB的Cassandra存储引擎,允许MariaDB通过标准SQL语法使用Cassandra集群。
[编辑] ColumnStore
- ColumnStore @ GitHub
- MariaDB ColumnStore
- 此列式存储是基于 InfiniDB 4.6.7 并移植到 MariaDB 的
[编辑] Amazon
[编辑] .NET
- Connector/Net is a fully-managed ADO.NET driver for MySQL.
- MariaDB Connector/NET
[编辑] MaxScale
[编辑] Xpand
[编辑] 连接器
[编辑] 管理
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
- Galera Cluster MariaDB Galera Cluster
- How to setup HAProxy as Load Balancer for MariaDB on CentOS 7
[编辑] SkySQL
- MariaDB Replication
- Galera Cluster Galera @ GitHub
- Uses for MariaDB and the Spider Storage Engine
- How MariaDB Achieves Global Scale with Xpand
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
[编辑] 安全加密
- Data-in-Transit Encryption
- Data-at-Rest Encryption HashiCorp Vault Encryption Plugin
- MariaDB Platform Security Guide
[编辑] 后端存储
[编辑] 书籍
[编辑] 用户
- Tencent’s DB Kernel Team 微信 PhxSQL 基于 Percona 构建
- China Mobile & Intel Deploy Galera for 1000-Node OpenStack Cloud 39% of OpenStack users run Galera Cluster in production for OpenStack components according to recent survey