[IQUG] IQ 16 Multiplex shared disk cluster

Baker, Chris c.baker at sap.com
Thu Aug 24 06:06:17 MST 2017

You don't need anything.  Not sure where you are reading about a clustered LVM as a definite requirement (please provide the link).  For some platforms, we do now support some cluster/shared LVM solutions, per the docs, but in reality, IQ MPX was designed to not need anything at all.  This avoids the performance degradations implicit in a shared RW LVM, and the cost.

All you really need is RW access to the same raw partitions mounted to each node from a SAN.  IQ manages all the locking internally to prevent concurrent access to the same block by multiple nodes (something that is then redundant with a shared RW LVM, but at an added cost).

The raw partitions on the SAN are mounted as devices under /dev as block devices, then converted to /dev/raw character devices with ownership of the raw devices changed to be RW only by the invoker of the IQ server.

I suggest using symlinks in the .db directory to point to the /dev/raw devices to allow ease of portability and also makes creating the multiplex easier, especially in cases where you may have other block or raw devices mounted in different places on different nodes.

Attached are examples of the rules you need to convert the block devices to character raw devices under RHEL.  IMHO this is much more preferable than using a rawservice as the rules fire before services, allowing you to start IQ as a service (daemon) if you desire.


Chris Baker | Database Engineering Evangelist | CERT | PI HANA Platform Data Management | SAP
T +1 416-226-7033<tel:+1%20416-226-7033> | M +1 647-224-2033<tel:+1%20647-224-2033> | TF +1 866-716-8860<tel:+1%20866-716-8860>
SAP Canada Inc. 445 Wes Graham Way, Waterloo, N2L 6R2<x-apple-data-detectors://17/1>
c.baker at sap.com<mailto:c.baker at sap.com> | www.sap.com<http://www.sap.com/>

Conference tel: 1-866-312-7353,,9648565377#<tel:1-866-312-7353,,9648565377%23>

From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of Antonian, Vahe
Sent: Thursday, August 24, 2017 8:12 AM
To: iqug at iqug.org
Subject: [IQUG] IQ 16 Multiplex shared disk cluster

Curious what folks are using as their shared disk cluster software for IQ 16 Multiplex on Redhat (RHEL 6). SAP online whitepapers and knowledgebase articles have little to no detail and simply state that a clustered LVM is needed for the nodes to share the devices.


Vahe Antonian
Information Technology | Database IB Ops Service, MLEA 42
One Madison Avenue | New York NY 10010 | Americas
Phone +1 212 538 1642
vahe.antonian.2 at credit-suisse.com<mailto:vahe.antonian.2 at credit-suisse.com> | www.credit-suisse.com<http://www.credit-suisse.com>

Please access the attached hyperlink for an important electronic communications disclaimer:
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20170824/8d61f274/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 60-raw.rules
Type: application/octet-stream
Size: 1120 bytes
Desc: 60-raw.rules
URL: <http://iqug.org/pipermail/iqug/attachments/20170824/8d61f274/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 99-raw.rules
Type: application/octet-stream
Size: 502 bytes
Desc: 99-raw.rules
URL: <http://iqug.org/pipermail/iqug/attachments/20170824/8d61f274/attachment-0001.obj>

More information about the IQUG mailing list