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
Enter the password to open this PDF file:
File name:
-
File size:
-
Title:
-
Author:
-
Subject:
-
Keywords:
-
Creation Date:
-
Modification Date:
-
Creator:
-
PDF Producer:
-
PDF Version:
-
Page Count:
-
Preparing document for printing…
0%
Σχόλια 0
Συνδεθείτε για να κοινοποιήσετε σχόλιο