Jump to content

Apache Cassandra: Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous editNext edit →
Content deleted Content added
VisualWikitext
Included reference to Toad for Cloud Databases third-party data tool
Slebresne (talk | contribs)
48 edits
mNo edit summary
Line 8: Line 8:
| released = 2008
| released = 2008
| status = Active
| status = Active
| latest release version = 1.1.3
| latest release version = 1.1.5
| latest release date = {{release date|2012|08|05}}
| latest release date = {{release date|2012|09|10}}
| frequently updated = yes
| frequently updated = yes
| programming language = [[Java (programming language)|Java]]
| programming language = [[Java (programming language)|Java]]

Revision as of 18:19, 10 September 2012

Apache Cassandra
Original author(s)Avinash Lakshman, Prashant Malik
Developer(s)Apache Software Foundation
Initial release2008
Stable release
1.1.5 / September 10, 2012 (2012-09-10)
Repository
Written inJava
Operating systemCross-platform
Available inEnglish
Typekey-value store
LicenseApache License 2
Websitecassandra.apache.org

Apache Cassandra is an open source distributed database management system. It is an Apache Software Foundation top-level project[1] designed to handle very large amounts of data spread out across many commodity servers while providing a highly available service with no single point of failure. It is a NoSQL solution that was initially developed by Facebook and powered their Inbox Search feature until late 2010.[2][3] Jeff Hammerbacher, who led the Facebook Data team at the time, has described Cassandra as a BigTable data model running on an Amazon Dynamo-like infrastructure.[4]

Cassandra provides a structured key-value store with tunable consistency.[5] Keys map to multiple values, which are grouped into column families. The column families are fixed when a Cassandra database is created, but columns can be added to a family at any time. Furthermore, columns are added only to specified keys, so different keys can have different numbers of columns in any given family.

The values from a column family for each key are stored together. This makes Cassandra a hybrid data management system between a column-oriented DBMS and a row-oriented store.[6] Additional features include: using the BigTable way of modeling, eventual consistency, and the Gossip protocol, a master-master way of serving read and write requests inspired by Amazon's Dynamo.[7]

History

Apache Cassandra was developed at Facebook to power their Inbox Search feature by Avinash Lakshman (one of the authors of Amazon's Dynamo) and Prashant Malik. It was released as an open source project on Google code in July 2008.[4] In March 2009, it became an Apache Incubator project.[8] On February 17, 2010 it graduated to a top-level project.[1]

Facebook abandoned Cassandra in late 2010 when they built the Facebook Messaging platform on HBase.[3]

Licensing and support

Apache Cassandra is an Apache Software Foundation project, so it has an Apache License (version 2.0).

There are professional grade support available from a few companies. In the official wiki of Apache Cassandra's project[9] the following ones, which collaborate with developers to the project, are mentioned

Main features

Decentralized
Every node in the cluster has the same role. There is no single point of failure. Data is distributed across the cluster (so each node contains different data), but there is no master as every node can service any request.
Supports replication and multi data center replication
Replication strategies are configurable.[10] Cassandra is designed as a distributed system, for deployment of large numbers of nodes across multiple data centers. Key features of Cassandra’s distributed architecture are specifically tailored for multiple-data center deployment, for redundancy, for failover and disaster recovery.
Scalability
Read and write throughput both increase linearly as new machines are added, with no downtime or interruption to applications.
Fault-tolerant
Data is automatically replicated to multiple nodes for fault-tolerance. Replication across multiple data centers is supported. Failed nodes can be replaced with no downtime.
Tunable consistency
Writes and reads offer a tunable level of consistency, all the way from "writes never fail" to "block for all replicas to be readable", with the quorum level in the middle.
MapReduce support
Cassandra has Hadoop integration, with MapReduce support. There is support also for Apache Pig and Apache Hive.[11]
Query language
CQL (Cassandra Query Language) was introduced, an SQL-like alternative to the traditional RPC interface. Language drivers are available for Java (JDBC) and Python (DBAPI2).

Data model: keys, row keys, columns and column families

Cassandra is essentially a hybrid between a key-value and a row-oriented (or tabular) database.

Each key in Cassandra corresponds to a value which is an object. Each key has values as columns, and columns are grouped together into sets called column families. Also, each column families can be grouped in super column families.

So each key identifies a row of a variable number of elements. This column families could be considered then as tables. A table in Cassandra is a distributed multi dimensional map indexed by a key.

Furthermore, applications can specify the sort order of columns within a Super Column or Simple Column family.

Clustering

When the cluster for Apache Cassandra is designed, an important point is to select the right partitioner. Two partitioners exist:[12]

  1. RandomPartitioner (RP): This partitioner randomly distributes the key-value pairs over the network, resulting in a good load balancing. Compared to OPP, more nodes have to be accessed to get a number of keys.
  2. OrderPreservingPartitioner (OPP): This partitioner distributes the key-value pairs in a natural way so that similar keys are not far away. The advantage is that fewer nodes have to be accessed. The drawback is the uneven distribution of the key-value pairs.

Prominent users

  • Talentica Software uses Cassandra as a back-end for Analytics Application with Cassandra cluster of 30 nodes and inserting around 200GB data on daily basis.[13]
  • AppScale uses Cassandra as a back-end for Google App Engine applications[14]
  • Cisco's WebEx uses Cassandra to store user feed and activity in near real time.[15]
  • The CERN ATLAS experiment uses Cassandra to archive its online DAQ system's monitoring information[16]
  • Clearspring uses Cassandra "[keep] track of how many times a URL is shared and serves over 200M view requests daily."[17]
  • Cloudkick uses Cassandra to store the server metrics of their users.[18]
  • Cloudtalk's Platform contains APIs for users to create messaging apps with Cassandra as its data store.[19]
  • connex.io's database of user contacts is stored completely in a Cassandra cluster.[20]
  • Constant Contact uses Cassandra in their social media marketing application.[21]
  • Digg, a large social news website, announced on Sep 9th, 2009 that it is rolling out its use of Cassandra[22] and confirmed this on March 8, 2010.[23] TechCrunch has since linked Cassandra to Digg v4 reliability criticisms and recent company struggles.[24] Lead engineers at Digg later rebuked these criticisms as red herring and blamed a lack of load testing.[25]
  • Digital Reasoning's Synthesys application with potential scale to over a 400-node Cassandra database was rolled out in late 2010.[26]
  • Facebook used Cassandra to power Inbox Search, with over 200 nodes deployed.[2] This was abandoned in late 2010 when they built Facebook Messaging platform on HBase.[3]
  • IBM has done research in building a scalable email system based on Cassandra.[27]
  • Isidorey is the creator of Cloudsandra: a multi-tenant platform built on Brisk (Hadoop + Cassandra).[28]
  • Martini Media Network moved from MySQL to Cassandra.[29]
  • Mollom uses Cassandra to track reputations from IP data[30]
  • Netflix uses Cassandra as their back-end database for their streaming services[31][32]
  • Formspring uses Cassandra to count responses, as well as store Social Graph data (followers, following, blockers, blocking) for 26 Million accounts with 10 million responses a day[33]
  • Mahalo.com uses Cassandra to record user activity logs and topics for their Q&A website[34][35]
  • Ooyala Built a scalable, flexible, real-time analytics engine using Cassandra[36]
  • At Openwave, Cassandra acts as a distributed database and serves as a distributed storage mechanism for Openwave’s next generation messaging platform[37]
  • OpenX is running over 130 nodes on Cassandra for their OpenX Enterprise product to store and replicate advertisements and targeting data for ad delivery[38]
  • Outbrain uses Cassandra as a semi-persistent cache of recommendations.[39]
  • Plaxo has "reviewed 3 billion contacts in [their] database, compared them with publicly available data sources, and identified approximately 600 million unique people with contact info."[40]
  • PostRank uses Cassandra as their backend database[41]
  • Rackspace is known to use Cassandra internally.[42]
  • Reddit switched to Cassandra from memcacheDB on March 12, 2010[43] and experienced some problems with overload handling in Cassandra in May.[44]
  • RockYou uses Cassandra to record every single click for 50 million Monthly Active Users in real-time for their online games[45]
  • ShopSavvy uses Cassandra as their storage technology for their barcode scanning application[46]
  • SimpleGeo built a scalable geospatial database on top of Apache Cassandra[47]
  • SoundCloud uses Cassandra to store user account information[48]
  • Twitter announced it is planning to use Cassandra because it can be run on large server clusters and is capable of taking in very large amounts of data at a time.[49][50] Twitter continues to use it but not for Tweets themselves.[51]
  • Urban Airship uses Cassandra with the mobile service hosting for over 160 million application installs across 80 million unique devices[52]
  • Utillabs uses Cassandra for its Low Voltage Smart System for fine grained event / reading recording and analytics[53]
  • Walmart Labs (previously Kosmix) uses Cassandra with SSD[54]
  • Yakaz uses Cassandra on a five-node cluster to store millions of images as well as its social data.[55]
  • Viocom Hosting uses Cassandra for its email and smtp gateway called (SendCluster) for large volume senders. Storing from 40 million emails a day for email marketing. This is a private platform built with cassandra for large Email Senders[56]

Tools for Cassandra

Cassandra has built in tools for accessing Cassandra from the direct download such cassandra-cli and node-tool.

There are third party tools available, as the following[57]:

Data browsers

Administration tools

  • OpsCenter, OpsCenter is a tool for management and monitoring of a Cassandra cluster. The Community Edition of OpsCenter is free for anyone to download and use. There is also an Enterprise Edition of OpsCenter that includes additional features.
  • Cassandra Cluster Admin, Cassandra Cluster Admin is a GUI tool to help people administrate their Apache Cassandra cluster, similar to PHPMyAdmin for MySQL administration.

Client interfaces and language Support

Cassandra has a lot of high-level client libraries for Python, Java, .Net, Ruby, PHP, Perl, C++, etc.[58]

For a detailed list of client software go to "Client Options" article on Cassandra Wiki

Integration with other tools

There are other tools worth mentioning like Solandra,[59] a Cassandra backend for Apache Solr, a web application built around Lucene, for full text indexing and search.

For monitoring purposes Cassandra is well integrated with Ganglia[60] and there are plugins for other monitoring system as, by example, Nagios.

See also

References

  1. ^ a b "Cassandra is an Apache top level project". Mail-archive.com. 2010-02-18. Archived from the original on 28 March 2010. Retrieved 2010-03-29. {{cite web}}: Unknown parameter |deadurl= ignored (|url-status= suggested) (help)
  2. ^ a b "Niet compatibele browser". Facebook. Retrieved 2010-03-29.
  3. ^ a b c Kannan Muthukkaruppan. "The Underlying Technology of Messages".
  4. ^ a b James Hamilton (July 12, 2008). "Facebook Releases Cassandra as Open Source". Retrieved 2009-06-04.
  5. ^ http://www.cs.cornell.edu/projects/ladis2009/papers/lakshman-ladis2009.pdf
  6. ^ Vishal Shinde (2011-01-19). "Apache Cassandra". http://www.linuxquestions.in/: Linux Questions, Help, Howtos and Tutorials. Retrieved 2010-03-09. The values from a column family for each key are stored together, making Cassandra a hybrid between a column-oriented DBMS and a row-oriented store {{cite web}}: External link in |location= (help)
  7. ^ Olivier Mallassi (2010-06-09). "Let's play with Cassandra… (Part 1/3)". http://blog.octo.com/: OCTO Talks. Retrieved 2010-03-22. Hybrid firstly because Cassandra uses a column-oriented way of modeling data (inspired by the BigTable) and permit to use Hadoop Map/Reduce jobs and secondly because it uses patterns inspired by Dynamo like Eventually Consistent, Gossip protocols, a master-master way of serving both read and write requests… {{cite web}}: External link in |location= (help)
  8. ^ "Is this the new hotness now?". Mail-archive.com. 2009-03-02. Archived from the original on 25 April 2010. Retrieved 2010-03-29. {{cite web}}: Unknown parameter |deadurl= ignored (|url-status= suggested) (help)
  9. ^ "Third Party Support" article on Apache Cassandra's wiki
  10. ^ "Deploying Cassandra across Multiple Data Centers" article on Datastax Cassandra Developer Center
  11. ^ "Hadoop Support" article on Cassandra's wiki
  12. ^ Dominic Williams. "Cassandra: RandomPartitioner vs OrderPreservingPartitioner". http://wordpress.com/: WordPress.com. Retrieved 2011-03-23. When building a Cassandra cluster, the "key" question (sorry, that's weak) is whether to use the RandomPartitioner (RP), or the OrderPreservingPartitioner (OPP). These control how your data is distributed over your nodes. Once you have chosen your partitioner, you cannot change without wiping your data, so think carefully! The problem with OPP: If the distribution of keys used by individual column families is different, their sets of keys will not fall evenly across the ranges assigned to nodes. Thus nodes will end up storing preponderances of keys (and the associated data) corresponding to one column family or another. If as is likely column families store differing quantities of data with their keys, or store data accessed according to differing usage patterns, then some nodes will end up with disproportionately more data than others, or serving more "hot" data than others. {{cite web}}: External link in |location= (help); line feed character in |quote= at position 325 (help)
  13. ^ cite web|url=http://www.talentica.com
  14. ^ cite web|url=http://appscale.cs.ucsb.edu/datastores.html#cassandra
  15. ^ "Re: Cassandra users survey". Mail-archive.com. 2009-11-21. Archived from the original on 17 April 2010. Retrieved 2010-03-29. {{cite web}}: Unknown parameter |deadurl= ignored (|url-status= suggested) (help)
  16. ^ "A Persistent Back-End for the ATLAS Online Information Service (P-BEAST)".
  17. ^ Matt Abrams (2011-05-05). "Clearsprings Big Data Architecture Part 1".
  18. ^ https://www.cloudkick.com/blog/2010/mar/02/4_months_with_cassandra/
  19. ^ http://cloudtalk.com/the-cloudtalk-platform.html
  20. ^ http://blog.connex.io/why-we-replaced-syncml-with-our-own-contact-s
  21. ^ Klint Finley (2011-02-18). "This Week in Consolidation: HP Buys Vertica, Constant Contact Buys Bantam Live and More". Read Write Enterprise.
  22. ^ Ian Eure. "Looking to the future with Cassandra".
  23. ^ John Quinn. "Saying Yes to NoSQL; Going Steady with Cassandra".
  24. ^ Erick Schonfeld. "As Digg Struggles, VP Of Engineering Is Shown The Door".
  25. ^ "Is Cassandra to Blame for Digg v4's Failures?".
  26. ^ http://www.datastax.com/wp-content/uploads/2011/03/CS-DigitalReasoning.pdf
  27. ^ "Powered by Google Docs" (PDF). Docs.google.com. Retrieved 2010-03-29.
  28. ^ http://www.cloudsandra.com/
  29. ^ Manicka Babu (2011-05-22). "Cassandra Part 1".
  30. ^ Todd Hoff (2011-02-08). "Mollom Architecture - Killing Over 373 Million Spams at 100 Requests per Second". High Scalability.
  31. ^ cite web|url=http://www.slideshare.net/adrianco/migrating-netflix-from-oracle-to-global-cassandra
  32. ^ Yury Izrailevsky (2011-01-28). "NoSQL at Netflix".
  33. ^ Martin Cozzi (2011-08-31). "Cassandra at Formspring".
  34. ^ "http://www.datastax.com/wp-content/uploads/2011/06/DataStax-CaseStudy-Mahalo.pdf" (PDF). {{cite web}}: External link in |title= (help)
  35. ^ http://blip.tv/datastax/cassandra-at-mahalo-com-4030941
  36. ^ http://www.datastax.com/wp-content/uploads/2011/04/WP-Ooyala.pdf
  37. ^ http://www.datastax.com/wp-content/uploads/2011/05/DataStax-CaseStudy-Openwave.pdf
  38. ^ http://openx.com/publisher/technology
  39. ^ Nathan Milford. "Cassandra for Sysadmins".
  40. ^ Preston Smalley (2011-03-20). "An important milestone - and it's only the beginning!".
  41. ^ Ilya Grigorik (2011-03-29). "Webpulp TV: Scaling PostRank with Ilya Grigorik".
  42. ^ "Hadoop and Cassandra (at Rackspace)". Stu Hood. 2010-04-23. Retrieved 2011-09-01.
  43. ^ Posted by david [ketralnis] (2010-03-12). "what's new on reddit: She who entangles men". blog.reddit. Archived from the original on 25 March 2010. Retrieved 2010-03-29. {{cite web}}: Unknown parameter |deadurl= ignored (|url-status= suggested) (help)
  44. ^ Posted by the reddit admins at (2010-05-11). "blog.reddit -- what's new on reddit: reddit's May 2010 "State of the Servers" report". blog.reddit. Archived from the original on 14 May 2010. Retrieved 2010-05-16. {{cite web}}: Unknown parameter |deadurl= ignored (|url-status= suggested) (help)
  45. ^ Dathan Vance Pattishall (2011-03-23). "Cassandra is my NoSQL Solution but".
  46. ^ Alexander Muse (2011-07-18). "Shopsavvy leverages Hadoop and Cassandra".
  47. ^ Klint Finley. "How SimpleGeo Built a Scalable Geospatial Database with Apache Cassandra". Read Write Cloud.
  48. ^ "Cassandra at SoundCloud" (PDF).
  49. ^ Popescu, Alex. "Cassandra @ Twitter: An Interview with Ryan King". myNoSQL. Archived from the original on 1 March 2010. Retrieved 2010-03-29. {{cite web}}: Unknown parameter |deadurl= ignored (|url-status= suggested) (help)
  50. ^ Babcock, Charles. "Twitter Drops MySQL For Cassandra - Cloud databases". InformationWeek. Archived from the original on 2 April 2010. Retrieved 2010-03-29. {{cite web}}: Unknown parameter |deadurl= ignored (|url-status= suggested) (help)
  51. ^ "Cassandra at Twitter Today".
  52. ^ Erik Onnen. "From 100s to 100s of Millions".
  53. ^ Hartmut Bohmer. "Low Volt Smart System".
  54. ^ Karl Mueller. "Cassandra on SSD".
  55. ^ "Yakaz Technologies".
  56. ^ "Viocom".
  57. ^ FAQ on Cassandra's wiki
  58. ^ "Client Options" article on Cassandra Wiki
  59. ^ Solandra source at Github
  60. ^ Cassandra - A Decentralized Structured Storage System, a 2009 paper presenting Cassandra by their creators Avinash Lakshman and Prashant Malik

Bibliography

Retrieved from "https://en.wikipedia.org/enwiki/w/index.php?title=Apache_Cassandra&oldid=511725842"