Exit-test: Install Database

[anantamukhta]

Install MySQL 5.5 or MariaDB 5.5 on the first node listed in 0_setup.md

• create repo vi mariadb5-5-60.repo [mariadb] name = MariaDB-5.5.39 baseurl=https://downloads.mariadb.com/MariaDB/mariadb-5.5.60/yum/rhel73-amd64/ gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1

• install mariadb server yum install MariaDB-server

• install java connector sudo mkdir -p /usr/share/java/ sudo wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.46.tar.gz sudo cp mysql-connector-java-5.1.46-bin.jar /usr/share/java/mysql-connector-java.jar

[anantamukhta]

• create database user

create database scm DEFAULT CHARACTER SET utf8; grant all on scm. TO 'scm'@'%' IDENTIFIED BY 'scm'; grant all on scm. TO 'scm'@'localhost' IDENTIFIED BY 'scm'; grant all on scm.* TO 'scm'@'172.31.29.229' IDENTIFIED BY 'scm';

create database rman DEFAULT CHARACTER SET utf8; grant all on rman. TO 'rman'@'%' IDENTIFIED BY 'rman'; grant all on rman. TO 'rman'@'localhost' IDENTIFIED BY 'rman'; grant all on rman.* TO 'rman'@'172.31.29.229' IDENTIFIED BY 'rman';

create database hive DEFAULT CHARACTER SET utf8; grant all on hive. TO 'hive'@'%' IDENTIFIED BY 'hive'; grant all on hive. TO 'hive'@'localhost' IDENTIFIED BY 'hive'; grant all on hive.* TO 'hive'@'172.31.29.229' IDENTIFIED BY 'hive';

create database oozie DEFAULT CHARACTER SET utf8; grant all on oozie. TO 'oozie'@'%' IDENTIFIED BY 'oozie'; grant all on oozie. TO 'oozie'@'localhost' IDENTIFIED BY 'oozie'; grant all on oozie.* TO 'oozie'@'172.31.29.229' IDENTIFIED BY 'oozie';

create database hue DEFAULT CHARACTER SET utf8; grant all on hue. TO 'hue'@'%' IDENTIFIED BY 'hue'; grant all on hue. TO 'hue'@'localhost' IDENTIFIED BY 'hue'; grant all on hue.* TO 'hue'@'172.31.29.229' IDENTIFIED BY 'hue';

create database sentry DEFAULT CHARACTER SET utf8; grant all on sentry. TO 'sentry'@'%' IDENTIFIED BY 'sentry'; grant all on sentry. TO 'sentry'@'localhost' IDENTIFIED BY 'sentry'; grant all on sentry.* TO 'sentry'@'172.31.29.229' IDENTIFIED BY 'sentry';

[anantamukhta]

• check hostname hostname -f

• check database version mysql -u root -e "status"

  mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1

Connection id: 8 Current database:
Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 5.5.60-MariaDB MariaDB Server Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 9 min 22 sec

Threads: 1 Questions: 47 Slow queries: 0 Opens: 0 Flush tables: 2 Open tables: 26 Queries per second avg: 0.083

• check database created [root@ip-172-31-22-135 ec2-user]# mysql -u root -e "show databases;" +--------------------+ | Database | +--------------------+ | information_schema | | hive | | hue | | mysql | | oozie | | performance_schema | | rman | | scm | | sentry | | test | +--------------------+