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.


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

Author: rajukv

Hadoop(BigData) Architect and Hadoop Security Architect can design and build hadoop system to meet various data science projects.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.