Helping the Royal National Orthodpaedic Hospital achieve high availability

The Royal National Orthopaedic Hospital’s (RNOH) decided to replace SQL Server for PostgreSQL as the database underpinning their critical clinical web application to reduce overhead and improve reliability. They were able to complete their project in 6 months and now confidently implement HA PostgreSQL clusters with the help of ClusterControl.

NHS
Industry Healthcare
Technologies PostgreSQL
Hosting On-prem
Datacenters 2
Products ClusterControl

Background

The Royal National Orthopaedic Hospital (RNOH) was founded in 1905 and is the largest specialist orthopaedic hospital in the UK treating more than 120,000 neuro-musculoskeletal patients yearly. RNOH is regarded as a leader in the field of orthopaedics both in the UK and world-wide. It provides the most comprehensive range of neuromusculoskeletal complex conditions, including acute spinal injury, complex bone tumour treatment, orthopaedic medicine and specialist rehabilitation for chronic back pain.

Challenge

As the leading orthopedic healthcare centre, RNOH treats local and referral patients from other countries to treat complex or rare conditions. RNOH uses many locally hosted applications to deliver quality health care services to its customers. The clinical web application system is one of these applications and is frequently used by RNOH nurses and doctors to record daily clinical data transactions. This clinical web application is architected on an open source technology stack with PostgreSQL as its backend database.

Many of our applications that we use to deliver care to our patients rely on database backends that we host locally. Most of these systems are mission critical and uptime is of utmost importance, as is reliable backup and restoration processes to prevent data loss.

The majority of RNOH clinical applications worked on SQL Server and were managed by a highly technical team to ensure minimal system downtime. Managing this infrastructure involved high overhead cost on administrative tasks and costly software licensing. Adopting open source technology for their clinical web application was their first move to reduce the growing overhead cost and improve the system reliability.

Although the RNOH IT team had good experience with SQL Server, they had less experience when it came to operating PostgreSQL in production, let alone deploying and managing PostgreSQL clusters for high performance and availability. The team had a hands-on approach to manage the database, including manually recovering from failures and home grown backup scripts which were not very reliable.

RNOH required a way to automate the management and operations of the database. This would eliminate the need to have a dedicated resource to look after the database and ensure maximum uptime. This move would not only save the resource overhead cost, but it would ensure a speedy, reliable restoration and minimize downtime and risk, which is crucial for any system in the healthcare industry.

Solution

Having identified their problems in managing PostgreSQL efficiently, the RNOH IT team started their search for PostgreSQL experts in the market and found ClusterControl by Severalnines. ClusterControl was a perfect fit for their requirements; a fully automated ops management system with support for highly available deployments, advanced monitoring features, and automated backup and restore.

Outcome

In just six months, the RNOH team, together with Severalnines support, completed the deployment, data migration from SQL Server, and implementation of operational procedures for PostgreSQL with ClusterControl.

Severalnines provided full peace of mind with managing a highly available PostgreSQL cluster.

With ClusterControl, they were able to remove many mundane tasks from their limited resources while still having full peace of mind on their guarantee of 99.99% service uptime for their internal customers and patients.


Summary

confirmation-grey

A mission critical application

The RNOH’s clinical web application is essential to delivering effective patient care and requires a reliable, performant database to ensure it achieves 99.99% uptime.

confirmation-grey

Migrating to PostgreSQL

To reduce administrative and licensing overhead, they decided to migrate their workloads from SQL Server to PostgreSQL, but needed help to do so confidently.

confirmation-grey

Accomplishing 99.99% uptime

ClusterControl helped the RNOH team complete their migration in 6 months and administer their HA PostgreSQL databases with minimal intervention.


Ready to automate your database?

Sign up now and you’ll be running your database in just minutes.

Subscribe below to be notified of fresh posts