Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re: What is your favourite Linux or cross-platform database?

by JSchmitz (Canon)
on Mar 25, 2010 at 17:40 UTC ( #830913=note: print w/replies, xml ) Need Help??

in reply to What is your favourite Linux or cross-platform database?

Since you didn't specify relational databases I am going to say Cassandra DB

Cassandra can be thought of as a huge 4-or-5-level associative array, where each dimension of the array gets a free index based on the keys in that level. The real power comes from that optional 5th level in the associative array, which can turn a simple key-value architecture into an architecture where you can now deal with sorted lists, based on an index of your own specification. That 5th level is called a SuperColumn, and it's one of the reasons that Cassandra stands out from the crowd.

Cassandra has no single points of failure, and can scale from one machine to several thousands of machines clustered in different data centers. It has no central master, so any data can be written to any of the nodes in the cluster, and can be read likewise from any other node in the cluster.
It provides knobs that can be tweaked to slide the scale between consistency and availability, depending on your particular application and problem domain. And it provides a high availability guarantee, that if one node goes down, another node will step in to replace it smoothly.

Writing about all the features of Cassandra is a whole different post, but I am convinced that its data model is rich enough to support a wide variety of applications while providing the kind of extreme scalability and high availability features that few other databases can achieve--all while maintaining a lower latency than other solutions out there.


Jeffery Schmitz
  • Comment on Re: What is your favourite Linux or cross-platform database?

Replies are listed 'Best First'.
Re^2: What is your favourite Linux or cross-platform database?
by erix (Parson) on Mar 25, 2010 at 17:54 UTC

    You say:

    Since you didn't specify relational databases

    but he explicitly stated:

    • Support SQL92

    update: (Btw, you should be ashamed to copy & paste such a large block of text from someone else, and not even mention where it comes from)

      You are correct I missed that
      The huge block of txt you speak of is from here:

      Cheers -

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://830913]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others browsing the Monastery: (6)
As of 2018-07-21 02:29 GMT
Find Nodes?
    Voting Booth?
    It has been suggested to rename Perl 6 in order to boost its marketing potential. Which name would you prefer?

    Results (443 votes). Check out past polls.