Install and Configure Ambari Server with MySQL in CentOS/RHEL 7/6
Apache Ambari is an open source administration tool deploy to manage Hadoop cluster and responsible to monitor running applications and their status. In other words, Apache Ambari is an open source web-based management tool that manages, monitors and provisions the health of Hadoop clusters. It provides a highly interactive dashboard which allows the administrators to visualize the progress and status of every application running over the Hadoop cluster. Its flexible and scalable user-interface permits a scope of tools, for example, Yarn, Hive, etc, to be installed on the cluster and administers their performances in an easy to use.
Install the Ambari bits. This also installs the default PostgreSQL Ambari database.
# yum install ambari-server
Step 7: Setup the Ambari Server
Before starting the Ambari Server, you must set up the Ambari Server. Setup configures Ambari to talk to the Ambari database, installs the JDK and allows you to customize the user account the Ambari Server daemon will run as. Execute the mentioned command and follow the instruction.
# ambari-server setup
Step 7: Import Metadata to Ambari Server Database
After Ambari server setup we need to import the metadata to the Ambari server database. Use-mention command to import metadata.
# mysql -u root -p ambari < /var/lib/ambari-server/resources/Ambari-DDL-MySQL-CREATE.sql
Note: Sometime while importing metadata you can get mention error.
ERROR 1709 (HY000) at line 113: Index column size too large. The maximum column size is 767 bytes.
Use mention steps to resolve the error.
# mysql -u root -p mysql> SELECT schema_name,default_character_set_name FROM information_schema.SCHEMATA; mysql> ALTER DATABASE ambari CHARACTER SET utf8 COLLATE utf8_general_ci;
Step 8: Start Ambari Service
Now you are good to start the Ambari server. You can use mention command to start the Ambari service.
# ambari-server start
Step 9: Login the Ambari Server
You can access the Ambari Server using your favorite browser.