Monty Program has a MariaDB vs MySQL whitepaper available for download.
See also MariaDB vs MySQL - Features
鉴于所有应用,MariaDB都是MySQL的代码级量身定制的替代者,相应的版本可以直接替换(如MySQL 5.1 ->MariaDB 5.1,MariaDB 5.2 &MariaDB 5.3也是兼容的。MySQL 5.5将与兼容),具体是:
mysql-client
程序也可在MariaDB服务器上工作。 意思也就是,在大多数情况下,你只要卸载MySQL后,安装MariaDB后就可工作(在使用相同的主版本(如5.1版)的情况下,不需任何数据文件的转换).
我们每月都会将MySQL基本代码编译入MariaDB,从而保证MariaDB与Oracle添加的任何补丁和更新的MySQL相兼容。
同时我们为了容易地从 从MySQL 5.0升级到MariaDB 5.1 ,我们在升级脚本上也做了大量的工作。
也就是说:相对于MySQL,MariaDB有更多 新选项、扩展、存储引擎及漏洞修复 ,你可以在MariaDB的不同之外页上查看详细。
为了提供更多、更好的性能,MariaDB在有些地方与MySQL难免有所不兼容。
下面列出的是从用户使用角度,你可能看到的MariaDB 5.1与 MySQL 5.1不同之外。
[mariadb]
sections of your my.cnf files. CHECKSUM TABLE
may give different result as MariaDB doesn't ignore NULL's in the columns as MySQL 5.1 does (Future MySQL versions should calculate checksums the same way as MariaDB). You can get the 'old style' checksum in MariaDB by starting mysqld with the --old
option. Note however that that the MyISAM and Aria storage engines in MariaDB are using the new checksum internally, so if you are using --old
, the CHECKSUM
command will be slower as it needs to calculate the checksum row by row. aria_pagecache_buffer_size
to 1M
(the default is 128M
). The list is the same as betweenMariaDB 5.1 and MySQL 5.1, with one addition:
SQL_MODE
value was added: IGNORE_BAD_TABLE_OPTIONS
. If it is not set, using a table, field, or index attribute (option) that is not supported by the chosen storage engine will cause an error. This change might cause warnings in the error log about incorrectly defined tables from the mysql
database, fix that with mysql_upgrade
. For all practical purposes,MariaDB 5.2 is a drop in replacement forMariaDB 5.1 and MySQL 5.1.
--maria-
startup options are removed. You should use the --aria-
prefix instead. (MariaDB 5.2 supports both --maria-
and --aria-
) SHOW PROCESSLIST
has an extra Progress
column which shows progress for some commands. You can disable it by starting mysqld
with the --old
flag. INFORMATION_SCHEMA.PROCESSLIST
has three new columns for progress reporting: STAGE
, MAX_STAGE
, and PROGRESS
. /*M!
or /*M!#####
are executed. max_user_connections=0
(which means any number of connections) when starting mysqld, you can't change the global variable anymore while mysqld remains running. This is because when mysqld is started with max_user_connections=0
it does not allocate counting structures (which also involve a mutex for each connection). This would lead to wrong counters if you later changed the variable. If you want to be able to change this variable at runtime, set it to a high value at startup. max_user_connections
(both the global variable and the GRANT
option) to -1
to stop users from connecting to the server. The global max_user_connections
variable does not affect users with the SUPER
privilege. Percona, the provider of XtraDB, does not provided all earlier features of XtraDB in the 5.5 code base. Because of that,MariaDB 5.5 can't provide them either.
The following options are not supported by XtraDB 5.5. If you are using them in any of your my.cnf files, you should remove them before upgrading to 5.5.
innodb_adaptive_flushing_method
instead. innodb_buffer_pool_restore_at_startup
instead. innodb_blocking_buffer_pool_restore
instead. innodb_import_table_from_xtrabackup
instead. innodb_rollback_segment
instead. innodb_corrupt_table_action
instead. Option | Old value | New value |
---|---|---|
innodb_adaptive_checkpoint | TRUE | FALSE |
innodb_change_buffering | inserts | all |
innodb_flush_neighbor_pages | 1 | area |
The following new options has been added to XtraDB / InnoDB in 5.5. (Listed here just to have all XtraDB information in the same place)
See also Perconas guide of how to upgrade to 5.5
If you are using any of the following options in your /etc/my.cnf
or other my.cnf
file you should remove them. This is also true for MySQL 5.1 or newer:
skip-bdb
If you uninstalled a MySQL RPM to install MariaDB, note that the MySQL RPM on uninstall renames /etc/my.cnf
to /etc/my.cnf.rpmsave
.
After installing MariaDB you should do the following to restore your old configuration options:
mv -vi /etc/my.cnf.rpmsave /etc/my.cnf
Comments loading...