欢迎大家赞助一杯啤酒🍺 我们准备了下酒菜:Formal mathematics/Isabelle/ML, Formal verification/Coq/Agda, C++/Erlang/Lisp
MariaDB
来自开放百科 - 灰狐
(版本间的差异)
小 (→.NET) |
小 (→链接) |
||
(未显示1个用户的22个中间版本) | |||
第71行: | 第71行: | ||
brew update | brew update | ||
brew upgrade mariadb | brew upgrade mariadb | ||
+ | |||
+ | ==解决方案== | ||
+ | [[文件:MariaDB-Galera-Cluster.png|right]] | ||
+ | *[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/kb/en/mariadb/what-is-mariadb-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] | ||
==Cassandra== | ==Cassandra== | ||
− | [http://www.infoq.com/cn/news/2012/11/Cassandra-SE MariaDB的Cassandra存储引擎],允许MariaDB通过标准SQL语法使用[[Apache Cassandra|Cassandra]]集群。 | + | *[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]]集群。 | ||
+ | |||
+ | ==Amazon== | ||
+ | *[https://aws.amazon.com/cn/rds/mariadb/ Amazon RDS for MariaDB] | ||
+ | |||
+ | ==管理== | ||
+ | *[[Sequel Pro]] | ||
+ | *[[HeidiSQL]] | ||
+ | *[[DBeaver]] | ||
==[[.NET]]== | ==[[.NET]]== | ||
第105行: | 第122行: | ||
==书籍== | ==书籍== | ||
*[http://www.amazon.cn/gp/product/B00V4B2L0Q 《MariaDB原理与实现》] | *[http://www.amazon.cn/gp/product/B00V4B2L0Q 《MariaDB原理与实现》] | ||
+ | |||
+ | ==用户== | ||
+ | *[http://tdsql.org/ TDSQL]腾讯金融级分布式数据库 | ||
+ | *[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-foss-success.png|MariaDB Foundation | ||
+ | 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存储引擎 | ||
+ | </gallery> | ||
==链接== | ==链接== | ||
第111行: | 第141行: | ||
*[https://github.com/MariaDB/server https://github.com/MariaDB MariaDB @ GitHub] | *[https://github.com/MariaDB/server https://github.com/MariaDB MariaDB @ GitHub] | ||
*[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] | ||
第123行: | 第151行: | ||
[[category:database]] | [[category:database]] | ||
[[category:c++]] | [[category:c++]] | ||
+ | [[category:huihoo]] |
2020年8月6日 (四) 15:51的版本
您可以在Wikipedia上了解到此条目的英文信息 MariaDB Thanks, Wikipedia. |
Mariadb, a MySQL branch with the Maria storage engine
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源被墙
10.1
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
解决方案
- 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
Cassandra
- MariaDB Cassandra Storage Engine
- MariaDB的Cassandra存储引擎,允许MariaDB通过标准SQL语法使用Cassandra集群。
Amazon
管理
.NET
- Connector/Net is a fully-managed ADO.NET driver for MySQL.
- MariaDB Connector/NET
MaxScale
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
选择其它仓库:Setting up MariaDB Repositories
编译
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'
书籍
用户
- TDSQL腾讯金融级分布式数据库
- 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
图集
链接
分享您的观点