万分重要----------------umask一定要设置为022,不然可能服务起不来!!!!!----------------
1、postgresql数据库导入以及导出
postgresql数据库安装以及配置过程略。
-------数据库配置文件为/etc/cloudera-scm-server/db.properties
-------新建用户和库(cloudera-scm为原postgresql数据库超级用户)
create user cloudera-scm password '1234567890' superuser createrole createdb;
grant postgres to cloudera-scm
-------
CREATE USER amon WITH PASSWORD '1234567890';
CREATE DATABASE amon OWNER amon ;
GRANT ALL PRIVILEGES ON DATABASE amon to amon;
-------
CREATE USER hive WITH PASSWORD '1234567890';
CREATE DATABASE hive OWNER hive ;
GRANT ALL PRIVILEGES ON DATABASE hive to hive;
-------
CREATE USER hue WITH PASSWORD '1234567890';
CREATE DATABASE hue OWNER hue ;
GRANT ALL PRIVILEGES ON DATABASE hue to hue;
-------
CREATE USER nav WITH PASSWORD '1234567890';
CREATE DATABASE nav OWNER nav ;
GRANT ALL PRIVILEGES ON DATABASE nav to nav;
-------
CREATE USER navms WITH PASSWORD '1234567890';
CREATE DATABASE navms OWNER navms ;
GRANT ALL PRIVILEGES ON DATABASE navms to navms;
-------
CREATE USER oozie_oozie_server WITH PASSWORD '1234567890';
CREATE DATABASE oozie_oozie_server OWNER oozie_oozie_server ;
GRANT ALL PRIVILEGES ON DATABASE oozie_oozie_server to oozie_oozie_server;
-------
CREATE USER rman WITH PASSWORD '1234567890';
CREATE DATABASE rman OWNER rman ;
GRANT ALL PRIVILEGES ON DATABASE rman to rman;
-------
CREATE USER scm WITH PASSWORD '1234567890';
CREATE DATABASE scm OWNER scm ;
GRANT ALL PRIVILEGES ON DATABASE scm to scm;
-------导出老数据
pg_dump -h localhost amon -U cloudera-scm -p 7432 -f amon.sql
pg_dump -h localhost hive -U cloudera-scm -p 7432 -f hive.sql
pg_dump -h localhost hue -U cloudera-scm -p 7432 -f hue.sql
pg_dump -h localhost nav -U cloudera-scm -p 7432 -f nav.sql
pg_dump -h localhost navms -U cloudera-scm -p 7432 -f navms.sql
pg_dump -h localhost oozie_oozie_server -U cloudera-scm -p 7432 -f oozie_oozie_server.sql
pg_dump -h localhost rman -U cloudera-scm -p 7432 -f rman.sql
pg_dump -h localhost scm -U cloudera-scm -p 7432 -f scm.sql
-------删除表(新的数据库如果有错误数据的话,可能需要此步骤,没有的话就跳过此步骤)
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='oozie_oozie_server' AND pid<>pg_backend_pid();-------如果database drop不掉被占用的话,先执行这个sql
drop database hive;
drop database hue;
drop database oozie_oozie_server;
drop database scm;
-------查看库
\l
-------切换数据库
\c hue
-------查看库下面的表
\d
-------查看以及删除用户
\du
drop user hive;
drop user hue;
drop user hue1;
drop user oozie_oozie_server;
drop user oozie_oozie_server1;
drop user scm;
-------查看有哪些用户
\du
--------------初始化cloudera-scm-server服务
/usr/share/cmf/schema/scm_prepare_database.sh postgresql scm scm -h 1.2.3.4 -P 7432(自己修改IP,如果不是默认5432端口的话,加参数-P[大写P])
-------------导入新数据
psql -p 7432 -U amon amon < amon.sql
psql -p 7432 -U hive hive < hive.sql
psql -p 7432 -U hue hue < hue.sql
psql -p 7432 -U nav nav < nav.sql
psql -p 7432 -U navms navms < navms.sql
psql -p 7432 -U oozie_oozie_server oozie_oozie_server < oozie_oozie_server.sql
psql -p 7432 -U rman rman < rman.sql
psql -p 7432 -U scm scm < scm.sql
2、安装cloudera-manager-server
yum install -y cloudera-manager-server
3、服务前移
).在cloudera manager页面上停止Cloudera Management Service监控服务
).主节点关闭cloudera-scm-server,所有节点关闭cloudera-scm-agent
主节点:service cloudera-scm-server stop
所有节点:service cloudera-scm-agent stop
.修改新的主节点下 service cloudera-scm-server/db.properties的配置文件
vi /etc/cloudera-scm-server/db.properties
com.cloudera.cmf.db.host=hadoopNode2
).修改所有节点agent下的配置文件
vi /etc/cloudera-scm-agent/config.ini
server_host=hadoopNode2
).主节点启动 cloudera-scm-server
service cloudera-scm-server start
所有节点启动cloudera-scm-agent
service cloudera-scm-agent start
).登陆新节点的7180,查看服务状态
Be First to Comment