Amazon Aurora Database Upgrade

Screen Shot 2016-02-29 at 3.07.52 PMWe did a major database upgrade to Amazon Aurora MySQL this morning (with zero downtime!). This upgrade increases performance, improves scalability, improves reliability, availability and positions RunSignUp for continued growth and change. We were one of the Beta test sites for Aurora, and were very impressed with the performance and other gains from this amazing new service.

Performance
Aurora delivers up to 5 times the throughput. It can expand up to 500,000 reads per second and 100,000 writes per second (which will support 6 Million registrations per minute in our architecture – plenty for our focus on the endurance market). There is also a lower “latency” – meaning calls to the database are quicker. In addition, we configure “Read Replicas” in our architecture to separate out reporting requirements from registration. This means reports run quickly, and participants never see a slow down because many people are running reports.

Scalability
We can scale our database implementation to very large scale. We already have 1 database shard, and can introduce others as our platform continues to expand, but it is key that each database can scale so there is never a bottleneck. We can scale a database instance up to 32 CPU’s and 244 GigaBytes of Memory. Today, our database runs basically in memory, and the storage is on SSD. In addition, we can add up to 15 Read Replicas across multiple Availability Zones.

Reliability
Recovery from physical storage failures is transparent, and instance failover typically requires less than 30 seconds. The way our queuing software works (all database calls go thru a queue), users would just see the Ron jogging in place until the database came back online. Amazon Aurora’s storage is fault-tolerant and self-healing. Six copies of the database is replicated across three Availability Zones and continuously backed up to Amazon S3.

This all results in an optimal service for you and your participants. It is a lot of work and knowledge, and we hope you never notice!

Author: RunSignUp

RunSignUp is the leading innovator of online tools for race registration, race day solutions, and running clubs. Services include RunSignUp for registration, RunSignUp Go for Race Day, RunSignUp RD Go for Timers, RunSignUp Clubs to enable membership management, and RaceJoy for mobile experiences. More than 10,000 race directors, timers, running club officers and running stores use these services today, including leading organizations like the Boilermaker Road Race, Crim Festival of Races, Pittsburgh Three Rivers Marathon, Inc., Fifth Third River Bank Run, Blacklight Run, Bubble Run, Night Nation, Mercedes Marathon, Kentucky Derby Festival, Leone Timing, KC Running Company, Compuscore Timing, Knoxville Track Club, Pikes Peak Road Runners, Gulf Coast Runners, Columbus Running Company, Playmakers Running Store and many more. In 2015, over 10,000 races used the system to register more than 2.7 million participants. In 2016 over 14,000 races will use the system to process over 4.3 million paid registrations. Services are free except for processing fees when conducting monetary transactions such as race registration or club membership renewal. RunSignUp is founded by runners for runners, using technical capabilities to bring the power of cloud computing to benefit the running community. For more information, visit www.RunSignUp.com.

3 thoughts on “Amazon Aurora Database Upgrade”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s