Database Migration Case Study Migration to Amazon Aurora

About GiveCentral

GiveCentral is a web-based donation platform designed to help nonprofit organizations raise more money. By consolidating all collection, fundraising and communication activities in one place, GiveCentral makes it easier for donors to give, for nonprofits to communicate and for administrators to manage their finances and donor records. Through its customizable, costeffective and versatile platform, GiveCentral enhances the fundraising experience for all those involved.

THE CHALLENGES

The initial database infrastructure for the customer’s platform included two MySQL servers (one master and one slave). This infrastructure was fixed and running full-time. A cold disaster recovery environment was provisioned with specifications identical to the production environment. This environment was running full-time but was not used until a manual failover was initiated. This failover process could take several hours. The customer wanted a Scalable Database setup with a quick failover.

THE SOLUTIONS

RDS allowed Nuclay to provide a standby MySQL instance in a different AZ, with automatic replication and failover protection in the event of hardware failure in the primary instance. Configuring MySQL slaves, that typically took several hours, was reduced to a few minutes. Last 30 days automatic backups were configured, also allowing point-in-time restoration to any time within the last week. This provided the best balance between data availability for disaster recovery and cost effectiveness.

THE BENEFITS

Improved Availability
RDS’ Multi-AZ Configuration dramatically improved the Database availability.

Improved Performance
Scalable Replicas dramatically reduced the overall application footprint.

Reduced Cost of Ownership
Total Cost of ownership was reduced by 40%

ABOUT NUCLAY SOLUTIONS PVT. LTD. AND AWS

At Nuclay, we are equipped with all the modern technological and digital know how which could provide the most pointed solutions to our clients. Whatever the challenges, we know how to adapt to all the changing circumstances and mould ourselves to suit the same. We believe in being flexible with our working techniques, without straying an inch away from delivering all requirements.

We are passionate about supporting other businesses in their growth. All our clients need to do is focus on their core business while we handle everything else to help them stay ahead.

AWS provides a broad platform of secure, cost-effective, high-performance cloud services that can be used to process and analyze the data stored in your managed database.

NEXT STEPS

To learn more about how Nuclay Solutions Pvt. Ltd. can help your business, visit https://www.nuclaysolutions.com/

Ashish Saxena

Leave a Reply