On TV.com: Top 15 TV THEME Songs
BNET Business Network:
BNET
TechRepublic
ZDNet

February 27th, 2006

Shared nothing coming to open source

Posted by Dana Blankenhorn @ 11:53 am

Categories: Applications, Database Management, General

Tags:

GreenplumShared nothing has been a big deal in the database world for some time. It’s what companies like Google are based on — a distributed database without a single point of contention.

Now this concept is coming to open source. It’s not entirely there yet. But with Greenplum’s new Bizgres MPP, based on the PostgreSQL open source base, you can see it from here.

Scott YaraGreenplum is an example of what CEO Scott Yara calls the next generation of innovation. "Commercial entities innovate on open source code and sell commercial features on open source," he said.

In the case of Greenplum, which has major venture capital backing, "We rebuilt the query optimizer and executor" of PostgreSQL, "as well as an interconnect. So you can run it across clusters and build terabyte sized warehousing systems using off the shelf hardware."

This is a problem a lot of Web 2.0 start-ups like Technorati, Bloglines and Flickr are facing, and projects like Drupal will face soon. They were built with open source tools, but then find they need to "graduate" to something like a data warehouse.  And there’s old Oracle, telling them there’s nothing from an open source supplier that can deliver what they need. Share with us, they say, you don’t have any choice.

Well, now there is a choice. Greenplum CTO Luke Lonergan said that O’Reilly Media, one of Greenplum’s early customers,  "graduated" from mySQL to PostgreSQL with Greenplum and got a 100%  100 times improvement in database access speed across a 500 Gigabyte database. Other Web 2.0 start-ups, and projects, can do the same thing.

"The price of conversion is where the pain is," said Yara, but "look at how fast some of these projects grow." While mySQL was smart in building on a lightweight Web base, more and more users and projects will find the need to graduate, and face proprietary FUD from major vendors saying they have to pay the "monopoly tax" in order to grow.

Well, they don’t. And they can even convert now, if they fear the mySQL FUD companies like Oracle are putting out, Yara added.

It’s at share nothing that the proprietary world is really moving in on open source. But now projects that need to build big warehouses can say share nothing right back at ‘em.

Dana BlankenhornDana Blankenhorn has been a business journalist for 30 years, a tech freelancer since 1983. You can follow Dana on Twitter. See his full profile and disclosure of his industry affiliations.

Email Dana Blankenhorn

Subscribe to Linux and Open Source via Email alerts or RSS.

  • Talkback
  • Most Recent of 5 Talkback(s)
RE: Shared nothing, Continuent, Greenplum
Continuent can definitely help in environments where you have a lot of read activity and a limited amount of data, however for more complex queries over large amounts of data you need parallelism to o... (Read the rest)
Posted by: rhammer Posted on: 02/28/06 You are currently: a Guest | | Terms of Use
Good to see open source trying to catch up.  No_Ax_to_Grind | 02/27/06
Not Exactly  DanaBlankenhornZDNet Moderator | 02/27/06
Important Note  Erik1234 | 02/27/06
Shared nothing solutions gaining momentum  Petri64 | 02/27/06
RE: Shared nothing, Continuent, Greenplum  rhammer | 02/28/06

What do you think?

SponsoredWhite Papers, Webcasts, and Downloads

advertisement

Recent Entries

Archives

Favorite Links

ZDNet Blogs

White Papers, Webcasts, and Downloads