The Economics of Open Source Database Adoption - Red Hat

Red Hat Summit 2009 | Ed Boyajian
1
Doing More with Less: The Economics
of Open Source Database Adoption
Ed Boyajian
CEO, EnterpriseDB Corporation
September, 2009


Red Hat Summit 2009 | Ed Boyajian
2
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

Explore TCO and cost comparisons among database
alternatives using real world examples
Red Hat Summit 2009 | Ed Boyajian
3
Doing More with Less
Red Hat Summit 2009 | Ed Boyajian
4
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?
435 survey respondents
Source: Gartner Group
Red Hat Summit 2009 | Ed Boyajian
5
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

Donald Feinberg, VP & Distinguished Analyst
Red Hat Summit 2009 | Ed Boyajian
6
TCO of Open Source vs. Proprietary Databases

8 servers

2 CPUs/server

3 year term
Red Hat Summit 2009 | Ed Boyajian
7
Enterprise Software Stacks
Red Hat Summit 2009 | Ed Boyajian
8
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
Red Hat Summit 2009 | Ed Boyajian
9
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
4
Red Hat Summit 2009 | Ed Boyajian
10
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
»
Limited commercial influence
»
World-class QA
»
Smaller, insular communities
»
Autocracy-based project leadership
»
Few external code contributions
»
Limited open source ecosystems
»
Commercially motivated
»
Good QA if run properly
Linux
Postgres
Red Hat Summit 2009 | Ed Boyajian
11
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
Red Hat Summit 2009 | Ed Boyajian
12
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
+ 5
th
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
Postgre
SQL
World’s most advanced open source database,
demonstrably superior to MySQL for enterprise applications.
+ ACID Transactions
+ Advanced Concurrency Control
+ Multi-level Security
+ High-speed Text Searching
+ Enterprise-class Data Integrity
+ Enterprise-class Failure Recovery
Red Hat Summit 2009 | Ed Boyajian
13
EnterpriseDB’s Market Position
Red Hat Summit 2009 | Ed Boyajian
14
Adoption Progression
Red Hat Summit 2009 | Ed Boyajian
15
Postgres Plus Migration Roadmap – Leading Telco
Red Hat Summit 2009 | Ed Boyajian
16
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
Red Hat Summit 2009 | Ed Boyajian
17
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
Red Hat Summit 2009 | Ed Boyajian
18
Migration Effort for Test App – Global 100 Company
Red Hat Summit 2009 | Ed Boyajian
19
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

Reporting applications
Red Hat Summit 2009 | Ed Boyajian
20
Prioritizing Migration Candidates
2
3
4
4
3
Mission
Critical
Least Effort
More Effort
Most Effort
Departmental
Enterprise
1
1
1
2
Quick Wins
First
Red Hat Summit 2009 | Ed Boyajian
21
Migration Methodology
Red Hat Summit 2009 | Ed Boyajian
22
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

New online games in active development and roll-out
Red Hat Summit 2009 | Ed Boyajian
23
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
the cost of Oracle-Oracle replication
Red Hat Summit 2009 | Ed Boyajian
24
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

Explore TCO and cost comparisons among database
alternatives using real world examples
Red Hat Summit 2009 | Ed Boyajian
25