Hot data for a global fast food chain

By Chris
6th June 2018

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 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 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 here…

Gated Download

 

 

By completing this form you consent to receiving further relevant content from WellData. We will never share your details with third parties. Further information can be found on our privacy policy

 

Want to find out more? Get in touch…

 

Get in touch

 

Liked what you’ve seen? Share with colleagues and friends…

Share

<< Back to blogs

Here's what other people think

Andy Cole
Andy Cole
11:45 06 Nov 18
Really know their stuff and their response times are very good.
Steve Fenton
Steve Fenton
10:56 05 Nov 18
Our partnership with WellData has enabled us to resolve critical database problems. Their attitude and service makes them a natural extension to our own technology team, which extends our capability in a critical area of our business.read more
John Lynes
John Lynes
14:00 04 Oct 17
Having worked with the team at Welldata for approaching 17 years, my company and I have always found them professional, reliable and generally a great firm to work with.read more
Stefan Parrott
Stefan Parrott
13:12 19 Sep 17
WellData provide an excellent level of support and their team are very knowledgeable and always go the extra mile. I would wholeheartedly recommend them.read more