CASE STUDIES

Z Gallerie AWS Case Study

Secure SQL Databases on AWS

THE CHALLENGE

 

High Traffic Environment

Z Gallerie was challenged by a single point of failure in their Microsoft SQL database environment. Z Gallerie engaged CorpInfo to eliminate the single point of failure and implement highly available SQL database mirroring. CorpInfo deployed resources to manage the architecture and deployment of a highly available SQL database that was mirrored over multiple availability zones for redundancy, availability, and scale ability.

 

Vice President of Information Technology, Gary Zorko, summed up their challenge by stating, “We’re a small team without a full-time DBA, and we were struggling with introducing a new level of redundancy and resilience to our AWS-hosted commerce database infrastructure.”

THE SOLUTION

 

(HA) Database Across
Multiple Availability Zones

The solution for this project was a combination of Amazon Web Services products:

 

  1. EC2

  2. S3

  3. Multi-AZ SQL DB

 

CorpInfo set up a highly available (HA) database across multiple availability zones and ensured the integrity of the Z Gallerie DB tier by implementing security standards and best practices to ensure both redundancy and HA.

 

CorpInfo subsequently configured SQL mirroring for failover and also established a policy for snapshots and backups of the SQL databases; which are stored in Amazon S3.

WE PROVIDE SOLUTIONS

 

Why CorpInfo

As a Premier Consulting Partner to AWS, CorpInfo understood both Z Gallerie’s business as well as the complexity of the project at hand.  CorpInfo’s zeal in becoming the top AWS partner on the globe coupled with their almost 20-year partnership with Microsoft as a Gold tier partner have truly put CorpInfo ahead of the competition and enabled them to become a key stakeholder in the Microsoft on AWS market.  Z Gallerie realized that CorpInfo was the partner to take their business to the next level.

 

CorpInfo’s technical expertise is unrivaled in the AWS partner ecosystem. Each of the CorpInfo solutions architects is an AWS Certified Solutions Architect and many have attained additional professional level certifications.

 

In working with Z Gallerie to develop a cloud adoption strategy and roadmap for the forthcoming years, CorpInfo has also assisted Z Gallerie in the purchase of multiple EC2 reserved instances (RIs).

WHO IS Z GALLERIE

 

Exclusive Home
Furnishings Company

Z Gallerie is an exclusive home furnishings company that has been providing clients with high end furniture for almost 40 years. Z Gallerie stores are an ever-changing combination of stylish, traditional and contemporary designs. With 57 locations across the United States and an online presence, Z Gallerie continues to inspire both professional and amateur interior designers alike.

CorpInfo stepped in, recommended a solution, and planned, and executed to our budget and timeline. It’s been great working with their team.

GARY ZORKO
Vice President of Information Technology, Z Gallerie
Get in Touch with Us