yum install mysql-server
service mysqld start
1
2
2.配置CM Server数据库
用于存放CM的配置与监控数据。
mysqladmin -u root password 'xxxx'
mysql -uroot -p 进入mysql命令行,创建以下数据库:
create database amon DEFAULT CHARACTER SET utf8;
grant all on amon.* TO 'amon'@'%' IDENTIFIED BY 'xxxx';
create database smon DEFAULT CHARACTER SET utf8;
grant all on smon.* TO 'smon'@'%' IDENTIFIED BY 'xxxx';
create database rman DEFAULT CHARACTER SET utf8;
grant all on rman.* TO 'rman'@'%' IDENTIFIED BY 'xxxx';
create database hmon DEFAULT CHARACTER SET utf8;
grant all on hmon.* TO 'hmon'@'%' IDENTIFIED BY 'xxxx';
create database nav DEFAULT CHARACTER SET utf8;
grant all on nav.* TO 'nav'@'%' IDENTIFIED BY 'xxxx';
flush privileges;
1
2
3
4
5
6
7
8
9
10
11
12
13
3.配置Hive Metastore数据库
用于存放Hive的元数据信息。
create database metastore DEFAULT CHARACTER SET utf8;
grant all on metastore.* TO 'hive'@'%' IDENTIFIED BY 'xxxx';
flush privileges;
1
2
3
注意,安装Hive的时候可能会报错,由于使用了MySql作为Hive的元数据存储,因此需要安装MySql的驱动:
create database hue DEFAULT CHARACTER SET utf8;
grant all on hue.* TO 'hue'@'%' IDENTIFIED BY 'xxxx';
create database oozie DEFAULT CHARACTER SET utf8;
grant all on oozie.* TO 'oozie'@'%' IDENTIFIED BY 'xxxx';
flush privileges;
1
2
3
4
5
四、CM Server/Agent及CDH相关套件安装
“集群设置”的“自定义角色配置”页面,选择需要在服务器上分配对应的角色实例。生产环境中,最好能够做到数据节点(datanode/nodemanager等)与管理节点(namenode/resourcemanager/hivemetastore/zookeeper等)的分离,由于数据节点经常会运行繁重的任务,可能会影响管理节点的稳定高效运行。
“集群设置”的“数据库设置”页面,将之前在MySql建的对应库名、用户名、密码填入之后,点击连接测试,没有问题则可进入下一步。
一路点击下一步即会对集群进行初始化,如无意外,可顺利启动集群。
测试集群运行任务是否正常:hadoop jar /opt/cloudera/parcels/CDH/lib/hadoop-mapreduce/hadoop-mapreduce-examples.jar pi 10 100
(7)集群启动后的优化