Exit-test: Install Database

[Nithinraot]

Create the Issue Exit-test: Install Database Assign the Issue to yourself and label it started Install MySQL 5.5 or MariaDB 5.5 on the first node listed in 0_setup.md Use a YUM repository to install the package Copy the repo configuration you use to challenges/labs/1_my-database-server.repo.md On all cluster nodes Install the database client package and JDBC connector jar on all nodes Start the server and create these databases: scm rman hive oozie hue sentry Record the following in challenges/labs/1_db-server.md The command hostname -f and its output The command mysql -u -p -e "status;" and its output The command mysql -u -p -e "show databases;" and its output Push this work to GitHub Label the Issue review and assign it to the instructor

[Nithinraot]

sudo yum install mariadb-server -y sudo service mariadb stop

[Nithinraot]

update my.cnf vi /etc/my.cnf

transaction-isolation = READ-COMMITTED socket=/var/lib/mysql/mysql.sock

Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

Settings user and group are ignored when systemd is used. If you need to run mysqld under a different user or group, customize your systemd unit file for mariadb according to the instructions in http://fedoraproject.org/wiki/Systemd 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

binlog_format = mixed

read_buffer_size = 2M read_rnd_buffer_size = 16M sort_buffer_size = 8M join_buffer_size = 8M

log_bin=/var/lib/mysql/mysql_binary_log max_connections = 550 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/mariadb/mariadb.log pid-file=/var/run/mariadb/mariadb.pid !includedir /etc/my.cnf.d

[Nithinraot]

sudo systemctl enable mariadb sudo service mariadb start sudo /usr/bin/mysql_secure_installation

[Nithinraot]

create database scm default character set utf8; create database oozie default character set utf8; create database metastore default character set utf8; create database rman default character set utf8; create database hue default character set utf8; create database sentry default character set utf8;

grant all privileges on scm. to 'scm'@'%' identified by 'Cloudera'; grant all privileges on oozie. to 'scm'@'%' identified by 'Cloudera'; grant all privileges on metastore. to 'scm'@'%' identified by 'Cloudera'; grant all privileges on rman. to 'scm'@'%' identified by 'Cloudera'; grant all privileges on hue. to 'scm'@'%' identified by 'Cloudera'; grant all privileges on sentry. to 'scm'@'%' identified by 'Cloudera';