Re: Linux VM Failover

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 17 May 2021 13:54:11 -0500
Message-ID: <CAJvnOJZ2ByBYRs2H3p3kiz4qKHjQ38jX=V7O6m2HsqA3EEPMLg_at_mail.gmail.com>



I put together a cluster using corosync, pacemakener, and drbd. It was primarily as an experiment, I cant vouch for how well it would work on a production load:

https://dbakerber.wordpress.com/2019/03/15/oracle-cluster-with-drbd-pacemaker-and-corosync/

On Mon, May 17, 2021 at 1:11 PM Tim Gorman <tim.evdbt_at_gmail.com> wrote:

> Nenad,
>
> I have Azure customers using Pacemaker/Corosync (PCS) HA clusters on Linux
> (i.e. SUSE, RHEL, OEL) for Oracle databases in Azure. Out of the box, PCS
> supports other databases such as MySQL, SAP HANA, SAP ASE (Sybase), IBM DB2
> LUW, etc; pretty much anything.
>
> PCS is the open-source descendent of the older proprietary-UNIX HA
> clustering packages such as IBM HACMP on AIX, HP ServiceGuard on HP-UX, Sun
> HA on Solaris, and Veritas Clustering on several OS platforms. So, the
> reason people used those proprietary HA clustering technologies is likely
> the reasons PCS is used with Linux today?
>
> As for my Azure customers, they prefer the same HA clustering method
> across all applications and databases, which is not an unusual viewpoint
> when HA and DR are the responsibility of the infrastructure team, as
> opposed to being the responsibility of each of the database/application
> administration teams. For Oracle-based applications with RPO=0 and RTO <
> 30 seconds, DataGuard is the preference for its disaster resilience across
> geographies and its support for true "rolling upgrades" of database changes
> using DBMS_ROLLING. Some customers claim that DataGuard is "too expensive"
> because it requires double the storage, but that view quickly fades when
> compared to the additional US$23000/core licensing and US$5060/core support
> fees for RAC.
>
> With Oracle's power play of not supporting RAC on non-Oracle clouds,
> people are increasingly recognizing RAC as an overly expensive one-trick
> pony for HA.
>
> Hope this helps,
>
> -Tim
>
>
>
> On 5/17/2021 9:45 AM, Noveljic Nenad wrote:
>
> Does anyone use OS cluster for failing over Linux VMs with Oracle
> databases to another node?
>
>
>
> If so:
>
> 1. What were your reasons against Oracle Clusterware?
>
> 2. What cluster/Linux variant do you use?
>
>
>
> Best regards,
>
>
>
> Nenad
>
> ____________________________________________________
>
> Please consider the environment before printing this e-mail.
>
> Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.
>
>
> Important Notice
>
> This message is intended only for the individual named. It may contain
> confidential or privileged information. If you are not the named addressee
> you should in particular not disseminate, distribute, modify or copy this
> e-mail. Please notify the sender immediately by e-mail, if you have
> received this message by mistake and delete it from your system.
> Without prejudice to any contractual agreements between you and us which
> shall prevail in any case, we take it as your authorization to correspond
> with you by e-mail if you send us messages by e-mail. However, we reserve
> the right not to execute orders and instructions transmitted by e-mail at
> any time and without further explanation.
> E-mail transmission may not be secure or error-free as information could
> be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also
> processing of incoming e-mails cannot be guaranteed. All liability of
> Vontobel Holding Ltd. and any of its affiliates (hereinafter collectively
> referred to as "Vontobel Group") for any damages resulting from e-mail use
> is excluded. You are advised that urgent and time sensitive messages should
> not be sent by e-mail and if verification is required please request a
> printed version.
> Please note that all e-mail communications to and from the Vontobel Group
> are subject to electronic storage and review by Vontobel Group. Unless
> stated to the contrary and without prejudice to any contractual agreements
> between you and Vontobel Group which shall prevail in any case,
> e-mail-communication is for informational purposes only and is not intended
> as an offer or solicitation for the purchase or sale of any financial
> instrument or as an official confirmation of any transaction.
> The legal basis for the processing of your personal data is the legitimate
> interest to develop a commercial relationship with you, as well as your
> consent to forward you commercial communications. You can exercise, at any
> time and under the terms established under current regulation, your rights.
> If you prefer not to receive any further communications, please contact
> your client relationship manager if you are a client of Vontobel Group or
> notify the sender. Please note for an exact reference to the affected group
> entity the corporate e-mail signature. For further information about data
> privacy at Vontobel Group please consult www.vontobel.com.
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 17 2021 - 20:54:11 CEST

Original text of this message