Twitter will migrate from MySQL to Cassandra DB

Submitted by carlos on 5 March, 2010 - 14:13

Cassandra is an open source database distributed, is one of the noteworthy projects of the Apache Software Foundation and appears to be hitting hard. By being distributed enables high availability, fault tolerance and, above all, a highly scalable without loss of performance.

And were using companies that handle large amounts of data such as Rackspace, Digg, or Facebook, and the list is expanding.

The latest news, coming from a blog interview with Ryan King MyNoSQL is that Twitter is considering migrating their MySQL server clusters Cassandra DB.
 

This is a product presentation, which can be found in the same web Cassandra Project 

Data Presentations Cassandra Sigmod
View more presentations from jhammerb.

 It is also interesting blog post from Digg in explaining why they made the first migration to Cassandra.

 

Cassandra

Submitted by Nate (not verified) on 24 September, 2010 - 11:18.

Ive always thought that MySQL is better in handling large databases. I have no experience using cassandra.

Thanks,
Nate from technology essays

Thanks for such an

Submitted by Paul88 (not verified) on 20 November, 2010 - 23:08.

Thanks for such an interesting news here. I love Twitter and how their management handles all those situations. They are really genius ones. This migration will give more strength to their serves to my mind. Thanks for publishing this one here and keep posting such nice ones in the nearest future too.
Regards, Paul from web development

Twitter will migrate from MySQL to Cassandra DB

Submitted by emmathompson on 1 January, 2011 - 22:11.

"The latest news, coming from a blog interview with Ryan King MyNoSQL is that Twitter is considering migrating their MySQL server clusters Cassandra DB." - That was a great info.And I am willing to learn Cassandra DB.

mySQL could be the best but

Submitted by sam_wilkent on 7 January, 2011 - 02:34.

mySQL could be the best but you just can't take Cassandra out of the picture. The fact that notable sites with huge database is using it, that is something noteworthy.

I wonder if using Oracle, DB2

Submitted by danleyvilla on 18 January, 2011 - 13:39.

I wonder if using Oracle, DB2 or SQL Server they would have made the same choice (completely changing the model, moving from the Relational to an undefined one) or not. I played with "NoSQL" database a bit and I found that to have scalability one still need to normalize data :) (Ok maybe twitter is another story since they just have to deal with the tweet and that's it)

Not a full migration yet

Submitted by Matthew on 1 February, 2011 - 13:13.

I don't think twitter use cassandra as a store for tweets but mainly for new projects that require a large data store.
Matthew from Highline Interiors

don't know but they can you

Submitted by James11 on 2 February, 2011 - 14:23.

I don't know but they can use Cassandra to store tweets but MySQL is best and why they are migrating!!

Cassandra?

Submitted by jespinoza61 on 4 February, 2011 - 14:29.

Acutally what is the difference between a Cassandra database and a MySQL? Can someone explain it to me? Thanks, Best Lawn Mower

Well, I must say that I am

Submitted by kidilam on 10 February, 2011 - 13:03.

Well, I must say that I am not really surprised because from what I see, Cassandraoffers the kind of performances like none other. They are the latest projects from Apache and being open sources; they are highly available, measurable and moreover lack any performance issues. Furthermore, they have already rooted their bases in Facebook, Digg, and Rackspace and so on. Anyway, the reason for Twitter to jump from MySQL to Cassandra could very well be because of in need of data storage and nothing related to tweets! business continuity planning software

Great Information. That

Submitted by mikehudson on 7 March, 2011 - 13:06.

Great Information. That sounds pretty cool. Really helpful thanks for the Article, Great job,  Keep posting interesting matters here. Looking forward to it. Thanks and keep it up! All the Best.

 

Thanks

Mike Hudson from Enterprise Application development

 

 Looks very promising, will

Submitted by Inkasso on 9 March, 2011 - 12:35.

 Looks very promising, will give it a try :) inkasso

Stiff Nights

Submitted by StiffNights12 on 14 March, 2011 - 09:27.

 Cassandra and the other distributed databases available today do not provide the kind of ad-hoc query support you are used to from sql. 

 

also visit us at http://www.maleproductsguide.com/stiffnights.html

Cool

Submitted by michaelfox on 15 March, 2011 - 23:40.

Great news. It's good to see opensource programs gather ground. I hope the trend continues...

 

Mike at Bike Racks for SUVs.

I wonder if using Oracle, DB2 or SQL Server they would have made

Submitted by superwork on 16 March, 2011 - 14:23.

I wonder if using Oracle, DB2 or SQL Server they would have made the same choice (completely changing the model, moving from the Relational to an undefined one) or not. I played with "NoSQL" database a bit and I found that to have scalability one still need to normalize data :) (Ok maybe twitter is another story since they just have to deal with the tweet and that's it)

 

Google
 
     

Similar entries

  • Learning NoSQL

    The emergence of twitter, facebook, Groupon, amazon, etc ... is becoming increasingly popular new forms of large data storage and fast access to them. The terms NoSQL , Big Data , Hadoop ... are rapidly becoming popular.

    Not long ago we talked about it:

     

    - Comparison of NoSQL Databases ( Cassandra , MongoDB , CouchDB , Redis , Riak and HBase ) 
    - Infographics, the potential for big data . 
    - Pentaho also is accelerating much its integration with Big Data.

     

    Today we give you some more detailed presentations, where we can research:  

  • Databases designed to handle large volumes

    With the growth of the Internet, and most successful web projects, it is increasingly necessary to use scalable databases capable of managing efficiently large volumes of information.

    Often traditional databases do not meet the requirements of these systems, or at least not with a reasonable cost, and so open source projects come into play with databases specifically designed to fill this gap.

    One case that we have mentioned is that of Cassandra DB, a distributed database open source that already use Digg, Facebook and Twitter.

    Today I've discovered another promising project. This is Hypertable, another Open Source distributed data storage system that announces maximum performance and scalability to handle large amounts of data. Has commercial support at www.hypertable.com and search engines such as Baidu, Rediff.com or Zvents are already using it.

  • Which brings Oracle Business Intelligence 11g

    Last week I attended a Web Seminar Oracle that presented the new features of Oracle Business Intelligence 11g.

    The truth is that I was pleasantly surprised, because these improvements solved what I considered so far the main weaknesses of the Oracle BI Suites .

    Most significant to me is the integration efforts made in the portal since it can use most of the tools of the suite, and thus reduce the feeling of working with different products. For instance, you can create operational BI Publisher reports from the same portal, and has created an integrated scorecarding tool that allows you to define KPI's, and 'react' with Agents and Actions, another pending issue of the suite. The part of administración system has also been integrated into Enterprise Manager.

    Other improvements are those which have been introduced in the creation and display Dashboard, the possibility of using interactive maps, and above all the possibility of using also Answers MOLAP data sources such as Essbase cubes, which enables integration Hyperion, greatly improves the analytic reporting and enables dynamic navigation for multi-dimensional hierarchies, and other features in the reports.

  • Presentations from the Openbravo World Conference

     

    We have available the presentations from the Openbravo World Conference 2009, to which I was able to attend. All have been published in the agenda of the event's website.

  • Case of study: Business Intelligence applied to the bank

    In these slides the case of study of a bank appears that considers the necessity of a greater knowledge of its clients to be able to define its strategies of business suitably. Thanks to the use of tools of Business Intelligence, in particular of Data Warehouse and Data Mining, and to the definition of clear objectives of business, this bank could analyze the behavior of its clients, segment them, make decisions estraté gicas based on this behavior, to make predictions and to analyze the results of the application of these decisions, being valued therefore the return of the investment. The presentation is structured in the following sections: - The economy of the business and the management of clients - Modelamiento of value - Modelamiento of potential - Segmentation - Modelamiento of desertion - précticas Applications - Results