Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Anyone using cloud RDBMS with on-prem Grouper?

Please Wait...

grouper-users@internet2.edu

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Anyone using cloud RDBMS with on-prem Grouper?


Chronological Thread 
  • From: Andre Daniels <andre777@ucsc.edu>
  • To: Greg Haverkamp <gahaverkamp@lbl.gov>
  • Cc: Tim Darby <tdarby@email.arizona.edu>, Chris Hyzer <mchyzer@isc.upenn.edu>, "grouper-users@internet2.edu" <grouper-users@internet2.edu>
  • Subject: Re: [grouper-users] Anyone using cloud RDBMS with on-prem Grouper?
  • Date: Thu, 26 Apr 2018 13:54:32 -0700
  • Ironport-phdr: 9a23:IhopRRR01yyy2LbAe2JkWwSJstpsv+yvbD5Q0YIujvd0So/mwa6yYRCN2/xhgRfzUJnB7Loc0qyK6/umATRIyK3CmUhKSIZLWR4BhJdetC0bK+nBN3fGKuX3ZTcxBsVIWQwt1Xi6NU9IBJS2PAWK8TW94jEIBxrwKxd+KPjrFY7OlcS30P2594HObwlSizexfb1/IA+qoQnNq8IbnZZsJqEtxxXTv3BGYf5WxWRmJVKSmxbz+MK994N9/ipTpvws6ddOXb31cKokQ7NYCi8mM30u683wqRbDVwqP6WACXWgQjxFFHhLK7BD+Xpf2ryv6qu9w0zSUMMHqUbw5Xymp4rx1QxH0ligIKz858HnWisNuiqJbvAmhrAF7z4LNfY2ZKOZycqbbcNwUX2pBWttaWTJHDI2ycoADC/MNMOddo4T7ulAArwaxBRO0CeP1yDBIiH/406M53eo8Dw/JwBctEMgSvHnOttj5KLseXOKzwaLVzTvDdfRW2TLl5YXUdBAuvOuMUqxtesTf00YvEQLFgUuUqYz+IjiY0f4Cs26G4Op6S+2iiWwqpgNqrziy2sgskZXGipgLxV/Z6CV02YA4LsC7Rk5jedOoDppduz2YOoZzTMMvQHpntDo/x7AJpZK3YDQFxZE7yBLDa/GKdo2F7gz9WOmPJzpzmWhrd6ilhxmo9Eit0u38Wdew0FZNtidFl8PDtnEJ1xDK9MiHSedx8l6u2DqRyQzc9PtIIU8zlarcJJ4hxqA/moAPvkTEGy/6gET2jKmIeUU44uWk9eXqbqnkq5KZOY95iRrxPrgrl8GwHeg0LhQBUm2H9uig1LDu+Ej0TKtUgvIoiqXZtYrVJcUfpq63GQ9V1YMj5g6lADegzdsYh2cIIVBHdR+FlIXpJk3BIOvkAvulnVujjSpry+jcPrL9GpXNMmTDkLD5cLZy8U5czxczzchB6JJOE70BPenzVVHrtNzDFRI5Nw20w/37CNVmyI8SQ2OPAqmFMKzMq1+I4PwgI/WSaIMPpjnyNuUltLbSiioWg1ISNYmgw5YNa3m9BrwyLEyZaGThmNQIFH8iugA6CuPtlgvRazNLY2eOWPc14D0hBaq7BpzIAI2hne+vxiC+S7RQanpLQnyFF3blc57MD/4KZDiffZA+uiEPTrPnRoM8g0L9/DTmwqZqe7KHshYTsojugZ0sv7Pe

We put it all in the cloud. Works great.

On Thu, Apr 26, 2018 at 12:08 PM, Greg Haverkamp <gahaverkamp@lbl.gov> wrote:
I can attest that the on-premise difference is huge.

So, I'll just have to manage a database, I guess, until we have our final cloud-hosting environment ready to go.

Greg

On Thu, Apr 26, 2018 at 11:55 AM, Tim Darby <tdarby@email.arizona.edu> wrote:
I agree with Chris. We found that the latency between AWS and on-prem was killing Grouper performance. It worked well when we put it all in the cloud. Also, I'll put in a plug for MariaDB RDS, which works great with Grouper.

Tim Darby
UA Identity Services | The University of Arizona | tdarby@email.arizona.edu | +1 520.626.3799



On Tue, Apr 17, 2018 at 10:01 PM Hyzer, Chris <mchyzer@isc.upenn.edu> wrote:

I would run the JVM next to the database (either both on prem or both in cloud)

 

Thanks

Chris

 

 

From: grouper-users-request@internet2.edu [mailto:grouper-users-request@internet2.edu] On Behalf Of Greg Haverkamp
Sent: Wednesday, April 18, 2018 12:47 AM
To: grouper-users@internet2.edu
Subject: [grouper-users] Anyone using cloud RDBMS with on-prem Grouper?

 

My deployment progress has been literally slowed, and I'm trying to figure out if there's something I'm just doing wrong.

 

I've generally had pretty good luck with AWS RDS (though with Postgres), and we run a couple of services off of it.  Our plan was to deploy the Grouper DB to AWS RDS (MySQL) while running Grouper on-prem, at least until we work out our desired strategy for pushing everything out.  

 

However, we've found Grouper to be ridiculously slow in this model.  Slow enough that it makes it difficult to try to get anything done with it.

 

Today I spent the day poking, prodding, resizing, creating new resources, etc., all which seem to indicate that perhaps the Grouper DB is not well-suited to even minimal latency.  I'm wondering if anyone else has attempted this and found otherwise?

 

At this point, I've tried AWS RDS MySQL (5.7).  With my load, gsh takes about a minute to display its prompt.  This seems to be the case regardless of RDS instance size (bumped to get "Network Performance" from "Medium" to "High", General SSD storage size (bumped it up to 100 GB to try to get the performance wins), etc.  I also converted to Amazon Aurora, in an attempt to see if it could be that.  However, performance remained basically the across all attempts.  Around 1 minute to get to the gsh prompt and around 1-2 seconds to findSubject().

 

Then, I decided to try a quick benchmark.  I cranked up a MySQL 5.7 Docker on my desktop, loaded up my data, and pointed my Grouper instance at it.  gsh appeared in around 10 seconds, and the findSubject() returned almost immediately.

 

Deciding I'd give one last shot at not having to run my own database, I cranked up MySQL at Google and loaded the data.  It returns faster, but only about 20% faster than AWS.  (It's perhaps not coincidental that my ICMP RTTs around about 20% faster to Google than to AWS.)

 

I'm guessing this is likely in the nature of Grouper, and that perhaps it's just running so many queries that 20 ms per query starts to add up.  Does that seem about right?

 

Greg





--
Andre Daniels 
Sr. Developer/Security Analyst
University of California Santa Cruz
(831) 459-1980
andre777@ucsc.edu



Archive powered by MHonArc 2.6.19.

Top of Page