MRE Consulting’s Infrastructure Services Deployed SQL AlwaysOn
for Ista North America

Challenge

Ista North America needed to deploy a high-availability SQL environment for a North American utility. MRE Consulting was recruited to install, configure and manage the solution.

Solution

Microsoft’s SQL Server 2012 was selected as the best-fit solution. SQL 2012 delivered the required uptime and data protection, and its integrated, high-availability disaster recovery solution, SQL Server AlwaysOn, helps reduce planned and unplanned downtime. MRE also utilized Microsoft Cloud OS technologies to help Ista leverage cloud innovation. This technology enabled a data center without boundaries for simplified management and capacity on demand.

To meet the requirements of the project and keep costs low, Ista and MRE designed and implemented a system utilizing Microsoft’s Hyper-V technology to virtualize the SQL Servers. MRE then configured the SQL servers in an AlwaysOn Availability Group, which enabled maximum availability for all application databases. To meet the client’s need for a disaster recovery site, MRE devised a custom log shipping solution that worked with SQL 2012’s AlwaysOn technology. Finally, MRE enhanced the environment by working with the developers to tune the application and deployed a UAT environment for future development.

Results

The resulting environment supports over 10,000 users, is redundant and features a disaster recovery site that replicates the data entered into SQL Log Shipping. MRE Consulting continues to manage the environment through the use of automated maintenance plans and alerting systems.

Benefits

• Fully redundant hardware and applications
• Automatic failure detection and failover configurations
• No single points of failure
• Scalable, easy-to-manage environment