topic Re: Oracle and four node cluster in Operating System - Linux

Oracle and four node cluster

Vladimir Fabecic — Mon, 22 May 2006 09:18:21 GMT

Hello
I do not have much experience with clustering on linux.
Requirement:
3 servers have to run one or two Oracle instances (not RAC). If one node fails, 4th server has to take over the instance(s) of failed one.
Any suggestion how to make it would be welcome.
Is it possible to make active/active configuration, i.e. that every server run one instance and take over instance of failed server? If so, how?
Wcich cluster software to use?
Thanks

Re: Oracle and four node cluster

Ivan Ferreira — Mon, 22 May 2006 09:52:37 GMT

I know about Red Hat Cluster Services.

Using this software, you can configure the Oracle as required for your installation. Every node can run an instance of oracle and if the node fails, another node can start both instances.

You need a shared disk storage for this (For example MSA, EVA, etc). It's also recommended that you use a fence device for maintaining data integrity. Check the Red Hat Cluster Suite documentation for detailed information. The fence device can be for example, HP RILO available on most servers or a Brocade SAN Switch used to connect the storages.

Every node has access to the shared disk storage. If a node fails, as the other nodes have access to the storage also, you can configure to start the failed oracle instance in any other node.

Re: Oracle and four node cluster

Steven E. Protter — Mon, 22 May 2006 11:01:11 GMT

Shalom,

Active-Active is not possible without RAC. It would immediately corrupt the Oracle database on shared storage.

If the data was read only and hosted on local disk of each node, it would be possible to run oracle on all nodes. There would however be no failover under this scenario.

Red Hat Clustering or Service Guard for Linux can handle an active-backup clustering scenario for you.

SEP

Re: Oracle and four node cluster

Ivan Ferreira — Mon, 22 May 2006 14:34:18 GMT

What I mean by active-active is to run one instance in one node accessing to one disk partition, and another instance on another node using another disk partition (Not the same instance on both nodes). Each node is failover node for the other.

Re: Oracle and four node cluster

Serviceguard for Linux — Mon, 22 May 2006 18:40:17 GMT

Serviceguard for Linux can handle that configuration. A toolkit for Oracle failover is also available. The toolkit is licensed per cluster.

http://www.hp.com/go/sglx

Re: Oracle and four node cluster

Vladimir Fabecic — Tue, 23 May 2006 01:20:01 GMT

Thank you guys.
Looks like there is a good way to do it.
I have to replace TRU64 cluster with linux solution. With active/active I meant no dedicated standby server and cluster file system.
Can you post some links with documentation?
Which clustering software is better and which is cheaper?
Is there some "best practice" example?
Shared storage is EVA3000. Which Redhat distribution (or SUSE?) is the best choice?
Do I need secure path?

Re: Oracle and four node cluster

Serviceguard for Linux — Tue, 23 May 2006 01:32:44 GMT

The link I posted for Serviceguard for Linux is the best starting point. www.hp.com/info/sglx has much of the documentation. While it is a little dated, the configuration guide gives a lot of info on best practice for cluster configuration.

As for pricing, the list price is roughly $1300 per server, but check with your distributor or sales person for exact pricing. Various support options are available. The Oracle toolkit list is $995.

The latest full documentation is available as well:

http://docs.hp.com/en/ha.html#Serviceguard%20for%20Linux
or more specifiically:
http://docs.hp.com/en/B9903-90046/B9903-90046.pdf and
http://docs.hp.com/en/B9903-90048/B9903-90048.pdf

Hope this is a useful start

Re: Oracle and four node cluster

Vitaly Karasik_1 — Tue, 23 May 2006 06:07:20 GMT

RH Cluster Suite costs about $500 annually.
I'll prefer RH Cluster Suite instead of SG because in this case you have one vendor and one support point == Red Hat. In addition SG uses (AFAIK) closed source kernel modules, so you cannot use the latest recommended kernel version, but must to wait when HP will release appropriate SG modules version.

As for securepath - you can use Qlogic driver failover.

Re: Oracle and four node cluster

Vladimir Fabecic — Tue, 23 May 2006 07:45:42 GMT

Hello Vitaly
Thanks for interesting data.
Vitaly and "Serviceguard for Linux", what are feature differences between RH cluster and HP Serviceguard cluster?
Also would like to use RedHat GFS. I have seen that it works OK with Serviceguard, so no problem with that.
Regards

Re: Oracle and four node cluster

Serviceguard for Linux — Tue, 23 May 2006 08:36:24 GMT

Correction to Vitaly comments.

Serviceguard does not use closed sourse kernel components. We have had no issues with support from RedHat or Novell(Suse).

Customers can buy RedHat or (I believe) SUSE from HP and get support from HP.

Serviceguard for Linux is based on Serviceguard for HP-UX. That means it has a history greater than 10 years and we are constantly looking for improvements. One thing we focus on is no single point of failure in the cluster. For any cluster you should look at every component within that cluster and see if its failure can possibly take down the cluster or worse.

Re: Oracle and four node cluster

Vitaly Karasik_1 — Wed, 24 May 2006 01:01:06 GMT

Yes, my SG experience is little outdated - as far as I remember, in 2002 in order to install SG for Linux you were need to re-compile kernel, as far as I remember.

As for SG vs. RH Cluster Manager - I'll vote for Cluster Manager because it's not restricted to HP hardware and IMHO, has bigger installbase and simplier for configuring. Of course, if you (your company ) have some HPUX SG experience, SG for Linux may be your optimal choice.

Re: Oracle and four node cluster

Vladimir Fabecic — Wed, 24 May 2006 01:37:16 GMT

I have big experience with TRU64 cluster and OpenVMS cluster, not with SG. I know that nothing else can be compared to them, but must find working solution.
By the way, there is a tape library on FC. Can one server do backup of all file systems in entire cluster or every server must backup its file systems?

Re: Oracle and four node cluster

Serviceguard for Linux — Wed, 24 May 2006 08:31:35 GMT

Vitialy is correct that SGLX was more "kernel intrusive" in the past. Luckily, with RH3 that was no longer required.

On 3rd party server, SGLX does support some 3rd party servers, specifically from IBM and Dell. I know that will not meet the needs of all customers - but then again, no product meets the needs of all customers. Check out the certification matrix on www.hp.com/info/sglx for the list of supported servers.

On backup, I'm no expert but know that most high end backup SW can control backup of a number of servers from one server. What I am not certain of is whether these can "failover" if that is your desire.

Re: Oracle and four node cluster

Vladimir Fabecic — Thu, 25 May 2006 08:07:04 GMT

Thanks
Still do not know about feature differences.
About backup: In TRU64 which is share everything cluster, every member can access all tape devices, even local tapes on other nodes. If tape is FC, then every node can access it directly. And no special backup software is needed since everything is on cluster file system so everyone can access it dicectly.
Ivan Ferreira knows how it works in TRU64.
Personaly, I would prefer SG, but not sure what would other say.
Any idea how to do backup on FC tape library in linux cluster envirement?

Re: Oracle and four node cluster

Vitaly Karasik_1 — Thu, 25 May 2006 15:03:39 GMT

>Still do not know about feature >differences.
I afraid you need read & compare RH Cluster Manager & HP SG docs. IMHO, there no enough people which work with both products.

http://www.redhat.com/solutions/clustersuite/
http://h18026.www1.hp.com/solutions/enterprise/highavailability/linux/serviceguard/index.html

and, BTW, you should understand that as SEP said, you cannot run the same Oracle instance on several nodes simultanuosly without Oracle RAC.

>Any idea how to do backup on FC tape >library in linux cluster envirement?
Each cluster node is a separate computer in RH Cluster Manager or HP SG, so in order to backup data from your second node you may use scp (rsync, ...) to copy files to your first node, which has attached tape.

Re: Oracle and four node cluster

Vladimir Fabecic — Fri, 26 May 2006 03:32:58 GMT

Thanks Vitaly
I will have to read documentation.
Too bad there are no poeple that worked with both products.
About things what SAP said: of course I understand that same Oracle instance can not run on several nodes simultanuosly without Oracle RAC.
This is not what I mean with active/active. I mean the same Ivan means and also cluster file system ability.
OK, I see there is no way to get TRU cluster functionality.

Re: Oracle and four node cluster

Delrish — Wed, 07 Jun 2006 03:55:24 GMT

RedHat Cluster Suite is based on opensource project. It can provides both high availability and loadbalancing for you. As I know RH Clusster Suite use LVS for load balancing.However Serviceguard just provides high availability.Also mangement on RH is web based and in HP solution is client based.Another difference is in price. Also RedHat CS supports RedHat GFS but SG deos not support it ( If you want to use GFS). You can use SG on all the linux distro but RHCS will be installed just on RedHat enterprise linux.