Implement High Availability for Mission Critical Databases
Where “good enough” availability just isn’t good enough, ensure business requirements will be met before investing in people, processes, and technology for true high availability.
- For most systems, efficient backup/recovery processes and technology will meet recovery time objectives (RTO) and recovery point objectives (RPO).
- Mission critical databases support services that have an immediate, direct, and significant impact on revenue, goodwill, health and safety, and regulatory compliance. They require more attention than other systems.
Our Advice
Critical Insight
- Database high availability technology solutions are expensive and complex, and will have a significant impact on the way the system is managed in the future.
- Downtime is often caused by people and process problems, but organizations tend to focus only on technology solutions.
Impact and Result
- Identify the business impact of downtime on the services supported by each database workload. Use a business impact analysis (BIA) to identify the criticality of the databases.
- Identify databases that require both near zero downtime and zero data loss. Only these mission critical database systems should be considered for a true high availability solution.
- Review and evaluate database HA solutions that fit your environment to identify a shortlist of potentially feasible solutions.
- Create a business case that outlines the required steps, effort, cost, and impact of a potential solution to obtain business approval. This will also ensure a clear understanding with the business regarding expected results and accepted risks.
About Info-Tech
Info-Tech Research Group is the world’s fastest-growing information technology research and advisory company, proudly serving over 30,000 IT professionals.
We produce unbiased and highly relevant research to help CIOs and IT leaders make strategic, timely, and well-informed decisions. We partner closely with IT teams to provide everything they need, from actionable tools to analyst guidance, ensuring they deliver measurable results for their organizations.
What Is a Blueprint?
A blueprint is designed to be a roadmap, containing a methodology and the tools and templates you need to solve your IT problems.
Each blueprint can be accompanied by a Guided Implementation that provides you access to our world-class analysts to help you get through the project.
Contributors
- Steve Vereschagin, Senior Manager Enterprise Applications, Graymont
- Vince Bennett, Infrastructure Manager, Graymont
- Chuck Salvo, Founder and CEO, Red Brick Data
- Harish Vaidyanathan, Business Unit Head – IT Infra, Emerio
- Dilpreet Kaur, Senior SQL Server DBA, Merck
- Satwinder Singh, Supervising Associate – Database Administration, EY
- Mark Gribler, Oracle and SQL Database Consultant
- Michelle McLean, VP Marketing, ScaleArc
- Pardeep Dhull, Database Consultant, Capital One
- Ebenezer Akusaki, SQL Server DBA, UBS
- Brandon Frenchak, BI Specialist, Prince Minerals Inc
- One anonymous contributor
Manage Your Capacity to Increase Your Availability