https://community.cloudera.com/t5/Support-Questions/What-are-Best-Practices-for-placing-Databases-for-Oozie/m-p/110496#M73344 <A rel="user" href="https://community.cloudera.com/users/369/amcbarnett.html" nodeid="369">@Ancil McBarnett</A><P>Yes, we can use database on another node outside of the cluster. We need to make sure that network connection is stable and <STRONG>redundant</STRONG>. </P><P>I am big fan of database consolidation as it makes it easy to maintain and backup. </P> Tue, 26 Jan 2016 02:53:13 GMT nsabharwal 2016-01-26T02:53:13Z https://community.cloudera.com/t5/Support-Questions/What-are-Best-Practices-for-placing-Databases-for-Oozie/m-p/110495#M73343 <P>This <A target="_blank" href="https://community.hortonworks.com/questions/182/what-are-oozie-production-recommendations.html">link</A> has some great write ups on Oozie Production Recommendations. </P><P>It does mention DO not use the same Hive Server MYSQL database for Oozie.</P><P>What I want to know is can I use an existing database I have in my organization, perhaps on another node outside of the cluster, for Oozie, Ranger, Hive etc, or should all the databases be located in the cluster?</P><P>What are the cons for using an existing database on a separate node, network etc. outside the cluster for these components?</P> Tue, 26 Jan 2016 02:47:52 GMT https://community.cloudera.com/t5/Support-Questions/What-are-Best-Practices-for-placing-Databases-for-Oozie/m-p/110495#M73343 amcbarnett 2016-01-26T02:47:52Z https://community.cloudera.com/t5/Support-Questions/What-are-Best-Practices-for-placing-Databases-for-Oozie/m-p/110496#M73344 <A rel="user" href="https://community.cloudera.com/users/369/amcbarnett.html" nodeid="369">@Ancil McBarnett</A><P>Yes, we can use database on another node outside of the cluster. We need to make sure that network connection is stable and <STRONG>redundant</STRONG>. </P><P>I am big fan of database consolidation as it makes it easy to maintain and backup. </P> Tue, 26 Jan 2016 02:53:13 GMT https://community.cloudera.com/t5/Support-Questions/What-are-Best-Practices-for-placing-Databases-for-Oozie/m-p/110496#M73344 nsabharwal 2016-01-26T02:53:13Z https://community.cloudera.com/t5/Support-Questions/What-are-Best-Practices-for-placing-Databases-for-Oozie/m-p/110497#M73345 <P>What if the Database is in a VM Image?</P> Tue, 26 Jan 2016 02:54:22 GMT https://community.cloudera.com/t5/Support-Questions/What-are-Best-Practices-for-placing-Databases-for-Oozie/m-p/110497#M73345 amcbarnett 2016-01-26T02:54:22Z https://community.cloudera.com/t5/Support-Questions/What-are-Best-Practices-for-placing-Databases-for-Oozie/m-p/110498#M73346 <P>Just be wary of potential load issues. We reached the connection limits of our consolidated postgresql database because all services were pointing to the same db, This essentially stopped oozie and hive randomly. The biggest culprit seems to have been ranger. If auditing to db is switched on it puts quite a load on the database. </P> Tue, 26 Jan 2016 21:03:36 GMT https://community.cloudera.com/t5/Support-Questions/What-are-Best-Practices-for-placing-Databases-for-Oozie/m-p/110498#M73346 bleonhardi 2016-01-26T21:03:36Z https://community.cloudera.com/t5/Support-Questions/What-are-Best-Practices-for-placing-Databases-for-Oozie/m-p/110499#M73347 <P><A rel="user" href="https://community.cloudera.com/users/369/amcbarnett.html" nodeid="369">@Ancil McBarnett</A></P><P>Vm works as long as it's tuned and has good configuration . It's better to have vm as we can increase resources as we grow </P><P>Ranger will in solr so no concerns on <A rel="user" href="https://community.cloudera.com/users/168/bleonhardi.html" nodeid="168">@Benjamin Leonhardi</A> point "very good info "</P> Tue, 26 Jan 2016 23:26:21 GMT https://community.cloudera.com/t5/Support-Questions/What-are-Best-Practices-for-placing-Databases-for-Oozie/m-p/110499#M73347 nsabharwal 2016-01-26T23:26:21Z