LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 08-27-2011, 02:21 PM   #1
arunabh_biswas
Member
 
Registered: Jun 2006
Posts: 92

Rep: Reputation: 16
Lightbulb Application Parallel read/write in common SAN volume


Dear Experts,

Greetings !!!

I've 2 HP DL380 G6 server with Redhat Enterprise Linux Advance Edition 5.5 x64 intalled (both the nodes having Fiber HBA cards and connected with SAN switches). I've assigned 5 common storage LUNs to both these servers on GFS2 filesystem and their mount points are /oradata, /data1, /index, /redo and /arch as requested by our DB & Application expert in our organization. I've setup 2 node Active / Passive cluster using Redhat cluster suite. Set the priority 1 to node 1 and 2 to node 2 in failover domain. The same volume and virtual ip ( or can say cluster ip for applications) will be available at one node a time. In case of failure of node 1, the cluster resources will switchover to node 2 and all the san volumes will be shifted and mounted on node2. As soon as the node 1 start working and get on the cluster resources are shifted back to node 1. This setup is tested and working fine.

Now, few things I want to explain about the role of both servers and my requirement what I want to to do.

Both servers having oracle 10g R2 and an application running on both servers. We're using GFS2 filesystem over CLVM.

1. How can the Oracle DB services will start automatically by cluster service on the server that will own the cluster resources, what I'll do to make sure that the DB service should be shutdown properly before the cluster resources get shifted to another node ?

2. I've add/assigned another 500 GB shared SAN volume to both the nodes, my purpose was to keep mounted the volume on both the servers at all the time for application files. I need to configure this volume in this way that the application on the both nodes can read/write in this volume parallely. But I also want to make sure that it should be available/accessible to another node in case any node among both will go down. Can I achieve the same in same Active / Passive cluster setup ?

3. In the reference to question no 2, Is there any way to setup the volume for parallel read/write for application in both node without cluster. I also want to add one more thing that we're having cisco based H/W load balancer through which we used to balance and forward multiple parallel read/write requests from clients (for this we're having another pair of application servers.


Thanks. Pls revert with your kind suggestions.

Arunabh
 
Old 08-27-2011, 04:25 PM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,553

Rep: Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946
Quote:
Originally Posted by arunabh_biswas View Post
Dear Experts,
I've 2 HP DL380 G6 server with Redhat Enterprise Linux Advance Edition 5.5 x64 intalled (both the nodes having Fiber HBA cards and connected with SAN switches). I've assigned 5 common storage LUNs to both these servers on GFS2 filesystem and their mount points are /oradata, /data1, /index, /redo and /arch as requested by our DB & Application expert in our organization. I've setup 2 node Active / Passive cluster using Redhat cluster suite. Set the priority 1 to node 1 and 2 to node 2 in failover domain. The same volume and virtual ip ( or can say cluster ip for applications) will be available at one node a time. In case of failure of node 1, the cluster resources will switchover to node 2 and all the san volumes will be shifted and mounted on node2. As soon as the node 1 start working and get on the cluster resources are shifted back to node 1. This setup is tested and working fine. Now, few things I want to explain about the role of both servers and my requirement what I want to to do. Both servers having oracle 10g R2 and an application running on both servers. We're using GFS2 filesystem over CLVM.

1. How can the Oracle DB services will start automatically by cluster service on the server that will own the cluster resources, what I'll do to make sure that the DB service should be shutdown properly before the cluster resources get shifted to another node ?

2. I've add/assigned another 500 GB shared SAN volume to both the nodes, my purpose was to keep mounted the volume on both the servers at all the time for application files. I need to configure this volume in this way that the application on the both nodes can read/write in this volume parallely. But I also want to make sure that it should be available/accessible to another node in case any node among both will go down. Can I achieve the same in same Active / Passive cluster setup ?

3. In the reference to question no 2, Is there any way to setup the volume for parallel read/write for application in both node without cluster. I also want to add one more thing that we're having cisco based H/W load balancer through which we used to balance and forward multiple parallel read/write requests from clients (for this we're having another pair of application servers.
If both these systems are just for an Oracle database, then the best thing you can do is to contact your paid-for Oracle support (since you're paying for support from both Oracle and RedHat, for your Redhat Enterprise Linux), and use Oracle RAC instead.
http://www.oracle.com/technetwork/da...iew/index.html

Simultaneous mounting of the same disk(s), parallel read-writes, etc., are handled, and it makes database scaling much easier. Again, using Oracle and RHEL, you are in a supported configuration, and should be paying for support from both companies, so using what you're paying for will get you much quicker (and better) answers. They'll be able to analyze your configuration and give you detailed advice
 
Old 08-30-2011, 12:31 AM   #3
arunabh_biswas
Member
 
Registered: Jun 2006
Posts: 92

Original Poster
Rep: Reputation: 16
Thanks TB0NE for the reply,

Sorry for the delayed reply.

Yes, U'r right that I can take support from Oracle. But I just wanted to do it at my level first then I'll go for support.

I want to clear few things that We're having 2 scenarios.

1. we're not going to use Oracle RAC. We've configured OS level clustering in Active / Passive mode. I want to keep start the Oracle DB services automatically on Primary node while it will keep stopped in secondary node. when the cluster services will shift from Primary to Secondary server, it should start the DB services on the other node, but before shifting to other node the DB services should stopped properly on the Primary node (in case the primary node having some network issue or like that).

2. We've also hosted an Application on both the nodes, which we want to run simultaneously on both the nodes. For that also, I've assigned a common storage volume to both the hosts. I wanted this volume to be keep mounted on both the nodes at a time, so that both the nodes can Read / write simultaneously. For that should I configure this volume in cluster configuration, or separately mount it on both the nodes by /etc/fstab file. What filesystem should I use so that there will be no parallel read/write issue will arise.

Kindly tell me how (i mean brief procedure) can I achieve this ?

Regds

Arunabh
 
Old 08-30-2011, 10:05 AM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,553

Rep: Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946Reputation: 7946
Quote:
Originally Posted by arunabh_biswas View Post
Thanks TB0NE for the reply,
Sorry for the delayed reply.

Yes, U'r right that I can take support from Oracle. But I just wanted to do it at my level first then I'll go for support. I want to clear few things that We're having 2 scenarios.
Spell out your words..it's "your", not "u'r". Using the support you paid for is not only a good idea, it's the best and quickest way for you to learn. Asking the people who WROTE the software how it best works, will give you the best ways to do things.
Quote:
1. we're not going to use Oracle RAC. We've configured OS level clustering in Active / Passive mode. I want to keep start the Oracle DB services automatically on Primary node while it will keep stopped in secondary node. when the cluster services will shift from Primary to Secondary server, it should start the DB services on the other node, but before shifting to other node the DB services should stopped properly on the Primary node (in case the primary node having some network issue or like that).
Ok..again, if you've configured clustering correctly, that's how this will all work, since that's the purpose of the active/passive clustering. And again, if the two systems are ONLY Oracle database systems, NOT using RAC is a bad idea. RAC is much more capable of keeping a DB up and running no matter what.
Quote:
2. We've also hosted an Application on both the nodes, which we want to run simultaneously on both the nodes. For that also, I've assigned a common storage volume to both the hosts. I wanted this volume to be keep mounted on both the nodes at a time, so that both the nodes can Read / write simultaneously. For that should I configure this volume in cluster configuration, or separately mount it on both the nodes by /etc/fstab file. What filesystem should I use so that there will be no parallel read/write issue will arise.

Kindly tell me how (i mean brief procedure) can I achieve this ?
You don't. There are experimental file systems that will allow two systems to mount the same drive in read/write at the same time, but it's not a good idea, for very obvious reasons. Oracle RAC uses its own file system and management to avoid doing bad things. Again, you are PAYING FOR SUPPORT from RHEL and Oracle...calling them is the best choice for you.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to find a linux test tool to write and read IO on a volume kaganis Linux - Newbie 1 11-23-2009 02:40 PM
how to read and write from parallel port in linux in kernal user joecole10 Linux - Software 1 03-15-2008 02:02 PM
Mounting a FAT volume read/write alkaholic Linux - Newbie 2 11-30-2007 07:05 AM
Parallel Port Read/Write bingo Linux - Software 1 07-26-2007 06:42 PM
is there any shell command to read and write data from parallel and serial port? baosheng Linux - Hardware 2 01-13-2007 08:35 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 02:16 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration