Relational DB move to AWS

  • Intelligence Community | Cloud Services | Datacenter Services | Relational Database Services

Blackspoke designed a highly available Microsoft SQL Always On Cluster to help facilitate multiple application migrations and to provide scalability using an AWS privately hosted Cloud Infrastructure. With over 25 off the shelf and custom applications requiring a relation database backend, the importance of migrating instances to an agnostic infrastructure was paramount to one Intelligence Agency in particular. Plagued by constant hardware renewals and storage failures, Blackspoke provided a streamlined method of migrating from an outdated physical cluster to an Always On cluster in the cloud.

This agency in particular had over 25 mission critical applications that relied heavily on a failing Microsoft SQL Cluster. The agency itself was plagued by such common failures and expensive hardware maintenance renewals until the called upon the expertise of Blackspoke. Some of the applications in question provided realtime data to troops on the ground so it was important to quickly engineer and “with little to no downtime” migrate the application back-end data to the cloud. Moving to the cloud meant that the system would have to maintain its level of performance, integrity and be able to scale as needed. Another challenge that the agency faced was finding expertise in the application as some of the apps were had no support.

Blackspoke and its team of engineers quickly provided a proof of concept to simulate the work load that the current system was accustomed to. By using powershell, Blackspoke was able to collect and reproduce a near exact system load within the AWS cloud. Using the cloud approach also let the team spin up multiple environments for application owners to test migrations which helped facilitate successful migrations. Blackspoke also created multiple environments for future upgrade and testing of applications, something the agency did not have. Overall, a project that was scheduled to take almost 1 year took less than 7 months to fully engineer, deploy and migrate and saved the agency over 250k dollars in hardware expenditures, maintenance renewals and costly downtime.

  • 100% Fully Migrated Relation DB to an AWS Cloud
  • 1st Intelligence Agency to use SQL 2014 Always On technology in the AWS Cloud
  • 35% Reduced Project Time-Frame (Engineering, Deployment, and Migration)
  • Fully Replicated Environments for (Development, User Testing and Deployment)
  • Over 250k in cost savings
  • 100% Fully Redundant SQL offering in the IC