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.
- curl –u admin:admin –X DELETE –H ‘X-Requested-By:admin’ http://server:8080/api/v1/clusters/$NAME/hosts/$FQDN/host_components/MYSQL_SERVER
- curl –u admin:admin –X DELETE –H ‘X-Requested-By:admin’ http://server:8080/api/v1/clusters/$NAME/services/HIVE/components/MYSQL_SERVER