Table of Contents
MySQL Services Case Study
Serving a global restaurant business with the latest information across sites and MySQL environments using multi-master replication.
Databases are behind one of the most valuable business assets: knowledge.
Being able to share current data between different sites swiftly and seamlessly offers real competitive advantage.
Working in partnership with Cloud specialist, Niu Solutions, and other third-party vendors, WellData was asked to support a global fast food company with MySQL services to enable greater data visibility.
Our client wanted to keep data information in sync as it was updated in separate places.
The group of IT infrastructure environments spanned eight sites, including three main data centres in the UK, US and India, where development and testing would take place.
This was an important and pressing project for our client, requiring a new, fully operational system within six months.
Solution
We proposed developing, piloting and then deploying a cluster and multi-master replication system across a total of 32 MySQL servers.
This cost-efficient MySQL services solution would enable our client to make central updates, with each master database server replicating the databases it hosts in a set pattern.
By propagating data updates across clusters, the latest information would be visible to all members of the infrastructure group immediately.
Throughout the pilot and full deployment stages, this solution also involved supporting with Linux and Apache Tomcat, an open-source servlet container providing an environment for Java code to run.
Outcome
Our client now has a stable, resilient and expanded platform for improved business performance and growth.
Download the full MySQL Case Study
MySQL Services at WellData
We provide MySQL services through our database managed services at a fixed price; no onboarding fees, no small print.
Systems can be rolled on and off the contract at any time during the term of the contract, flexing as your business needs change.
WellData offers MySQL services for constant proactive MySQL database support.
This service covers all your database’s business-as-usual (BAU) requirements on an ongoing basis.
We’re also able to provide a complete support package for not only your MySQL database, but also the full range of popular databases and servers, including MariaDB, PostgreSQL, Linux, Unix, Oracle, and SQL Server.
Our MySQL services are based on a fixed-price concept and include, where needed, out-of-hours technical cover for your critical production systems.
Once you have selected the level of support and cover you need, you’ll never have to worry about resourcing BAU support again.
