MacDonald-Miller Casestudy

About MacDonald-Miller Facility Solutions

MacDonald-Miller is a full service-design build mechanical contractor in the Pacific Northwest. With over 1,000 talented professionals, 10 locations and our own prefabrication shop, no project is too big or too small. We’ve helped shape the local landscape for over half a century with buildings that operate in the most efficient manner possible. We like to think we’re saving the planet one building at a time.

Facility managers, owners and tenants can all rest assured that our experience as industry leaders lends itself well to tackling the complexities of their industries--healthcare, biotech/labs, industrial, marine construction, commercial office buildings, and residential projects. We’ve done it all. And if we have our way, we’ll keep doing it for the next 50 years.

The Challenge

Internal IT infrastructure, including an internal datacenter, was built over many years. The company decided to migrate their applications to the AWS cloud for its scalability, flexibility, and support for automation.

Deployment automation and configuration management was fundamental to the project from its inception, as the company’s leadership correctly identified the typical “lift-and-shift” approach as a dead-end strategy for sustainable operations.

The company’s legacy line-of-business applications have a dependency on MSSQL with MSDTC. MSDTC support and the live migration of a large database to AWS was an added challenge.

Why Amazon Web Services

Per the latest Gartner Magic Quadrant report, AWS has always been a leader in Cloud Infrastructure as a Service with respect to completeness of vision and the highest ability to execute. On top of this, AWS offers multiple services for automation including resources provisioning, configuration management, and application deployments. AWS OpsWorks, AWS CodePipeline, AWS Lambda and AWS CloudFormation have been used to automate the company’s network monitoring system (Zenoss), application servers, and VPC in the cloud.

The figure below illustrates VPCs in the cloud:

VPCs in AWS with On-premise Network Integration

Figure 1: VPCs in AWS with On-premise Network Integration

The figures below illustrate automated deployment of VPC and Zenoss in the cloud:

VPC in AWS

Figure 2: VPC in AWS

Automated Zenoss Deployment in AWS

Figure 3: Automated Zenoss Deployment in AWS

Benefits of Automated AWS Infrastructure

Automated deployment of applications brings several benefits both to engineers and managers alike. When deployment is designed to be repeatable and automated, anyone can perform the deployment allowing engineers to focus on more critical tasks. Repetition makes the whole process less error-prone; thus benefiting the management implicitly. Moreover, these solutions can be extended to provide for other requirements such as multi-region deployments or a simple case of disaster recovery.

Live Migration of MSSQL with MSDTC Support

By leveraging third-party software SIOS DataKeeper, the live migration of the production core MS SQL Server database system was made possible. Initially, an EC2 instance was configured as a failover cluster member to the existing production database, with volume-level replication across an AWS Direct Connect private interconnect. Failover and failback between EC2-based MSSQL and legacy on-premise MSSQL server infrastructure was exercised. The final outcome was a multi-AZ MS SQL on Windows Server EC2 instances with volume-level replication across AZs and WSFC failover / clustering capabilities including MSDTC.