Monday May 11, 2015

Starting and Stopping a Cluster with MySQL Cluster Manager

MySQL Cluster Manager makes ti easy to start and stop an entire cluster. You can reconfigure all data nodes in the cluster with a single command that not only changes the setting but also restarts each node in turn without bringing down the cluster.

To learn more about MySQL Cluster and MySQL Cluster Manager take the MySQL Cluster training course. You can take this 4-day instructor-led course as a:

  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events on the schedule to suit different time zones. Events on the schedule include 23 and 30 June, 11 August, 29 September, 13 October 2015.
  • In-Class Event: Travel to an education center to attend an event. Events already on the schedule include:

 Location  Date  Delivery Language
Sao Paulo, Brazil 8 June 2015 Brazilian Portuguese
Jakarta, Indonesia 29 June 2015 English
Mexico City, Mexico 15 June 2015 Spanish
Singapore 11 August 2015 English
Bangkok, Thailand 12 October 2015 English
To register for an event or learn more about the authentic MySQL curriculum, go to

Friday May 01, 2015

Oracle Enterprise Manager for MySQL v2 Is Now Available!

[Read More]

Tuesday Jul 17, 2012

MySQL Cluster Powers El Chavo from Playful Play, Latin America’s Most Popular Facebook Game


Attracting over 3m subscribers in just 6 months and growing by 30,000 new users per day, Playful Play needed a database that was able to keep pace with the massive scalability and high availability demands of the wildly successful La Vecindad de El Chavo Facebook game.

Playful Play selected MySQL Cluster CGE running on a public cloud to power their gaming platform, providing:

  • 45% improvement in performance;
  • 99.999% uptime;
  • 80% reduction in DBA overhead;
  • Local language support, 24x7.

As a result, Playful Play has been able to maintain user growth rates and attract new advertisers to the platform, while enhancing agility and reducing cost.

Company Overview

Based out of Monterrey, Mexico, Playful Play has created Latin America’s #1 Facebook game based on "El Chavo del 8", the cultural and TV phenomenon that has been running across Latin America for the past four decades. The show is also extremely popular in Spain and the United States.

El Chavo (The Kid) appeals to a broad demographic, having attracted over 3M subscribers in its first 6 months, and adding 30,000 new users per day. The game has also proved popular with advertisers who are keen to integrate social gaming into their marketing strategies in order to raise awareness and build brand loyalty.

Through partnerships with Televisa Home Entertainment and Grupo Chespirito, Playful Play has aggressive plans to grow their business through the development of new social games targeting Latin America, Brazil, the United States and Spain.

The Challenges of Rapid Growth

As a start-up business, fast time to market at the lowest possible case was the leading development priority after Playful Play secured the rights to develop the El Chavo game.

As a result, Playful Play developed the first release of the game on the proven LAMP (Linux, Apache, MySQL, PHP / Perl / Python) stack.

To meet both the scalability and availability requirements of the game, Playful Play initially deployed MySQL in a replicated, multi-master configuration.

The database is core to the game, responsible for managing:

  • User profiles and avatars
  • Gaming session data;
  • In-app (application) purchases;
  • Advertising and digital marketing event data.

As La Vecidad de El Chavo spread virally across Facebook, subscriptions rapidly exceeded one million users, leading Playful Play to consider how to best architect their gaming platforms for long-term growth. They had heard about the release of MySQL Cluster 7.2, and so decided to initiate an evaluation to determine if it could meet their requirements.

The Route to Internet-Scale with MySQL Cluster

In addition to growing user volumes, the El Chavo game also added new features that changed the profile of the database. Operations became more write-intensive, with INSERTs and UPDATEs accounting for up to 70% of the database load.

The game’s popularity also attracted advertisers, who demanded strict SLAs for both performance (predictable throughput with low latency) as well as uptime.

Through their evaluation, the developers at Playful Play identified that MySQL Cluster was able to meet their needs.

Write Performance with Real-Time Responsiveness

MySQL Cluster’s multi-master architecture, coupled with the ability to auto-shard (partition) tables across nodes, enabled Playful Play to meet the performance and scalability demands of the El Chavo game, without changes to their applications.

The ability to store data in memory and persist to disk delivered the sub-millisecond responsiveness and durability demanded by the game’s users.

In addition, Playful Play was able to horizontally scale the database across low-cost commodity nodes running in the cloud, reducing their TCO and enhancing agility.

Continuous Availability

The shared-nothing, distributed design of MySQL Cluster coupled with integrated replication and self-healing recovery ensured high availability of the gaming platform, without DevOps intervention.

MySQL Cluster was able to protect against downtime resulting from both failures and planned upgrades. For example, Playful Play has been able to scale the cluster on-line to support growing user volumes, without service interruption.

Data Integrity Supporting Monetization

As the game evolved to support in-app purchases and digital marketing, the ACID-compliance offered by MySQL Cluster afforded the transactional integrity demanded by users and advertisers.

The Value of MySQL Cluster Consulting, Support and Management Tools

Following their successful evaluation, Playful Play deployed MySQL Cluster with their public cloud provider.

Playful Play wanted to ensure they were getting the most out of the deployment, so Oracle’s MySQL consulting team reviewed their Architecture and Design. The consultants were able to further optimize the database to deliver even higher levels of performance, and demonstrated how Playful Play could automatically scale the database using MySQL Cluster Manager.

The MySQL Cluster deployment at Playful Play is growing rapidly, and currently comprised of over 25 nodes running Linux on commodity x86 servers, each configured with 24-cores and 64GB of RAM:

  • 12 x MySQL Cluster data nodes;
  • 12 x MySQL Server SQL nodes;
  • 2 x MySQL Cluster management nodes.

Each data and SQL node is co-located to a single physical instance.

 Playful Play Deployment Architecture, built for rapid scale

Using the architecture above, MySQL Cluster is currently supporting:

  • 3 million subscribers, with 30,000 new additions per day across Latin America, Europe and U.S;
  • 10,000 concurrent users;
  • 10,000 Transactions Per Second;
  • 99.999% uptime.

"The MySQL support service has been essential in helping us for troubleshooting and giving recommendations for the production cluster, Thanks" Carlos Morales – DBA, México

Playful Play has deployed MySQL Cluster Carrier-Grade Edition, providing access to technical and consultative support, in addition to the MySQL Enterprise Monitor and MySQL Cluster Manager tools.

MySQL Enterprise Monitor Enables Continuous Service Availability

MySQL Enterprise Monitor enables Playful Play to proactively monitor the entire cluster from a single GUI. DBAs are automatically notified if any environment variables begin to exceed pre-defined thresholds, and presented with the instructions necessary to take corrective action, before users are impacted.

MySQL Cluster Manager is used to automate cluster configuration changes, eliminating the risk of manual errors and significantly enhancing DevOps productivity.

The subscription has delivered terrific value to Playful Play, enabling them to:

  • Improve performance by 45% while reducing CPU utilization by 35%, providing significant headroom for continued growth;
  • Reduced DBA overhead by 80%, providing substantial cost savings;
  • Access to local language support, 24x7.

The Future with MySQL Cluster

Playful Play has aggressive growth plans, seeking to attract over 50M subscribers within 5 years. El Chavo del 8 is continuing to gain widespread popularity in Latin regions around the world, and will be joined by other social networking games currently in development. The next major target is Brazil, presenting a very attractive, emerging market in social gaming.

MySQL Cluster CGE has been selected as the database platform powering this growth.

Playful Play will be presenting their experiences and best practices with MySQL Cluster at the MySQL Connect conference, September 29th and 30th 2012 in San Francisco.

Further Resources

MySQL Cluster at Playful Play On-Demand Webinar (Spanish)

MySQL Cluster Demonstration

Guide to Scaling Web Databases with MySQL Cluster

Monday Jul 18, 2011

Simpler and Safer Clustering: MySQL Cluster Manager Update

Clustered computing brings with it many benefits: high performance, high availability, scalable infrastructure, etc. But it also brings with it more complexity.


Well, by its very nature, there are more “moving parts” to monitor and manage (from physical, virtual and logical hosts) to clustering software to redundant networking components – the list goes on. And a cluster that isn’t effectively provisioned and managed will cause more downtime than the standalone systems it is designed to improve upon.

When it comes to the database industry, analysts already estimate that 50% of a typical database’s Total Cost of Ownership is attributable to staffing and downtime costs. These costs will only increase if a database cluster is not effectively monitored and managed.

Monitoring and management has been a major focus in the development of the MySQL Cluster database, and as part of this focus, the latest release of MySQL Cluster Manager (MCM) hit General Availability last week. You can read all about it in Andrew Morgan's blog.

MySQL Cluster Manager 1.1.1 makes it much simpler to get up and running, to manage the cluster and to allow multiple clusters to be managed from a single process.

MySQL Cluster Manager is part of the commercial Carrier-Grade Edition but anyone is free to download and use MySQL Cluster Manager without obligation for 30 days. This is a great way for those new to MySQL Cluster to rapidly configure and provision their first cluster.

All you need do is:

1. Go to Oracle eDelivery

2. Enter some basic details and click through the agreement

3. Select “MySQL Product Pack”, then your platform, then Go

Not only does MCM make the management of MySQL Cluster simpler, it also makes it safer. One of the largest causes of downtime is administrator error, and here MySQL Cluster Manager can significantly reduce risk.

Consider the task of upgrading rom one release of MySQL Cluster to another. This can be performed as an on-line operation, using rolling restarts to apply upgrades while still serving read and write requests. Its just one of the many operations users can perform on line (ie adding data nodes, upgrading schema, backups, etc) all of which enable MySQL Cluster to achieve 99.999% uptime.

Using a manual upgrade method on a cluster configured with 4 x data nodes, 2 x MySQL Server application nodes and 2 x management nodes, the administrator would be typing 46 x manual commands in an operation that would take around 2 ½ hours to complete. The steps are shown below:

1 x preliminary check of cluster state

8 x ssh commands per server

8 x per-process stop commands

4 x scp of configuration files (2 x mgmd & 2 x mysqld)

8 x per-process start commands

8 x checks for started and re-joined processes

8 x process completion verifications

1 x verify completion of the whole cluster.

Excludes manual editing of each configuration file.

Now compare this to using MySQL Cluster Manager:

upgrade cluster --package=7.1 mycluster;

Just 1 command and walk away and leave it.

Note – both of the processes above exclude the preparation steps of copying the new software package to each host and defining where it's located. The total operation times are based on a DBA restarting 4 x MySQL Cluster Data Nodes, each with 6GB of data, and performing 10,000 operations per second.

You can learn more about MySQL Cluster Manager from our new whitepaper and on-line demo.

We also have an on-demand webinar which covers MySQL Cluster Manager as well as other complimentary methods to managing a MySQL Cluster environment:

* NDBINFO: released with MySQL Cluster 7.1, NDBINFO presents real-time status and usage statistics, providing developers and DBAs with a simple means of pro-actively monitoring and optimizing database performance and availability.

* MySQL Cluster Advisors & Graphs: part of the MySQL Enterprise Monitor and available in the commercial MySQL Cluster Carrier Grade Edition, the Enterprise Advisor includes automated best practice rules that alert on key performance and availability metrics from MySQL Cluster data nodes.

While managing clusters will never be easy, it keeps getting a whole lot simpler !

Thursday Aug 12, 2010

The MySQL Community Team is hiring!

MySQL community

Oracle investment in MySQL is growing, and so is our emphasis on community presence, participation, and leadership. We need now your help. Our team at Oracle needs to grow in order to support community better, and we are starting by filling the position for MySQL community manager in a place with a significantly large MySQL user base: North America.

Here we are again, with a fresh recruitment offer, for a MySQL Community Manager for North America. Please visit this link for the full req.

In the meantime, here is, in short, what we are looking for: We need a passionate MySQL lover, with a strong technical experience, and a recognized ability to get along with physical and virtual crowds. We also need someone who can speak in public confidently and has no objections to travel locally and abroad.

The job of a community manager is a powerful blend of a geek, a social media wizard, and a public speaker. I put the geek personality first, because leading by example is an important feature of this job.

If you want to apply, be aware that you will have fierce competition and we will subject you to tough scrutiny. If that doesn't scare you, Please go ahead and apply!

Good luck!


Get the latest updates on products, technology, news, events, webcasts, customers and more.




« October 2015