Install MySQL/MariaDB
=====================

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.


Red Hat Enterprise Linux
------------------------

* For RHEL 6 and prior, MySQL is shipped. Using ``yum``, ensure that the following packages are installed on the management node: ::

       perl-DBD-MySQL*
       mysql-server-5.*
       mysql-5.*
       mysql-connector-odbc-*

* For RHEL 7, MariaDB is shipped. Using ``yum``, ensure that the following packages are installed on the management node: ::

       mariadb-server-5.*
       mariadb-5.*
       perl-DBD-MySQL*
       mysql-connector-odbc-*

* For RHEL 8, MariaDB is shipped. Using ``dnf``, ensure that the following packages are installed on the management node: ::

       mariadb-server-5.*
       mariadb-5.*
       perl-DBD-MySQL*
       mariadb-connector-odbc-*

Suse Linux Enterprise Server
----------------------------

* 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-*

* For SLE15, MariaDB is shipped. Using ``zypper``, ensure that the following packages are installed on the management node: ::

       mariadb
       mariadb-client
       mariadb-errormessages
       perl-DBD-mysql
       libmariadb-devel
       mariadb-tools
       libmariadb_plugins


Debian/Ubuntu
-------------

* MySQL - Using ``apt-get``, ensure that the following packages are installed on the management node: ::

        mysql-server
        mysql-common
        libdbd-mysql-perl
        libmysqlclient*
        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 required ``libmariadbclient18``. ::

        libmariadbclient18
        mariadb-client
        mariadb-common
        mariadb-server
