Worldwide Flight Services

A Seamless Database & Disaster Recovery Solution

Catered to the Experience.

“Now that I’ve got a really excellent process in place, and I’ve also got an excellent partner in EagleDream, I can sleep very comfortably at night, knowing that if a disaster happens, at least we have a way to recover very quickly.”

Gwen Schulze

North America IT Infrastructure and Network Manager

The World’s Leading Cargo Shipping Company

Worldwide Flight Services (WFS) is a leading global cargo shipping company, specializing in ground handling of air cargo for airlines, airports, and passengers. Operating in over 300 airlines and airports around the world, the company meets strict governmental security protocols to safely and securely handle over four million tons of air cargo each year.

Challenge

For close to 50 years, Worldwide Flight Services (WFS) has built its reputation as one of the world’s leading providers of ground handling services for airlines and airports. To maintain their reputation and meet growing demand, WFS must meet stringent governmental security protocols and maintain high IT availability. Any downtime would result in an inability to screen and load cargo, which would lead to financial losses, reputation damage, and customs fines.

Additionally, Worldwide Flight Services was hosting several business-critical Microsoft SQL Server databases on-premise with no High Availability (HA) capabilities.

Worldwide Flight Services desired to move their on-premise databases to the cloud to have a more reliable High Availability plan in case of system failure, as well as reduce administrative overhead of managing their own systems.

Solution

At first, WFS partnered with EagleDream to design an enterprise-grade, cloud-based disaster recovery strategy. Together, the EagleDream and WFS teams began planning the implementation using CloudEndure’s Disaster Recovery Technology. There were various recovery objectives including minimal data loss and downtime.

After the DR solution was implemented, EagleDream and WFS completed UAT end-to-end application testing as disaster preparation. A second part of this solution involved EagleDream’s proposal to migrate WFS’s on-premise databases to Amazon RDS Instances.

To perform the migration to Amazon RDS, EagleDream leveraged CloudEndure to launch an up-to-date replica of the original database servers on Amazon EC2. Once the replica was created, a backup of the databases were dumped to Amazon S3 and restored onto the Amazon RDS instances using AWS’s recommended backup and restore approach.

Both the test and production environments were successfully migrated to the cloud, freeing the administrative overhead from their team so they could focus on more important projects and business tasks. The database currently runs natively on Amazon RDS with two synchronous copies, so in case of failure, the database will automatically fail over to the stand-by copy without little-to-no interruption for the end user.

AWS Services Used

  • Amazon EC2
  • SQL Server Management Studio
  • Amazon S3
  • Amazon RDS

OS PLATFORMS

  • Microsoft SQL Server 2008 R2 SP3

Original Infrastructure

  • Windows Server 2008 R2

Results

A Disaster Recovery solution that integrates seamlessly with AWS. WFS can rest comfortable knowing that if a disaster happens, they will have a way to recover very quickly.

10

servers were successfully replicated in disaster recovery

Terabytes

of Data were successful copied

Sub-Second

Recovery Point Objectives (RPOs) were achieved, ensuring that their servers would be spun up in the most up-to-date state after a disaster

Minutes

of time in Recovery Time Objectives (RTOs) were achieved, significantly reducing the time needed to fully recovery after a disaster

All the good stuff that made it successful

Key Features & Successes

Highly Available

Worldwide Flight Services’ production databases are now Highly Available in AWS. In the event of a failure at the RDS layer, AWS will automatically failover to the standby database instance which does not require any intervention from Worldwide Flight Services’ IT team.

Confidence in their Environment

WFS is now quickly and efficiently running in a cloud environment. They can rest comfortably knowing that should a disaster take place, they have an efficient strategy in place, and can quickly recover.

More Strategic Use of IT Team

With both the support of EagleDream and the use of Amazon RDS, Worldwide Flight Services no longer needs to handle tasks such as server maintenance, backups, and patching. Their team can now focus their time and efforts on other important tasks.

Subsecond RPOs and RTOs of Minutes

WFS was clear with the numbers they needed and EagleDream, partnering with CloudEndure, ensured that these goals were met. EagleDream was able to successful replicate ten servers in disaster recovery with minimal data loss, in record time.

Improved Scalability

Their team can easily scale resources up or down as needed with little-to-no downtime and no performance degradation. For example, disk space can be added to their live production database instance without the need to schedule a maintenance window.

Successful Replication of an IBM MQ Server

One of the most unique aspects of this solution involved an IBM MQ Server, a very specialized piece of technology. This is a queuing server that stores large quantities of data in memory, and is the technology that performs communications with TSA, US Customs, and SITA. This servers is a central component to the WFS system. One the many reasons that WFS partnered with EagleDream was their past experience and knowledge of IBM MQ servers, and the team successful delivered in duplicating this server in AWS.

Key Benefits

Highly Available

Worldwide Flight Services’ production databases are now Highly Available in AWS. In the event of a failure at the RDS layer, AWS will automatically failover to the standby database instance which does not require any intervention from Worldwide Flight Services’ IT team.

More Strategic Use of IT Team

With both the support of EagleDream and the use of Amazon RDS, Worldwide Flight Services no longer needs to handle tasks such as server maintenance, backups, and patching. Their team can now focus their time and efforts on other important tasks.

Improved Scalability

Their team can easily scale resources up or down as needed with little-to-no downtime and no performance degradation. For example, disk space can be added to their live production database instance without the need to schedule a maintenance window.

Partners on the Project

Like what you see?

View Our Other Work

Let’s Start Building

Have an idea that you would like to share? We want to help bring your ideas from concept to reality.