# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links = 0
key_buffer = 16M
key_buffer_size = 32M
max_allowed_packet = 32M
thread_stack = 256K
thread_cache_size = 64
query_cache_limit = 8M
query_cache_size = 64M
query_cache_type = 1
max_connections = 550
#expire_logs_days = 10
#max_binlog_size = 100M
#log_bin should be on a disk with enough free space. Replace '/var/lib/mysql/mysql_binary_log' with an appropriate path for your system
#and chown the specified folder to the mysql user.
log_bin=/var/lib/mysql/mysql_binary_log
# For MySQL version 5.1.8 or later. Comment out binlog_format for older versions.
binlog_format = mixed
read_buffer_size = 2M
read_rnd_buffer_size = 16M
sort_buffer_size = 8M
join_buffer_size = 8M
# InnoDB settings
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 64M
innodb_buffer_pool_size = 4G
innodb_thread_concurrency = 8
innodb_flush_method = O_DIRECT
innodb_log_file_size = 512M
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
sql_mode=STRICT_ALL_TABLES 3.5.2 启动并设置开机自动启动
/etc/init.d/mysqld start
chkconfig mysqld on 3.5.3 初始化数据库
mysql_secure_installation 向导如下：
[...]
Enter current password for root (enter for none):
OK, successfully used password, moving on...
[...]
Set root password? [Y/n] y
New password:
Re-enter new password:
Remove anonymous users? [Y/n] y
[...]
Disallow root login remotely? [Y/n] n
[...]
Remove test database and access to it [Y/n] y
[...]
Reload privilege tables now? [Y/n] y
All done! 3.5.4 准备scm库
1)方法一
数据库配置：
mysql -uroot -p
create database scm default character set utf8;
grant all privileges on *.* to scm@'cdm-m.cmdschool.org' identified by 'scm';
com.cloudera.cmf.db.password=scm
2)方法二(官方建议)
授权temp权限：
mysql -uroot -p
grant all privileges on *.* to 'temp'@'%' identified by 'temp' with grant option;
flush privileges;
生成配置文件：
/usr/share/cmf/schema/scm_prepare_database.sh mysql -h cdm-m.cmdschool.org -utemp -ptemp --scm-host cdm-m.cmdschool.org scm scm scm 显示如下：
JAVA_HOME=/usr/java/jdk1.7.0_67-cloudera
Verifying that we can write to /etc/cloudera-scm-server
Creating SCM configuration file in /etc/cloudera-scm-server
[main] DbCommandExecutor INFO Successfully connected to database.
All done, your SCM database is configured correctly!
确认生成的结果：
cat /etc/cloudera-scm-server/db.properties 显示如下：
# Auto-generated by scm_prepare_database.sh on Tue May 24 19:08:19 CST 2016
#
# For information describing how to configure the Cloudera Manager Server
# to connect to databases, see the "Cloudera Manager Installation Guide."
#
com.cloudera.cmf.db.type=mysql
com.cloudera.cmf.db.host=cdm-m.cmdschool.org
com.cloudera.cmf.db.name=scm
com.cloudera.cmf.db.user=scm
com.cloudera.cmf.db.password=scm
确认库访问权限:
mysql -uroot -p
show grants for scm@'cdm-m.cmdschool.org';
显示如下：
+----------------------------------------------------------------------------------------------------------------------+
| Grants for scm@cdm-m.cmdschool.org |
2 rows in set (0.00 sec)
清理数据库用户授权：
drop user 'temp'@'%';
flush privileges; 3.5.5 创建附加数据库(可选)
1)附加数据库列表 RoleDatabaseUserPasswordActivity Monitoramonamonamon_passwordReports Managerrmanrmanrman_passwordHive Metastore Servermetastorehivehive_passwordSentry Serversentrysentrysentry_passwordCloudera Navigator Audit Servernavnavnav_password Cloudera Navigator Metadata Server
navmsnavmsnavms_password 2)创建数据库并配置管理账号密码
mysql -uroot -p
create database amon default character set utf8;
grant all privileges on amon.* to 'amon'@'%' identified by 'amon_password';
create database rman default character set utf8;
grant all privileges on rman.* to 'rman'@'%' identified by 'rman_password';
create database metastore default character set utf8;
grant all privileges on metastore.* to 'hive'@'%' identified by 'hive_password';
create database sentry default character set utf8;
grant all privileges on sentry.* to 'sentry'@'%' identified by 'sentry_password';
create database nav default character set utf8;
grant all privileges on nav.* to 'nav'@'%' identified by 'nav_password';
create database navms default character set utf8;
grant all privileges on navms.* to 'navms'@'%' identified by 'navms_password';
flush privileges; 3.5.6 配置Oozie库(可选)
1)数据库权限配置
mysql -uroot -p
create database oozie default character set utf8;
grant all privileges on oozie.* to 'oozie'@'localhost' identified by 'oozie';
grant all privileges on oozie.* to 'oozie'@'%' identified by 'oozie';
QQ群⑧：
窥视卡
雷达卡
发表于 2018-10-29 13:08:26
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
显身卡