Skip the navigation
News

Twitter growth prompts switch from MySQL to 'NoSQL' database

Hopes open source technology can further boost improving Twitter uptime record

By Eric Lai
February 23, 2010 04:10 PM ET

Computerworld - Ryan King, an engineer at Twitter, today told the blog MyNoSQL that the social networking company plans to move from MySQL to the Cassandra database for what he called its resilience, scalability and large community of open-source developers.

"We have a lot of data, the growth factor in that data is huge and the rate of growth is accelerating," King said in the interview posted on MyNoSQL.

San Francisco-based Twitter currently uses a cluster of MySQL servers with a memcached caching system that "is quickly becoming prohibitively costly (in terms of manpower) to operate. We need a system that can grow in a more automated fashion and be highly available," King told MyNoSQL.

The number of daily tweets has grown more than twenty-fold in the past year, from about two million a day in January, 2009 to nearly 50 million a day last month.

That growth has caused pain, and some devoted users complain loudly whenever Twitter crashes and the so-called 'fail whale' appears.

Twitter has nevertheless improved its uptime significantly in the last 12 months. The site was up 99.72% (down 23 hours, 45 minutes) in the last 12 months, according to Web monitoring firm, Pingdom. In 2008, according to Pingdom, Twitter was down for 84 hours, worst of 15 major social networking sites.

Twitter hopes that deploying the Apache Software Foundation's Cassandra database will improve that record further.

First developed by Facebook to augment its MySQL installation, Cassandra is a lean Java-based data store, that shucks the overhead of conventional relational databases. The technology is similar to that offered in other emerging NoSQL databases like MapReduce and Hadoop,

For skilled programmers, the so-called NoSQL databases can boost performance and scalability, which has made them attractive to the consumer Web world.

Related Blogs

Like Facebook and Twitter, Digg is also moving from MySQL, the initial Web 2.0 darling, to Cassandra.

Cisco Systems Inc., hosting provider Rackspace and other firms also use Cassandra. The largest Cassandra instance in production runs 100TB of data using 150 servers, according to the project's web site.

The interview was cited in a tweet from King, who has 297,334 Twitter followers.

In the blog intervirew, King said that Twitter looked at a number of options for upgrading its system, including re-architecting MySQL so that it runs better in a cluster (called 'sharding'), and the offerings of several Cassandra NoSQL rivals such as HBase, Voldemort, MongoDB, MemCacheDB, Redis and HyperTable.

King said that test found that Cassandra was more scalable, reliable and easier to manage than the alternatives.

Twitter is "currently moving our largest (and most painful to maintain) table -- the statuses table, which contains all tweets and retweets" to Cassandra, he said. "After this we'll start putting some new projects on Cassandra and migrating other tables."

To minimize downtime during the migration, Twitter plans to implement new features by running them in Cassandra alongside MySQL in case any bugs crop up. Once its determined there are no bugs, Twitter will back up MySQL data and then export it to Cassandra in a process that would take about a week, he said.

Only after more testing, will it turn Cassandra on for production and shut down MySQL.

"Our process for rolling out new major infrastructure can be summed up as 'integrate first, then iterate,' King said.

Eric Lai covers Windows and Linux, desktop applications, databases and business intelligence for Computerworld. Follow Eric on Twitter at Twitter@ericylai, send e-mail to elai@computerworld.com or subscribe to Eric's RSS feed Lai RSS.

Read more about Databases in Computerworld's Databases Topic Center.



Additional Resources
Forrester Consulting - Optimizing Users and Applications in a Mobile World
WHITE PAPER
Solving application issues over the WAN requires careful consideration. Based on their independent research, Forrester Consulting offers recommendations on how to tackle application performance issues, insufficient bandwidth and the inability to quickly restore users in a disaster.

Read now.

Security KnowledgeVault
WHITE PAPER
Security is not an option. This KnowledgeVault Series offers professional advice how to be proactive in the fight against cybercrimes and multi-layered security threats; how to adopt a holistic approach to protecting and managing data; and how to hire a qualified security assessor. Make security your Number 1 priority.

Read now.

Cut Communications Costs Once and for All
WHITE PAPER
New IP-based communications systems are being deployed by small and midsized businesses at a rapid rate. Learn how these organizations are enabling faster responsiveness, creating better customer experiences, speeding office or mobile interactions, and dramatically reducing existing communications costs.

Read now.

Databases White Papers
HP Advanced Information Services for SAP In-Memory Appliance (SAP HANA)
Organizations are eager to connect the vast amounts of data available within and outside their businesses to compete more effectively and make better...
Galliker builds next-generation Cisco data center
Originally Galliker Transport AG only intended to upgrade its bandwidth to 10 gigabit per second in the core network of the data center...
Oracle TimesTen In-Memory Database on Oracle Exalogic Elastic Cloud
This white paper describes configuration considerations, best practices and performance results of TimesTen running on Exalogic.
Overcome Top 7 Admin Challenges of Active Directory
As Active Directory's role in the enterprise has drastically increased, so has the need to secure the data. Gain insight on creating repeatable,...
Insiders Can Ruin Your Company. Take Action.
Did you know that 80 percent of threats to an organization come from the inside? The threat from insiders is often overlooked in...
All Databases White Papers
Databases Webcasts
Oracle Database Appliance - Simplifying your High Availability Database
Date: February 29, 2012
Time: 1:00 PM EST

Seasoned IT managers know from experience that in many cases the bulk of the cost of an...
Optimizing Networks for the Cloud
Join guest speaker, Rohit Mehra, IDC Director of Enterprise Communications Infrastructure, to explore current trends, discuss best practices for optimizing Data Center and...
Apps QuickStart Series Part 2: Designing and Deploying SQL Server on VMware vSphere
Download this webcast to learn about the design considerations for virtualizing SQL workloads, performance and scalability information and high-availability options, as well as...
Apps QuickStart Series Part 1: Designing and Deploying Exchange 2010 on VMware vSphere
Download this webcast to learn the virtual hardware design considerations for Exchange 2010, deployment using the building block approach, options for high-availability and...
Customer Spotlight: How IPC The Hospitalist Company Implemented Oracle on VMware
Have you been looking to hear about customer's experiences with the new VMware vCenter Site Recovery Manager product? View this webcast to learn...
All Databases Webcasts
Newsletter Sign-Up

Receive the latest news test, reviews and trends on your favorite technology topics

Choose a newsletter
  1. View all newsletters | Privacy Policy
IT Jobs