The BBC delivers resilience of broadcasting services across TV, radio, and digital platforms using MySQL InnoDB Cluster.
Kim Cassells, Senior Database Systems Engineer, BBC said, “MySQL InnoDB Cluster provides us with the high availability, fault tolerance, and scalability that are critical for delivering modern broadcasting services. We also get advice directly from the MySQL engineers and can monitor our applications proactively.”
She also concluded,“Our success in deploying MySQL InnoDB Cluster at the BBC is extremely encouraging. We can offer this high availability solution now to other broadcast-critical operations within the BBC, such as the automation of the program-making galleries and studios in the BBC Broadcasting House in London. It's an exciting time ahead for us.”
Watch the full BBC session at our latest MySQL Day - UK Video
Business Challenges & Goals
The BBC is the world’s leading public service news organisation. BBC Wales ensures news and content production in English and Welsh for 3 TV stations, 25 radio stations, and numerous online channels. It is a pivotal site for the BBC.
The BBC needed to modernize its media production environment and further enhance production quality, high availability and on-demand scalability of its critical broadcasting applications. Those applications are dedicated to automating studio production systems, audio and video exports, and optimizing graphic engine routes.
Business Results & Metrics
Multiple MySQL InnoDB Cluster nodes were deployed in separate fault zones in the Cardiff datacentre. This provided enhanced efficiency, resiliency, and scalability to BBC Wales’ broadcasting services which are consumed round-the-clock by viewers in the United Kingdom and worldwide on television, radio, and digital platforms.
MySQL’s InnoDB Cluster technology gave the BBC a native, perfectly integrated, high availability solution for managing critical broadcasting services without having to rely on any external component or application failover logic. Failovers and data replication to all nodes are automatic. “The MySQL InnoDB Cluster configures itself automatically to determine which MySQL instance will act as the primary database node. Nobody notices anything: there is no service outage and no need for manual intervention,” Kim Cassells said.
The BBC’s DBAs have gained full visibility of potential issues in each node and the overall cluster with the help of MySQL Enterprise Monitor. The tool provides in-depth advice and alerts the DBAs on problems before these become critical. It also makes maintenance easier, enabling the DBA team to focus on core tasks such as process documentation instead of managing the clusters.
The BBC now has direct 24x7 access to experienced MySQL engineers and technical support to assist with the deployment, administration, and monitoring of their MySQL databases and applications, enabling the DBA team to adopt a more proactive approach for managing databases and applications.
The BBC now has the flexibility to scale MySQL on-demand, by adding more cluster nodes, thus ensuring sustainable performance of the organisation’s broadcasting services, in line with the requirements of increasing data loads. This allows producers to constantly expand on the content they create.