How do I configure CM database (Oracle server 12.x) to fail over i.e. (one server fails so other picks up)? This database is being used by CM and other associated components.
Any assistance is appreciated.
Hello @wert_1311 ,
thank you for reaching out about how to configure high-availability for CM.
Can you please specify the version you are using, so I can send you the most relevant information?
In the meantime, please find below the documentation covering your enquiry for CM6.3.
Please let me know if it covers your enquiry. Please do not miss to read the Database High Availability Configuration section.
Hi @Bender ,
Thanks for your reply .We are using CM / CDH 5.16.3. the pain point we have is, CM and associated Hadoop stack (hive, hue, sentry, Oozie and cloudera manager) connect to Oracle DB, whenever DB or Unix Team needs to carry out maintenance activity we are required to shut down the Hadoop cluster impacting on the availability. Hence looking for ways to setup database fail over.
Our Oracle DB (Oracle 12c) has 2 instances running and all our other application connect to this DB using a scan-ip, hence if one instance goes down the application automatically connect to another instance, thus there is no downtime. We were thinking of the same if that can be done for our Hadoop cluster / stack.
Would like to know if this is possible, if not then what is the other way to overcome this.
Hello @wert_1311 ,
thank you for letting us know that you are using CDH5.16.3.
I would consider Oracle's solutions for DB high availability.
Our documentation describes:
"Oracle supports a wide variety of free and paid upgrades to their database technology that support increased availability guarantees, such as their Maximum Availability Architecture (MAA) recommendations."
You can also consider implementing Backup and Disaster Recovery.
Please let us know if it helps!