Doing More with Less: The Economics of Open Source Database Adoption

Doing More with Less: The Economics

of Open Source Database Adoption

Ed Boyajian

CEO, EnterpriseDB Corporation

September, 2009

Discussion Objectives



_{Demonstrate the growth of Postgres and other open}

source database adoption in the enterprise



_{Expose key differences between open source software}

stacks and proprietary stacks



_{Profile Postgres Plus from EnterpriseDB}



_{Define ideal workloads and “best practices” for open}

source database use

Open Source Database Adoption is Accelerating

2009 OSBC Survey

Which technology sector is MOST susceptible to disruption by open source within the next five years?

Gartner On Open Source

“In the current economic climate, the number of

inquiries to Gartner about the use of open-source

DBMSs in place of a commercial DBMS is escalating,

rapidly.”

Source: Cost Optimization with Open-Source DBMSs

TCO of Open Source vs. Proprietary Databases

8 servers

2 CPUs/server

Postgres Plus and RHEL

PostgreSQL

Linux

Postgres Plus

RHEL

Postgres Plus $4,495/socket Oracle » $40,000 database+ » $10,000 partitioning » $20,000 OLAP » $10,000 spatial » $10,000 adv security Compelling Economics

MySQL’s Perfect Storm

“…it's time to seriously review how MySQL server is being

developed and change the

development model to be more like … PostgreSQL.”

Monty Widenius MySQL Founder Feb 26, 2008 Acquired by Sun 1 Nov 29, 2008 Blasted by founder 2 Feb 6, 2009 Abandoned by Founders 3 Apr 21, 2009 To Be Acquired by Oracle ₄

Open Source Development Models

Community-driven Projects Vendor-driven Projects

» Large, active user populations

» Meritocracy-based project leadership

» Many external code contributions

» Vibrant open source ecosystems

» Smaller, insular communities

» Autocracy-based project leadership

» Few external code contributions

» Limited open source ecosystems

Linux

PostgreSQL – No Longer a Best Kept Secret

» 20 years of open community development

» Feature rich, hardened, extremely stable

» Modular, scalable, high performance architecture

» Proven in large-scale, mixed load applications

» Vast open source ecosystem of complementary projects

EnterpriseDB’s Postgres Plus Product Family

Postgres Plus Advanced Server

Certified and supported complete solution, suitable for production systems and heterogeneous database environments. Includes breakthrough Oracle compatibility.

+ Management & Monitoring + 5th _{Gen Oracle Compatibility}

+ Bulk Data Processing + Infinite Cache

+ Dynamic Database Tuning + Federated Queries

+ Hierarchical Queries + Oracle Replication

+ Heterogeneous Databases + Commercial Database Migration + Advanced Transaction Handling + Performance enhancements + Security enhancements + Enterprise SLAs

Postgres Plus Standard Server

Ready-to-run certified Postgres binaries for professional developers. Installs in minutes, enables immediate productivity.

+ Administration Suite

+ Distributed Memory Cache + ODBC and JDBC Drivers

+ Dynamic Debugger + Integrated Geo-spatial + Integrated Replication

+ MySQL Migration Tools + Tested, hardened, packaged

PostgreSQL

World’s most advanced open source database,

Economics Revisited

“When someone comes in at a sixth the cost [of

Oracle] and 500 times the customer service, that makes it very easy.”

Jason Weiss Software Architect, FTD

Postgres Plus Oracle Compatibility

Comprehensive Compatibility PL/SQL » Triggers » Functions » Stored Procedures » Packages » Built-in Packages Built-in Functions SQL Syntax Data Dictionary SQL*Plus SQL*Loader OCI

Ranking Migration Candidates

 _{Applications using RAC, advanced queuing, advanced security}  Oracle spatial applications

 _{Pro*C and Pro*COBOL applications}

 _{C, C++, PHP, or other non-Java applications}

 _{Transactional applications using newer Oracle features}

 _{Data warehousing applications using Oracle OLAP functionality}

 _{JDBC/ODBC applications with no server side code}

 _{Applications with server side code upgraded from an older version of}

Oracle

Prioritizing Migration Candidates

2

3

4

4

3

Mission Critical

Least Effort More Effort Most Effort

Departmental

Enterprise

1

1

Sony Online Entertainment Case Study

 _{World’s leading provider of online games}

 _{Oracle costs did not match Sony’s growth objectives}  _{Sony had previous success with Linux and Tomcat}  _{Sony chose Postgres Plus Advanced Server}

– Immediate cost savings

– Leverage existing Oracle skills

– Scalability and high availability not found in MySQL

– World class technical support

FTD Case Study

 _{World’s leading provider of floral products and services}  _{Needed to offload BI apps from production database}  _{Sony chose Postgres Plus Advanced Server}

– Costs of Oracle-Oracle replication were too high

– Leverage existing Oracle skills

– Oracle-Postgres Plus replication could be implemented in less than 2 months

– World class technical support

 _{Improved production performance by 400%+ at 16% of}

Discussion Summary



_{Demonstrate the growth of Postgres and other open}

source database adoption in the enterprise



_{Expose key differences between open source software}

stacks and proprietary stacks



_{Profile Postgres Plus from EnterpriseDB}



_{Define ideal workloads and “best practices” for open}

source database use