The Economics of Open Source Database Adoption - Red Hat

cuttlefishblueData Management

Dec 16, 2012 (4 years and 6 months ago)

113 views

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