Apache spark course on edx started Jun15th

Apache spark course on edx started Jun15th. Spark is the next big thing in BigData careers, go ahead and register. Happy Learning 🙂

Apache spark course on edx started Jun15th. Spark is the next big thing in BigData careers, go ahead and register. Happy Learning 🙂

https://www.edx.org/course/introduction-apache-spark-uc-berkeleyx-cs105x#

 

hadoop:Ambari: How to Un-manage mysql

In case if you want to configure ambari/hive to any existing mysql database and it has it’s own HA setup. Then you do not want ambari to manage your mysql.

https://community.hortonworks.com/questions/36736/un-manage-mysql.html

Here is the  Alejandro Fernandez Answer:

ambari-server setup controls the database used by Ambari, which I don’t think you want to change. You can see the DB name, username, and jdbc string in /etc//etc/ambari-server/conf/ambari.properties Ambari doesn’t actually perform any mysql restarts on that database.

Instead, you may have to delete the MySQL component from the HIVE service in Ambari since you’re managing it yourself.

http://server:8080/api/v1/clusters/$NAME/services/HIVE/components/MYSQL_SERVER will show which host contains that component. (note: you may have to stop the DB server before running this).

If I understood your question correctly, this is what you want to do to manage MySQL server on your own. You should also ask on the Hive mailing list.

  1. curl u admin:admin X DELETE H ‘X-Requested-By:admin’ http://server:8080/api/v1/clusters/$NAME/hosts/$FQDN/host_components/MYSQL_SERVER
  2. curl u admin:admin X DELETE H ‘X-Requested-By:admin’ http://server:8080/api/v1/clusters/$NAME/services/HIVE/components/MYSQL_SERVER