Its new for me too. I might use your example as a sample :-)
Just a reflection of different services using somewhat different patterns. But looks good to me. ________________________________ From: Pratik Gadiya <[email protected]> Sent: Thursday, April 23, 2015 11:59 AM To: [email protected] Subject: RE: Configure Database in Ambari Sumit, looks like following is the appropriate configuration which needs to setup in blueprint for my case i.e. configuring oozie and hive to use existing MySQL database { "hive-env" : { "hive_database" : "Existing MySQL Database", "hive_database_name" : "hive", "hive_database_type" : "mysql", "hive_existing_mysql_database" : "MySQL", "hive_user" : "hive", "hive_metastore_user_passwd": "<password>” } }, { "hive-site" : { "ambari.hive.db.schema.name" : "hive", "javax.jdo.option.ConnectionPassword": "<password>" } }, { "oozie-env" : { "oozie_ambari_database" : "MySQL", "oozie_database" : "Existing MySQL Database", "oozie_existing_mysql_database" : "MySQL", "oozie_user" : "oozie" } }, { "oozie-site" : { "oozie.db.schema.name" : "oozie", "oozie.service.JPAService.create.db.schema" : "false", "oozie.service.JPAService.jdbc.driver" : "com.mysql.jdbc.Driver", "oozie.service.JPAService.jdbc.username" : "oozie" } } Let me know if there has to be any modification in the same. Thanks, Pratik From: Sumit Mohanty [mailto:[email protected]] Sent: Wednesday, April 22, 2015 7:28 PM To: [email protected] Subject: Re: Configure Database in Ambari Can you check oozie-site? ________________________________ From: Pratik Gadiya <[email protected]<mailto:[email protected]>> Sent: Wednesday, April 22, 2015 2:49 AM To: [email protected]<mailto:[email protected]> Subject: RE: Configure Database in Ambari Thanks Sumit! I followed the same approach and have few queries on the same. When I try to deploy the cluster using Ambari UI, I can see that I can pass the values for database username, database host etc. from the UI. Once the cluster got deployed via Ambari UI, I grabbed the blueprint from the deployed cluster and here is what I have got. { "hive-env" : { "hive_database" : "Existing MySQL Database", "hive_database_name" : "hive", "hive_database_type" : "mysql", "hive_existing_mysql_database" : "MySQL", "hive_hostname" : "%HOSTGROUP::host_group_1%", "hive_user" : "hive", "webhcat_user" : "hcat" } }, { "oozie-env" : { "oozie_ambari_database" : "MySQL", "oozie_database" : "Existing MySQL Database", "oozie_derby_database" : "Derby", "oozie_existing_mysql_database" : "MySQL", "oozie_existing_oracle_database" : "Oracle", "oozie_existing_postgresql_database" : "PostgreSQL", "oozie_user" : "oozie" } } In the above configuration which is grabbed from the deployed cluster, I can’t see keys such as oozie_database_name as we have for hive_database_name. Apart from that, I couldn’t figure out why I couldn’t see oozie_hostname as we have hive_hostname here. Please let me know how can I pass the oozie_database_name and the oozie_hostname in the configuration part. Also, do let me know if I could skip the entries highlighted in yellow from the above configs if they are not of use for just configuring all the services to use MySQL as database instead of their default databases. Thanks, Pratik Gadiya From: Sumit Mohanty [mailto:[email protected]] Sent: Tuesday, April 14, 2015 8:06 PM To: [email protected]<mailto:[email protected]> Subject: Re: Configure Database in Ambari If you have a Ambari UI based deployment that is configured to use MySQL then you can export blueprint from it. https://cwiki.apache.org/confluence/display/AMBARI/Blueprints has pointers on how to export. thanks Sumit ________________________________ From: Pratik Gadiya <[email protected]<mailto:[email protected]>> Sent: Tuesday, April 14, 2015 2:04 AM To: [email protected]<mailto:[email protected]> Subject: Configure Database in Ambari Hi All, I want to configure all the hadoop services as well as ambari to use MySQL database instead of using their default databases. Please let me know how can I configure this in the blueprint json file. Note:- By default Databases used in Ambari are listed in the link below http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.2.0/HDP_Ref_Gd_v22/supported_database_matrix/index.html#Item1.1 With Regards, Pratik Gadiya DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails. DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails. DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
