Open Source

How a Facebook Game Use MySQL Cluster CGE to Its Advantage

 

The La Vecindad de El Chavo Facebook game.

Playful Play is a Latin American company that provides video games for social networks.  The Mexican company works with a talented team of programmers to come up with games that you can play on Facebook and other social networks.  It is by no accident that the company aims to develop the world’s addictive games.

For a company that was founded only in 2011, Playful Play is a success story.  By July 2012, they have already racked up more than 3 million subscribers in the previous six months – and their users grew daily. In a short time, it became apparent that to cope with the influx of users to their service, the company required a new platform would be able to handle all the demands.

[expand title=”Click here to read more about this article”]

The problems and challenges

One of their Facebook games, La Vecindad de El Chavo, is credited with their success.  And it was taking a toll on their systems.  The game is based on a TV program aired in Latin America for around 40 years, with its popularity crossing borders right through Spain and the US.  The game also had a wide target market, appealing to everyone from kids, the youth and adults.  More than the daily users, the game also attracted advertisers who wanted to use the game for their own marketing strategies to build loyalty to their brands or just raise brand awareness.  Plus, the company planned to do more, introducing more games in the future that are targeted to Latin Americans, Brazilians and even people in the US and Spain.

But even with El Chavo the company was already feeling the strain.  They were using MySQL through a replicated setup to handle:

  • User avatars and profiles
  • Data on game sessions
  • In-app purchases
  • Advertising event data

The game became viral and soon had more than 1,000,000 users in a very short time, forcing the company to see how to architect their games and platforms so that it would be able to meet the demands in the long term.  They chose MySQL Cluster (version 7.2) for the task of achieving availability and scalability requirements of the game.

Other challenges that the company faced:

  1. New features meant changing the database profile.  The company’s operations are now increasingly more robust – primarily on UPDATEs and INSERTs of new data.
  2. Advertisers have demanded strict service level agreements, calling for low latency, predictable throughput and availability.

The solution – apply MySQL Cluster

MySQL Cluster helped Playful Play solve their problems.  It has the capability to automatically manage tables across different nodes.  This gave the company top performance and high scalability without having to change their application.  It also allowed their applications to respond in a fraction of a millisecond.  The company was also able to lower their expenses because they can now scale using economical commodity hardware that are based on the cloud.  This also made them more agile.

But more importantly, MySQL Cluster works on a distributed architecture and is able to replicate and recover when something fails.  This ensured that the game was always available, helping the company live up to its promises to its users and advertisers.  Even during planned upgrades, the game was available because with MySQL Cluster, you can update even without powering down your database.  MySQL is also ACID compliant, which comes in handy for online transactions.

Source: Oracle[/expand]

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Business Intelligence Blog

How Brand Names Survive in…

  The age of digital marketplace has made it possible for unknown and smaller companies to compete with better-known and well-established brands. Take for example...

Keep Reading

Artificial Intelligence

The Phenomenon That Is Artificial…

  Artificial intelligence is when a machine does cognitive functions that are more associated with humans, such as thinking, learning, problem solving, and reasoning. As...

Keep Reading

Cloud

Digital Transformation in Banking: Shift…

  The start of a new decade is already shaping up to be exciting for financial services, especially for banks as they continue to compete...

Keep Reading

Business Intelligence Blog

Data Science and Its Economic…

It would seem that artificial intelligence is the focus of businesses that are looking to future proof their organizations and stay competitive. And why not?...

Keep Reading

Data Blog

Ensure Efficient Data Science and…

In an ever-expanding landscape called Internet of Things and the exploding development of artificial intelligence, we are bombarded with complex methods of integrating data science...

Keep Reading

Business Intelligence Blog

Cybersecurity: The Top 5 Expectations…

  If you think about it, cybersecurity is closely tied to human rights, privacy, freedom, and even basic safety. As a whole, we have become...

Keep Reading

Business Intelligence Blog

Tech Security Should Be Easy…

  IT professionals know that tech security is important in everything that they do. And that there are a lot of products, tools, innovations, and...

Keep Reading

Business Intelligence Blog

The Top 6 Success Stories…

Nearly nine out of 10 digital transformation initiatives fail. Digital transformation projects fail for a variety of reasons. It can be because of a lack...

Keep Reading

Live Chat | Emergency