| Author |
Message
|
| frankstar123 |
 Posted: Sat Oct 12, 2013 2:49 pm Post subject: MQ Active - Standby on Oracle Solaris Sparc |
 |
|
Novice
Joined: 10 Dec 2012
Posts: 15
|
Hi guys,
We have a requirement to run MQ 7.1 on an Oracle Sparc server but we are having problems working out how to make this HA. Our SLA with business is up time of 99.9% and recovery should be within 1 hour.
The plan is this server will be split into 3 virtual hosts; hosting WAS, MQ and Oracle database.
There will be a second physical server acting as standby, with WAS, MQ and Oracle database.
Oracle will be using datagaurd to maintain the secondary backup database.
We had planned to put MQ DATA on FS on SAN mounted to the "Active" server and if this physical machine fails we then mount the FS on the standby machine.
However our Unix Administrator has put a stop to this design. He has informed us that if the Active server goes down there is no guarantee that the SAN file system mounted on the active server is unmounted. And if its mounted on the standby server it could corrupt the data if the active server recovers while the backup server uses it too (i.e 2 machines mounting the same FS)
Has anyone ever had the same objection? Is there something else we can do? If we dont have the MQ high availability we would not be able to recover / recreate the Messages within the SLA with the business.
Thanks for your help in advance.
Frankstar |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Sat Oct 12, 2013 9:34 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
What filesystem type are you using on your SAN?
If you are following the guidelines for setting up Oracle in an Active-Passive setup as shown here
https://blogs.oracle.com/xpsoluxdb/entry/clusterware_11gr2_setting_up_an_activepassive_failover_configuration
Then perhaps your sysadmin needs to look for another role.
Seriously, if you are using the Solaris system failover stuff then I can't see what their objection is.
Perhaps he/she should talk to Oracle and see what they say about his objections. Methinks it is a case of NIH (Not invented here).
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| frankstar123 |
| Posted: Mon Oct 14, 2013 12:48 am Post subject: |
|
|
Novice
Joined: 10 Dec 2012
Posts: 15
|
Hi smdavies99
Thanks for your reply.
Just to clarify, there's no problem with the "design" of the Oracle failover. These databases will be using local disks and using oracle datagaurd to keep them in "sync" with the standby server.
The problem is we do not have any hardware clustering option for MQ because its Oracle hardware running MQ as well.
We wanted to put the MQ data on SAN and remount the volumes in an event of a failure. Hence the UNIX SA objections. I'm not 100% sure of the filesystem type, ZFS comes to mind but I will check.
Thanks foryour reply. |
|
| Back to top |
|
|
| frankstar123 |
| Posted: Mon Oct 14, 2013 3:39 am Post subject: |
|
|
Novice
Joined: 10 Dec 2012
Posts: 15
|
|
| Back to top |
|
|
| bruce2359 |
| Posted: Mon Oct 14, 2013 10:00 am Post subject: |
|
|
Poobah
Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.
|
Not to be confused with zFS.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Oct 14, 2013 11:13 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| frankstar123 wrote: |
| the SAN is ZFS. |
If working with solaris zones make sure that there is no degradation of disk performance depending on the zone.
Also I seem to remember seeing some time back a snippet saying that solaris had trouble with the correct locking for MI and was not suited for MI... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Darren57 |
| Posted: Mon Oct 14, 2013 11:51 pm Post subject: |
|
|
Newbie
Joined: 14 Oct 2013
Posts: 1
|
For Oracle Solaris: use contact admin not SAN as no Oracle Cluster HA MQ module available as far as I know.
WebSphere MQ V7 multi-instance queue managers feature, you will need a shared file system on networked storage. The storage must be accessed by a network file system protocol that is Posix-compliant and supports lease-based locking. Network File System version 4 (NFS v4) satisfies this requirement. Note: earlier versions of NFS do NOT satisfy this requirement and must not be used with multi-instance queue managers. |
|
| Back to top |
|
|
| frankstar123 |
| Posted: Tue Oct 15, 2013 5:01 am Post subject: |
|
|
Novice
Joined: 10 Dec 2012
Posts: 15
|
Can I run an NFS V4 mount point on our servers from our ZFS SAN?
Or is NFS only related to N A S?
Our simpliest requirement is the ability to "spool" up a second instance of MQ on another server with all the data available. Not to fussed on Multiinstance queue managers if we dont need them.
Last edited by frankstar123 on Tue Oct 15, 2013 5:31 am; edited 4 times in total |
|
| Back to top |
|
|
| frankstar123 |
| Posted: Tue Oct 15, 2013 5:05 am Post subject: |
|
|
Novice
Joined: 10 Dec 2012
Posts: 15
|
| Darren57 wrote: |
| For Oracle Solaris: use contact admin not SAN as no Oracle Cluster HA MQ module available as far as I know. |
Yep thats the problem our current end of life solution uses Sun Cluster HA MQ Module. There's no new MQ module in Solaris 11 + new hardware we are using.
What do you mean by
| Darren57 wrote: |
| For Oracle Solaris: use contact admin |
Just realised I think N.A.S must be short for Contact Admin on this board.
N A S was ruled out because its over a network lan connection and would be competing with image traffic. |
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Tue Oct 15, 2013 7:15 am Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
| frankstar123 wrote: |
| Our simpliest requirement is the ability to "spool" up a second instance of MQ on another server with all the data available. Not to fussed on Multiinstance queue managers if we dont need them. |
Do you mean you want QueueManager1 on VirtualServer1 to come up on PhysicalHostB if PhysicalHostA takes a dirt nap?
Before: QueueManager1...VirtualServer1...PhysicalHostA
After: QueueManager1...VirtualServer1...PhysicalHostB
Or like this, where the same QM comes up on another O/S?
Before: QueueManager1...VirtualServer1...PhysicalHostA
After: QueueManager1...VirtualServer2...PhysicalHostx
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| SAFraser |
| Posted: Fri Oct 18, 2013 10:25 am Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
I believe your unix admin is giving you good information.
If you really want to use SAN for your filesystem, you need HA software that will failover the SAN mount (such as Veritas Cluster Server).
What you want to do is not a good idea (IMHO). MQ is designed to be used with HA software or it is designed to be installed as multi-instance. This idea of "just bring it up somewhere else" is not a good idea, unless you are looking at the standby instance as a completely cold spare (which would work just dandy, but requires a bit of time and manual intervention).
Hope this helps a bit.... |
|
| Back to top |
|
|
|
|
