標籤:bsp oca load nload 指令碼 伺服器 sys har hive
一、安裝並使用MariaDB作為Ambari、Hive、Hue的儲存資料庫。
yum install mariadb-server mariadb
啟動、查看狀態,檢查mariadb是否成功安裝
systemctl start mariadbsystemctl status mariadb
二、配置mariadb
1,首先停止MariaDb 服務的運行
systemctl stop mariadb
2,編輯/etc/my.cnf 在[mysqld]段下,添加如下幾行行配置:
transaction-isolation = READ-COMMITTEDmax_connections = 550innodb_flush_method = O_DIRECT
儲存退出後,配置mariadb服務開機啟動,並重新啟動MariaDB
systemctl enable mariadbsystemctl start mariadb
3,運行mariadb安全配置指令碼/usr/bin/mysql_secure_installation ,[email protected],密碼這裡設為hadoop
/usr/bin/mysql_secure_installation
****授權使用者root使用密碼passwd從任意主機串連*到mysql伺服器
mysql -uroot -puse mysql;GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘****‘ WITH GRANT OPTION;flush privileges;
**** 安裝MySQL JDBC Driver 串連 MariaDB
**** 下載、解壓縮,複製mysql-connector-java-5.1.46-bin.jar到/usr/share/java/,並重新命名:
wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.46.tar.gztar zxvf mysql-connector-java-5.1.46.tar.gzcd mysql-connector-java-5.1.46/cp mysql-connector-java-5.1.46-bin.jar /usr/share/java/mysql-connector-java.jar
基於【CentOS-7+ Ambari 2.7.0 + HDP 3.0】搭建HAWQ資料倉儲之一 —— MariaDB 安裝配置