MariaDB

来自开放百科 - 灰狐
(版本间的差异)
跳转到: 导航, 搜索
(版本)
(图集)
第178行: 第178行:
 
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-cassandra-storage-engine.png|Cassandra存储引擎
 +
image:mariadb-compatibility-mysql.png|MySQL兼容性
 
</gallery>
 
</gallery>
  

2021年1月23日 (六) 05:11的版本

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

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

Mariadb-mysql.jpg

新闻

自http://blog.mariadb.org/feed/加载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

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

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 密码等

编译

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

解决方案

MariaDB-Galera-Cluster.png

Cassandra

Amazon

管理

.NET

MaxScale

书籍

用户

图集

链接

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

变换
操作
导航
工具箱