E-NDMS

Wednesday Oct 29, 2008

E-NDMS On the Move

What is Changing?

E-NDMS will soon move from its existing hosting infrastructure to the Amazon Elastic Compute Cloud. In the process, E-NDMS will be reduced to one site from the two that we have now and will run what you know as the BETA site for everyone.

Why is it Changing?

Today, E-NDMS runs on 3 servers co-located in a data center in Tulsa. 2 of those servers are nearing the end of their useful life, especially as E-NDMS continues to grow. E-NDMS is quickly closing in on 1,000,000 Model Services with Follow-up Contacts trailing close behind in the 850,000 range. To process that much data efficiently given the concurrency patterns of its users, E-NDMS is going to need more power.

E-NDMS also suffers from what I would term seasonal traffic patterns. While we encourage specialists to enter data weekly or even daily, we all know that doesn't always happen. As a result, there are a couple of times each year where E-NDMS traffic spikes dramatically. For the last 2 years, the most critical time of year has been May, but there is another longer-running uptick in traffic during the first couple of months of a new school year. As previous blog posts have revealed, the system has wilted under the pressure of the May traffic spike more than once.

When E-NDMS launched 6 years ago, the only viable option was to purchase hardware and co-locate it in a data center. Leasing servers or outsourcing the hosting was simply too expensive at the time. Since then, a technology called virtual private servers (VPS) has come onto the scene and drastically decreased hosting fees. Many of the new sites we host run on VPS systems.

VPS systems offer us tremendous flexibility. If we need more power, we can upgrade with just a flick of a switch. If hardware fails, the VPS provider migrates our virtual server to another physical server without any effort on our part. The limiting factor for E-NDMS has been the amount of power available and the performance of the storage subsystems in hosting a reasonably large database.

The Amazon Elastic Compute Cloud will give us the flexibility, convenience, and reliability of a typical VPS hosting arrangement, but it also allows us to right-size the VPS performance to current traffic patterns. So if there is a bottleneck in the application server during May, we can upgrade its resources or load balance across two systems until the traffic spikes subside. We can even schedule the availability of additional resources to handle the daily lunch time traffic spike.

How does this Affect You?

It's possible your network administrator had to open access to E-NDMS through a firewall. If that was the case, you will likely need to have the administrator change the IP address. As soon as that new address is available, I will post it on the site so you can work with your local network administrator to verify your access.

Other than that, I don't think John will mind me including a quote from his recent e-mail:

Re: the Test site - wow - that is fast - I know I'm the only one on there, but I ran some large reports and they were generated very quickly. I ran all sorts of reports and large downloads, and no problems.

The goal is to create a system that matches current E-NDMS performance under ideal conditions, but it appears that we may exceed that goal in our initial launch on Amazon EC2.

Please feel free to contact me in the comments or at endms@jag.org if you have any questions about the upcoming move.

Comments:

I cannot log on today. It rejects my log-in and/or password. Is this because of the new changes?

Posted by Lise Cater on October 29, 2008 at 01:46 PM CDT #

Logon problems today are unrelated to the changes. Nothing has changed yet. The BETA system was down early this morning, but everything appears to be working fine right now. If you continue to have trouble, please let me know, and I will check your account.

Posted by Jason on October 29, 2008 at 01:49 PM CDT #

Is a cleanup of the current data entry screens contemplated? Whe entering Participant Profiles, it is very time consuming to tab from field to field to enter data, only to have the cursor land uselessly on the TITLE of a field instead of the actual field itself. I have several other ideas which might ease data entry, also.

Posted by Jim Hanak on October 29, 2008 at 02:28 PM CDT #

There is a different, ongoing project aimed at simplifying the authentication architecture (our number one cause of outages) and to enhance the user interface.

Right now, none of the field titles in the new system are linked to help files, but that design is undergoing major revisions as we weren't pleased with a new layout approach.

Our main focus in the existing work has been to add interfaces that simplify the data entry tasks. For instance, one of the new interfaces presents a full roster in a table with entry fields for follow-up data. We have also reduced the Model Services entries to a single page.

Any ideas you have about data entry efficiency would be most welcome whether they be tab order, screen layout, or even entirely new ways of presenting the data.

Posted by Jason on October 29, 2008 at 04:20 PM CDT #

Jason,

Thanks for your timely & informative comments. Always nice to know that us folks in the field are taken seriously.

I love the idea of using a big table to do data entry. Check out www.engrade.com for some examples. Several teachers here use this and it is quite helpful.

Also, consider using table in the other direction, as well. Being able to export all my 2008-2009 participants as an excel spreadsheet or *.csv file would really help in sending mass emails and doing followup work.

Call me anytime.

Jim Hanak
John F. Kennedy High School

Posted by Jim Hanak on October 30, 2008 at 07:46 AM CDT #

Interesting site...thanks for the link.

Downloading data is available at the management level right now but not at the specialist level. It's available to specialists in the new system we are developing, but until that is ready for release, I'm afraid begging a manager for a download is your best bet.

Posted by Jason on October 30, 2008 at 11:08 AM CDT #

Is the JAG database working at this time? I have tried several times this week to log on and each time I can not log on this even happens at night when I am home. Right now I can log on.

Posted by Mary on November 15, 2008 at 11:54 AM CST #

Yes, the database has been working. Please e-mail me at endms-AT-jag-DOT-org if you continue to have trouble logging on.

Posted by Jason on November 17, 2008 at 03:36 PM CST #

Lately, system is very very slow when putting in data and selecting roster. Were there any changes connecting to data input?

Posted by Ann Cabbil on November 24, 2008 at 11:15 AM CST #

It appears some of the more computationally intensive reports were being run during the week. After monitoring it for a while, I canceled some of the reports to free up resources. It should be working well now.

The move will be taking place this weekend so the performance issues are unrelated.

Posted by Jason on November 25, 2008 at 08:59 PM CST #

I was in the process of updating information in endms and the system stop working and loged me off. I have tried to sign back on several times and the system will not let me log on. Please let me know if this is due to updates or changes.

Thank you.
V.jones

Posted by Veronica Jones on December 01, 2008 at 06:38 PM CST #

Post a Comment:
  • HTML Syntax: Allowed

Calendar

Feeds

Search

Links

Navigation