@ARUN The MySQL option is fine for small to medium clusters, given enough database horsepower behind it, however it's going to struggle on higher through puts. As your cluster gets larger and busier, you'd need to almost move the MySQL db to a dedicated machine etc. The url you quoted is from early on in Ranger's history, there is now an Apache Solr backend for the Ranger audit db, which is significantly more scalable.https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.0/bk_Ranger_Install_Guide/content/ch_install_solr.html These days almost everyone start with the Solr backend as it's more scalable and will lead to fewer issues in the future as the cluster grows. Unless you have a very small environment, go Solr! . ... View more

@vsubramanian As the request to "http://test-1.c.i.internal:50070/webhdfs......." is failing with 500 error which indicates an Internal Server Error so definitely you will see a detailed stackTrace on your NameNode log. Please check & share the NameNode log to see what kind of error is it (Like OutOfMemoryError or some other error) based on that error we can suggest what can be done. Looking at the NameNode log will definitely give us a fare idea. ... View more

@darkz yu Are to you using Ambari Database as mysql? By any change is there any possibility that you can upgrade your mysql-connector-java driver version from 5.1.17 to 5.1.38 or later. As i remember there was some CPU utilization issue reported for the "5.1.17" version of connector. You can drop the latest mysql-connector-java jar inside the "/usr/share/java" directory and then create a symlink "/usr/share/java/mysql-connector-java.jar" as following to point to it. Then restart the components that are using mysql. # ls -lan /usr/share/java/mysql-* -rw-r--r--. 1 0 0 819803 Jun 22 2012 /usr/share/java/mysql-connector-java-5.1.17.jar -rwxrwxrwx. 1 0 0 992808 Mar 9 08:49 /usr/share/java/mysql-connector-java-5.1.41-bin.jar lrwxrwxrwx. 1 0 0 35 Mar 9 08:50 /usr/share/java/mysql-connector-java.jar -> mysql-connector-java-5.1.41-bin.jar . mysql-connector-java driver downlaod link: https://dev.mysql.com/downloads/connector/j/5.1.html ... View more