# 给安装包添加执行权限
# chmod +x cloudera-manager-installer.bin

# 执行安装
# ./cloudera-manager-installer.bin

# 安装过程交互
1. 接受许可协议
2. 选择安装类型（默认完整安装）
3. 输入Cloudera Manager管理员密码
4. 等待安装完成

# 配置MySQL
# mysql_secure_installation

# 创建CDH所需数据库
# mysql -u root -p

CREATE DATABASE scm DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE amon DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE rman DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE hue DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE metastore DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE sentry DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE nav DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE navms DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

GRANT ALL ON scm.* TO ‘scm’@’%’ IDENTIFIED BY ‘scm_password’;
GRANT ALL ON amon.* TO ‘amon’@’%’ IDENTIFIED BY ‘amon_password’;
GRANT ALL ON rman.* TO ‘rman’@’%’ IDENTIFIED BY ‘rman_password’;
GRANT ALL ON hue.* TO ‘hue’@’%’ IDENTIFIED BY ‘hue_password’;
GRANT ALL ON metastore.* TO ‘hive’@’%’ IDENTIFIED BY ‘hive_password’;
GRANT ALL ON sentry.* TO ‘sentry’@’%’ IDENTIFIED BY ‘sentry_password’;
GRANT ALL ON nav.* TO ‘nav’@’%’ IDENTIFIED BY ‘nav_password’;
GRANT ALL ON navms.* TO ‘navms’@’%’ IDENTIFIED BY ‘navms_password’;

FLUSH PRIVILEGES;
EXIT;

# 初始化SCM数据库
# /opt/cloudera/cm/schema/scm_prepare_database.sh mysql scm scm scm_password

# 检查服务状态
# systemctl status cloudera-scm-server

# 访问Cloudera Manager控制台
# 打开浏览器，访问 http://localhost:7180
# 用户名: admin
# 密码: 安装时设置的密码

# 按照向导配置CDH集群
1. 选择要管理的主机
2. 选择安装的服务
3. 配置服务参数
4. 启动服务

# 备份HDFS数据
# su – hdfs -c “hdfs dfs -mkdir -p /user/backup”
# su – hdfs -c “hdfs dfs -put /etc/hadoop/conf /user/backup/hadoop-conf”

# 配置自动备份
# 创建备份脚本
# vi /root/backup_cdh.sh

#!/bin/bash

DATE=$(date +%Y%m%d)
BACKUP_DIR=”/backup/cdh/$DATE”

# 创建备份目录
mkdir -p $BACKUP_DIR

# 备份Cloudera Manager配置
cp -r /etc/cloudera-scm-server $BACKUP_DIR/
cp -r /var/lib/cloudera-scm-server $BACKUP_DIR/

# 备份HDFS配置
su – hdfs -c “hdfs dfs -mkdir -p /user/backup/$DATE”
su – hdfs -c “hdfs dfs -put /etc/hadoop/conf /user/backup/$DATE/hadoop-conf”

# 给脚本添加执行权限
# chmod +x /root/backup_cdh.sh

# 添加到crontab
# crontab -e

# 添加以下内容（每天凌晨2点执行备份）
0 2 * * * /root/backup_cdh.sh

# 2. 停止Cloudera Manager服务
# systemctl stop cloudera-scm-server

# 3. 下载新版本安装包
# wget https://archive.cloudera.com/cm6/6.3.2/cloudera-manager-installer.bin

# 4. 执行升级
# chmod +x cloudera-manager-installer.bin
# ./cloudera-manager-installer.bin

# 5. 启动Cloudera Manager服务
# systemctl start cloudera-scm-server

# 6. 通过Cloudera Manager升级集群
# 打开浏览器，访问 http://localhost:7180
# 按照向导升级集群

# 1. 备份旧集群数据
# su – hdfs -c “hdfs dfs -copyToLocal /user/hive/warehouse /backup/hive-warehouse”

# 2. 将备份数据复制到新集群
# scp -r /backup/hive-warehouse root@new-cluster:/backup/

# 3. 在新集群上恢复数据
# su – hdfs -c “hdfs dfs -copyFromLocal /backup/hive-warehouse /user/hive/warehouse”

# 4. 验证迁移结果
# su – hive -c “hive -e ‘SHOW TABLES;'”