How to build a multi-region, multi-master MySQL cloud database back-end capable of serving a global high volume cloud contact center

This global SaaS provider is a Cloud Contact Center solution provider (the leading Salesforce telephony solution), who needed to deliver up-to-date data to clients as quickly as possible. Its cloud-based call center software frees users to make every conversation personal; it supports the creation of exceptional customer experiences that help serve better and sell more. Its technology is 100% cloud-based and device-agnostic for telephony infrastructure.

What is the Challenge?

Active/Active (multi-master) MySQL clustering is needed when there is significant update load on geographically distributed applications. These require fast response times both for updates and reads, and they also need to share data on a global scale.

• Regional distribution of data
• Deliver …

How to serve global IoT customers in the cloud – and secure SaaS revenue using Tungsten Clustering on cloud-based database services

SaaS providers typically rely on providing a quality service across multiple locations, with the best application and database availability. They tend to be growth-oriented and need to ensure that their business will always be available without having to worry about how their databases will achieve continuous operations.

Our customer for this use case is a global SaaS provider with an open data exchange platform for the Internet of Things (IoT) that has customers all over the globe.

This use case looks at how our customer migrated from a single region Amazon RDS deployment to a truly global, geo-distributed multi-master Tungsten Clustering database solution – a better, more scalable solution at a lower total cost. And how they did so without having to change their application, all the …

How to achieve MySQL high availability, data protection & disaster recovery

This MySQL high availability and disaster recovery use case is based on a customer of ours who is a government-regulated lottery service consisting of a number of games of chance. Its mission is to fuel imagination – and fund education for all citizens of their state as it uses the proceeds of its activities to do so. Through its games, it has provided billions of dollars in scholarship and other such education funding for several decades.

What is the Challenge?

As is common for gambling and betting organisations, our customer faced a number of challenges and needed to have a solid infrastructure in place in order to provide its services satisfactorily.

This includes:

• Ensuring 24/7/365 availability of its online gaming platform
• Handling thousands of transactions quickly and while ensuring zero downtime …

Thanks to everyone who joined us last week for this webinar hosted by Database Trends & Technologies (DBTA) and presented by Continuent CEO Eero Teerikorpi. The replay is now available to watch:

How to build a $10M SaaS business into a $6B Unicorn with MySQL and Continuent Tungsten

In this webinar, Eero walks us through the 10-year story of a marketing analytics SaaS, which grew with help from MySQL and Continuent from $10M to be a $6B behemoth: a real SaaS unicorn; and covers a number of related use cases also.

SaaS has emerged as the best way to deliver software, and SaaS solutions, at their best, …

In this fourth post in our MySQL Use Case Blog Series we look at a customer of ours who was able to grow their Saas business from tens of customers initially to thousands of enterprise customers once they achieved continuous MySQL operations with Continuent Tungsten.

This particular customer, based in California, develops and sells automation software for account-based marketing as well as other marketing services and products such as SEO and content marketing. They provide solutions tailored for large enterprises and fast-growing, small businesses alike covering all industry types from technology all the way to higher education.

So how did this fast growing marketing automation SaaS provider scale from tens of customers to thousands of enterprise customers using Tungsten Clustering (currently with 600+ MySQL instances)?

The Challenge

SaaS and other web applications are inherently 24/7/365 operations, thus they …

In my recent travels, I’ve been speaking with database users at various meetups and trade shows worldwide. Very often, I got questions centering around the best use cases for our products, be it TokuDB, our MySQL storage engine, or, TokuMX, our distribution of MongoDB. Over 90% of the time, I responded Cloud, Big Data or both. You see, in the software industry we’re like kindergartners, we like things to fit into neat categories. If you know any software sales people, you’ll recognize this as a fitting analogy (at least in terms of energy and attention span), but I digress. This strategy helps allocate resources where they are most likely to make an impact, and, thus, optimize our return on investment. In this blog series, I’m going to go slightly against the grain and explain why the Fractal Tree makes databases work in these environments.

Before I get into more detail, let me …

Yesterday, I had the pleasure of meeting with Per-Ola Sjöswärd, executive IT strategist at the Swedish National Police. That organisation is already way ahead of most of us when it comes to Open Source adoption. But they have higher ambitions still.

The Rikspolisstyrelsen logotype is on many Sun slides, as an example of an “Enterprise 2.0″ type MySQL customer. Besides sounding cool, the ”Enterprise 2.0″ name is supposed to portray what all the organisations in that group have in common: They’re generic enterprises in any industry, and they use the same internal IT architecture as Web 2.0 companies use externally.

The Swedish Police, to be specific, doesn’t use just Web apps internally. But still, we’re talking about a 70% share. The other 30% are based on the Java Swing architecture, so it’s still …

MySQL 5.1 is here! It’s announced! And it’s time for the overall winner, Position 1 in the MySQL 5.1 Use Case Competition.

1. Greg Haase (Lotame Solutions Inc., Elkridge, Maryland, USA): Using Partitioning and Event Scheduler to Prune Archive Tables. See Greg’s DevZone article, and his blog.

Thanks and congratulations, Greg! I absolutely hope you are in a position to take advantage of your free MySQL Conference & Expo 2009 Pass, including a dinner with MySQL …

The GA announcement of MySQL 5.1 is coming, and for downloading, it’s already available, as I hope you have noticed from Giuseppe’s blog. We continue our preparations, this time by announcing Position 2 in the MySQL 5.1 Use Case Competition.

2. Guy Adams (Parallel Ltd., Milton Keynes, United Kingdom): Using Partitioning to Manage Satellite Networks. See Guy’s DevZone article.

Thanks and congratulations, Guy! I hope you too are in a position to take advantage of your free MySQL Conference & Expo 2009 Pass, including a …

The GA announcement of MySQL 5.1 is getting closer by the minute! So it’s time for Position 3 in the MySQL 5.1 Use Case Competition.

3. Corrado Pandiani (Football Club Internazionale Milano Spa, Milan, Italy): Using Partitioning and Event Scheduler for online logging & real-time stats. See Corrado’s DevZone article, and his blog.

Thanks and congratulations, Corrado! I hope you are in a position to take advantage of your free MySQL Conference & Expo 2009 Pass, including a dinner with MySQL co-founder …