[IQUG] [CAUTION] Re: ****SPAM**** [iqug] IQ Multiplex on AWS cloud

Love, Joe joe.love at sap.com
Thu Dec 13 10:35:48 MST 2018


I concur with Mark.
My division is probably the largest user of MapR for IQ, we implement the IQ specific MapR based storage via NFS. And we love it.
That said, it is done in a bare metal scenario.

When using AWS, it is best to use one of their pre-built storage options that is compliant with IQ, otherwise you are paying for additional compute and i/o for your storage as well, which can add up fast.
We have been looking at EFS as well for shared services between IQ, and other databases and our applications, but have not implemented it yet. If you go this route, I’d love to hear your experiences.

Best Regards and Happy Holiday Season to all,
-Joe Love
SAP Digital Interconnect

From: <iqug-bounces at iqug.org> on behalf of Mark Mumy <mark.mumy at sap.com>
Date: Thursday, December 13, 2018 at 9:12 AM
To: 'Leonid Gvirtz' <lgvirtz at yahoo.com>, "iqug at dssolutions.com" <iqug at dssolutions.com>
Subject: [CAUTION] Re: [IQUG] ****SPAM**** [iqug] IQ Multiplex on AWS cloud

NFS and GPFS are the only certified filesystems for multiplex.  And only on Linux.  MAPR-FS works as well, but generally requires more infrastructure.  We use MapRFS at SAP for some of our IQ based applications.

You should also look to EFS, Elastic File System.

One of the key features: It allows you to simultaneously share files between multiple Amazon EC2 instances across multiple AZs, regions, VPCs, and accounts as well as on-premises servers via AWS Direct Connect or AWS VPN

I wouldn’t go down the path of MapR only because it is more work given that there are other tools that do this.

EFS is being used on some of my test systems with IQ.  It handles some of the major issues with AWS storage.  Most single storage mount points or devices are limited in size to 16TB, or so.  Single devices have throughput limitations that may not serve IQ well.  And single filesystes will work over NFS with IQ-M, but you’ve got to set it up and manage it all.  EFS takes a lot of this pain away.


Mark Mumy
Strategic Technology Incubation Group
SAP Global Center of Excellence |  SAP
M +1 347-820-2136 | E mark.mumy at sap.com<mailto:mark.mumy at sap.com>
My Blogs: https://blogs.sap.com/author/markmumy/

Conference tel: 18663127353,,8035340905#

From: "iqug-bounces at iqug.org" <iqug-bounces at iqug.org> on behalf of IQ Group <iqug at dssolutions.com>
Reply-To: Leonid Gvirtz <lgvirtz at yahoo.com>
Date: Thursday, December 13, 2018 at 4:05 AM
To: IQ Group <iqug at dssolutions.com>
Subject: [IQUG] ****SPAM**** [iqug] IQ Multiplex on AWS cloud


One of my customers uses Simplex IQ on AWS cloud (Amazon) and I'm looking for possibilities to convert it to Multiplex. As far as I can see, an AWS EC2 volume can be attached to a single AWS instance (server) only, which prevents the straightforward implementation to the Multiplex.

I understand that it is possible to establish a Multiplex using a distributed filesystem that provides the NFS interface, as stated here: https://help.sap.com/viewer/a8955ad084f210159c929ca62a38bfde/ SAP and MAPR published a benchmark that proves that such a combination is possible (https://mapr.com/resources/supercharge-sap-iq-mapr-data-platform-amazing-analytic-power/assets/mapr_saptechnicalbrief.pdf). So, I can create an MAPR cluster on a number of AWS instances and connect to the MAPR cluster a number of Multiplex nodes, which are AWS instances too. I wonder if someone tried to implement the Multiplex in such a configuration. Or, maybe I'm just overlooking a simpler option? Also, it would be nice to hear about good alternatives to MAPR.

Thanks in advance
Leonid Gvirtz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20181213/94dc8aa5/attachment-0001.html>

More information about the IQUG mailing list