The MySQL database is supported by xCAT since xCAT 2.1. MariaDB is a fork of the MySQL project which was released around 2009 and is a drop-in replacement for MySQL. MariaDB support within xCAT started in version 2.8.5 and is currently fully supported moving forward.
Database | MySQL | MariaDB |
---|---|---|
xCAT 2.1+ | Yes | No |
xCAT 2.8.5 | Yes | RHEL 7 |
xCAT 2.9 | Yes | SLES 12 |
xCAT 2.10+ | Yes | Yes |
MySQL/MariaDB packages are shipped as part of most Linux Distributions.
MySQL - Using
yum
, ensure that the following packages are installed on the management node: :perl-DBD-MySQL* mysql-server-5.* mysql-5.* mysql-connector-odbc-*
MariaDB - Using
yum
, ensure that the following packages are installed on the management node: :mariadb-server-5.* mariadb-5.* perl-DBD-MySQL* mysql-connector-odbc-*
MySQL - Using
zypper
, ensure that the following packages are installed on the management node: :mysql-client-5* libmysqlclient_r15* libqt4-sql-mysql-4* libmysqlclient15-5* perl-DBD-mysql-4* mysql-5*
MariaDB - Using
zypper
, ensure that the following packages are installed on the management node: :mariadb-client-10.* mariadb-10.* mariadb-errormessages-10.* libqt4-sql-mysql-* libmysqlclient18-* perl-DBD-mysql-*
MySQL - Using
apt-get
, ensure that the following packages are installed on the management node: :mysql-server mysql-common libdbd-mysql-perl libmysqlclient18 mysql-client-5* mysql-client-core-5* mysql-server-5* mysql-server-core-5*
MariaDB - Using
apt-get
, ensure that the following packages are installed on the management node.apt-get install mariadb-server
will pull in all required packages. For Ubuntu 16.04, it no longer requiredlibmariadbclient18
. :libmariadbclient18 mariadb-client mariadb-common mariadb-server