MySQL Cluster 7.2 -- Unlimited Possibilities

We've recently seen some great announcements of MySQL Cluster delivering amazing results for both selects and updates. The posts (see related articles below) are full of juicy technical details and proofs, but today I'd like to change the perspective a bit. Let's compare those figures with real-world data and imagine what could be done. Please note that I'm not using any scientific method here, just dreaming about the unlimited opportunities offered by MySQL Cluster today.

MySQL Cluster 7.2.7 -- 1B+ Writes per Minute

Cluster can deliver 1B+ selects per minute with 8 nodes and 1B+ updates per minute with 30 nodes.

Our planet is getting quite populated and interconnected. World population is 7B+ and 2B+ of us are using internet. Let's assume that, due to time-zones, only 1/3 of the total internet population is online at a given time (700M+) and that a single action generates one update and one select on the database.

What kind of services can we offer then?

With such scalability and performance, MySQL Cluster offers endless opportunities to develop something new that can support the exponential growth of the web and offer always-on services to everyone, for example:

• Hellos from the world -- a website where everyone can say hello to the world, whenever they want. MySQL Cluster can handle the entire online population in less than 1 minute;
• Let's shop together -- a global eCommerce website selling everything with 100% market share. If everyone would buy an item per minute, MySQL Cluster could easily fulfill the needs of the entire internet population with 30 nodes;
• Like everything you like -- a like button that can be attached to everything in order to collect statistics on users' favorite things. MySQL Cluster could easily sustain the total online world assuming they'd like 1 thing per minute;

Furthermore, MySQL Cluster could handle updates from all of Zynga's 60M active daily users in 3 seconds or all of Facebook's 900M+ active users in less than a minute. All of that giving you ACID compliance and synchronous replication to ensure no data loss.

The Oracle MySQL engineering team did a great job with Cluster: let's build the next big thing with it!

Related articles

• Where would I use MySQL Cluster?
• MySQL Cluster 7.2.7 achieves 1BN update transactions per minute
• 1 Billion Queries Per Minute - MySQL Cluster 7.2 is GA!
• Challenges in reaching 1BN reads and updates per minute for MySQL Cluster 7.2

2011, A great year for MySQL in review...

I see so many posts on what happened to company X, product Y and dream Z that I couldn't resist the temptation to summarize this great year for MySQL. At the end of 2010, Oracle did an announcement we were all waiting for: MySQL 5.5 is GA! Another year has passed since then and it's time to reflect on what has been done.

I know this is a long post. I tried to rewrite it at least 10 times to make it shorter, but I couldn't condense the list. Hence, I wrote a summary in the beginning for those who don't want to read it all.

I believe that 2011 was an exceptional year for MySQL and I really enjoy being part of this team. I wish all of us a lot of success and fun in the years to come!

Summary:
Oracle released many MySQL 5.6 and MySQL Cluster 7.2 DMRs accompanied by new versions of MySQL Enterprise Monitor, MySQL Enterprise Backup, MySQL Workbench (and utilities), MySQL Proxy, MySQL Cluster Manager and Connectors.

The MySQL team unveiled new products like the MySQL Installer for Windows and Oracle VM Templates for MySQL. Besides, the MySQL Enterprise offering has been enriched with new commercial extensions. MySQL can now be leveraged as one of the Oracle data management solutions with new certifications and the integration with My Oracle Support increased the business value of customers' investment on Oracle technologies.

Additionally MySQL presented at major events across the world and won a few awards.

Upcoming Webinar: Scaling Web Services with MySQL Cluster (IT)

On the 9th of September at 10am CET I will present in Italian a Webinar titled: "Scaling Web Services with MySQL Cluster". You can register here.

This is a summary of the english webinar series in two parts that are now available on-demand:

• Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached
• Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine

Content

There are two common choices to power web applications: MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web. The MEMORY storage engine has been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management.

However if you have web services that are update-intensive, demanding real-time responsiveness and continuous availability or if your services evolve to support more users, the scalability and availability demands can start to exceed the capabilities of these two approaches.

The MySQL Cluster datbase, which itself can be implemented as a MySQL storage engine, is a viable alternative to address increased web service demands. MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency, higher levels of scalability and database functionality and 99.999% availability.

This webinar will discuss the use-cases for all three approaches, and provide an insight into how MySQL Cluster is enabling users to scale their update-intensive web services.

When

• Thursday, September 9, 2010: 10:00 CET

EAVB_NEYWAQLUNW