mariaDB安裝較為簡便,適合作為ambari及相關(guān)組件元數(shù)據(jù)數(shù)據(jù)庫使用,安裝步驟如下:
一、安裝MariaDB:
1.yum源安裝
yum install mariadb-server mariadb


2.啟動mariaDB及簡單測試一下
systemctl start mariadb
systemctl status mariadb

這時候你直接執(zhí)行mysql命令,就直接進(jìn)入數(shù)據(jù)庫了

二、配置mariaDB配置
1.停止mariaDB進(jìn)程
systemctl stop mariadb
2.編輯/etc/my.cnf 在[mysqld]段下,添加如下幾行行配置:
transaction-isolation = READ-COMMITTED
max_connections = 550
innodb_flush_method = O_DIRECT
port=7881
建議不使用mysql默認(rèn)端口3306防止被攻擊,我這里使用的7881
3.重啟mariaDB進(jìn)程
systemctl restart mariadb
4.運(yùn)行mariadb安全配置腳本/usr/bin/mysql_secure_installation
/usr/bin/mysql_secure_installation







5.設(shè)置遠(yuǎn)程訪問
mysql -uroot -p

use mysql;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '****' WITH GRANT OPTION;
flush privileges;

大功告成!