EA Slow Performance on AWS RDS

[fkeefe]

Hi,

The EA installation that I’m using runs on Amazon Web Services’ (AWS) Relational Database Service (RDS).  I have an ODBC connection to that.  The response time is so slow, it’s almost not usable.   We bumped-up our EA installation to use 4 CPUs and 30GB of RAM, and this doesn’t make any noticeable changes in performance. 

Does anyone have any recommendations for how to tweak or install EA on AWS such that it performs with less latency?

Thanks!
Francoise

[Eve]

I only have minimal testing experience connecting to AWS.

That was with our cloud services installed on the AWS too, which addresses some latency problems and will be significantly faster than a direct ODBC connection. As you've seen though, the problem isn't the set-up of the machine itself it's the network performance between the client and server.

[DanielB]

fkeefe: can you write a bit more about your configuration?

In which region is your RDS located?
What RDS type are you using (oracle, mysql, ...)?
Where are your useres locacted?
Do you have ea cloud service installed (as Simon mentioned it significantly improves performance, and in addition your gaining more convenient log-in)
How big is the repository?

Regards,
Daniel

[PeterHeintz]

Hi Daniel,
Sparx run tree test systems, you can connect read only.
Information about the connection you find here:
http://www.sparxsystems.com/products/ea/cloud-trial.html

With my personal PC I got the impression that it might be suitable to use EA via WAN, but with my business PC currently it is not.
We are still in investigation. One problem seem to be our virus scanner. When using the cloud connection each request response is first stored in a file deeply analyzed by our scanner.
I am not sure if this is the only problem we have, but we will see.

[fkeefe]

Hi, thanks to all who have responded.  We are using a MySql RDS.  I did some latency testing with a colleague yesterday who is close to the AWS source.  There was a slight response time improvement, but only slightly so. 

So, I did not do the installation - is there an easy way I can tell whether cloud service was installed?  If not, I will go back to the person who did the installation.

Thanks again!
Francoise

[Dermot]

If you are using an MySQL ODBC connection on EA to the MySQL repository then this is not connecting via the Cloud service. If it is via the the Cloud then you will be doing a Cloud connection.
We do suggest you push for the Cloud to be used.
There is a webinar on connecting AWS with the Cloud service on:
http://www.sparxsystems.com/resources/webinar/partners/cloud-server/amazon/deploy-enterprise-architect-model-on-amazon-cloud-aws.html
If you send though a request to the support email we can send you a document covering this in more detail.
I also suggest you find out the IP address of the AWS RDS and try doing a ping/tracert to check the general response rate. Note AWS does not have set ICPM on - so the administrator needs to set this on.