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.
