Downloading and installing MariaDB database
Download and install MariaDB database on a host in your CDP cluster depending on your CDP and OS version.
-
Download the MariaDB distribution from https://mariadb.org/download/ based
on your OS version.
Use the Cloudera Support Matrix for finding the compatibile versions.
-
Install the database using the following commands depending on your operating
system:
On RHEL/CentOS:
sudo yum install mariadb-server
On SLES:sudo zypper install mariadb
On Ubuntu:sudo apt-get install mariadb-server #set root psswd when prompted
On Debian:sudo apt-get install mariadb-server #set root psswd when prompted
-
Start the database server using the following commands depending on your
operating system:
On RHEL/CentOS:
sudo systemctl start mariadb
On SLES:sudo systemctl start mariadb
On Ubuntu, MariaDB starts automatically after installation. Run the following command to check the status:sudo systemctl status mariadb
On Debian, MariaDB starts automatically after installation. Run the following command to check the status:sudo systemctl status mariadb
-
Secure your installation by running the following command:
sudo /usr/bin/mysql_secure_installation
mysql_secure_installation
is a shell script available on Unix systems, and enables you to improve the security of your MariaDB installation in the following ways:Enter current password for root (enter for none): [If unset, press Enter.] OK, successfully used password, moving on... [...] Set root password? [Y/n] Y [Enter n if password is set.] New password: Re-enter new password: Remove anonymous users? [Y/n] Y [...] Disallow root login remotely? [Y/n] N [...] Remove test database and access to it [Y/n] Y [...] Reload privilege tables now? [Y/n] Y