https://community.cloudera.com/t5/Archives-of-Support-Questions/Cloudbreak-for-AWS-and-specifying-RDS-for-HiveMetastore/m-p/115152#M46911 <P>Hi <A rel="user" href="https://community.cloudera.com/users/3076/bmathew.html" nodeid="3076">@Binu Mathew</A>,</P><P>We have two different kind of external database support in Cloudbreak for provisioned cluster. One <A href="http://sequenceiq.com/cloudbreak-docs/release-1.6.1/database/">for Ambari</A> (technical preview) and the other <A href="http://docs.hortonworks.com/HDPDocuments/HDCloudAWS/HDCloudAWS-1.8.0/bk_hdcloud-aws/content/hive-metastore/index.html">for Hive metastore</A>, but unfortunately to use both of them you have to use Cloudbreak shell because the first one is officially available only in Cloudbreak and the second is HDCloud exclusive feature.</P><P>To configure RDS for Ambari you have to execute database configure shell command before executing cluster create command:</P><PRE>database configure --vendor --host --port --name --username --password</PRE><P>Hive metastore RDS configuration available in cluster create command:</P><PRE>cluster create --databaseType --connectionUserName --connectionPassword --connectionURL --hdpVersion</PRE><P>[update]</P><P>RDS configuration for Cloudbreak is configurable in Cloudbreak deployer's Profile file by adding the environment variables below:</P><PRE>CB_DB_PORT_5432_TCP_ADDR CB_DB_PORT_5432_TCP_PORT CB_DB_ENV_USER CB_DB_ENV_PASS CB_DB_ENV_DB</PRE> Tue, 22 Nov 2016 16:41:22 GMT rkovacs 2016-11-22T16:41:22Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Cloudbreak-for-AWS-and-specifying-RDS-for-HiveMetastore/m-p/115151#M46910 <P>If using Cloudbreak to launch a cluster on AWS, can you specify a database (mysql, postgresql) in Amazon RDS to store the metadata for components such as Hive, Oozie, Ambari? What If I want to use RDS instead of having cloudbreak setup the databases locally on the cluster. Or is the option then to have Cloudbrek create the database locally on my cluster, and then change the config files to point to a new database in Amazon RDS (I will copy over metadata from existing local repo to RDS). </P> Tue, 22 Nov 2016 09:26:10 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Cloudbreak-for-AWS-and-specifying-RDS-for-HiveMetastore/m-p/115151#M46910 bmathew 2016-11-22T09:26:10Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Cloudbreak-for-AWS-and-specifying-RDS-for-HiveMetastore/m-p/115152#M46911 <P>Hi <A rel="user" href="https://community.cloudera.com/users/3076/bmathew.html" nodeid="3076">@Binu Mathew</A>,</P><P>We have two different kind of external database support in Cloudbreak for provisioned cluster. One <A href="http://sequenceiq.com/cloudbreak-docs/release-1.6.1/database/">for Ambari</A> (technical preview) and the other <A href="http://docs.hortonworks.com/HDPDocuments/HDCloudAWS/HDCloudAWS-1.8.0/bk_hdcloud-aws/content/hive-metastore/index.html">for Hive metastore</A>, but unfortunately to use both of them you have to use Cloudbreak shell because the first one is officially available only in Cloudbreak and the second is HDCloud exclusive feature.</P><P>To configure RDS for Ambari you have to execute database configure shell command before executing cluster create command:</P><PRE>database configure --vendor --host --port --name --username --password</PRE><P>Hive metastore RDS configuration available in cluster create command:</P><PRE>cluster create --databaseType --connectionUserName --connectionPassword --connectionURL --hdpVersion</PRE><P>[update]</P><P>RDS configuration for Cloudbreak is configurable in Cloudbreak deployer's Profile file by adding the environment variables below:</P><PRE>CB_DB_PORT_5432_TCP_ADDR CB_DB_PORT_5432_TCP_PORT CB_DB_ENV_USER CB_DB_ENV_PASS CB_DB_ENV_DB</PRE> Tue, 22 Nov 2016 16:41:22 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Cloudbreak-for-AWS-and-specifying-RDS-for-HiveMetastore/m-p/115152#M46911 rkovacs 2016-11-22T16:41:22Z