2 months after begin of rollout! - Credativ

frightenedfroggeryData Management

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

297 views

Michael Meskes
Mission impossible?
Can I replace my most important
databases with PostgreSQL?
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011


Free Software since 1993


Linux since 1994


Debian GNU/Linux since 1995


PostgreSQL since 1998
Michael
Meskes
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011


1992 – 1996
Ph.D.


1996 – 1998
Project Manager


1998 – 2000
Branch Manager


Since 2000
President
Michael
Meskes
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
credativ group
Open Source
for business
One-stop Shop
for
Open Source
Support

TM

Open Source Support Center


Consulting


Installation


Administration


Operations


Training


Support
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
24/7/365
Phone
Email
Remote
On-site


1999: HQ in Mönchengladbach, Germany


2004: Office in Rugby, UK


2007: Office in Toronto, Canada


2009: Office in San Diego, USA


2009: Office in Munich, Germany


2011: Office in Bengaluru, India


2012: more to come
PostgreSQL Conference Europe
2011
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
Business
Needs
In
General



Low total cost of ownership


Local expertise


Reliable


External support


Integrates well


Adjustable
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
When to
Update?
What to
Update?
Your
Decision!
New Feature
Bug
Security Problem
Performance

Update!
Stable System
Incompatibility

Update!
www.credativ.com
credativ 2011
The
Choice
For
Business
Critical
Usage

Free and Open Source Software


No licence cost


Open standards


High quality software and support


Tailor-made standard software


Independence


No vendor lock-in


Protection of investment
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
Custom
Programming
Standard
Software
Open-Source
Software

Software Development


Concept


Implementation


Internal QA


External QA


Bug fixing
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
Great
Quality
Is
Guaranteed

Quality Assurance


Lots of testers in production environments


Huge amount of test cases


White-Box-Testing


Completely open bug tracking


Bug fixing without side effects


No fixed deadlines enforced
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011

Open
Security
Filter
Email
Cluster
Location 1 - Firewall
Location 2 - Firewall
Internet
Entry 1
Entry 2
Entry 1
Entry 2
Node 1
Node 2
Node ...
Node n
Node 1
Node 2
Node ...
Node n
Mailserver
Mailserver
Management /
Logging / RBL
Management /
Logging / RBL
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011

Early adoption

Completely built from FOSS

Design, Implementation, Integration

Lots of fixes and enhancements

Total downtime: 0

Open
Security
Filter
Email
Cluster
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011

Lots of offerings

Driven by companies or communities

Dedicated solutions

Integrated solutions

FOSS is moving up the stack!

Collaborative
Software
Groupware
Calendaring
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011

Communication: Email, VoIP, ...

Monitoring

Webshops

Database

Business
Critical
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011

PHP, Python, Perl, Ruby, Java, ...

Apache, nginx, lighthttp, ...

JBoss, Tomcat, Jonas, …

PostgreSQL, MySQL, ...

FOSS is moving down the stack!

Customer
Facing
Systems
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
Database
Management
Systems
Turn
Data
Into
Information
Source: wikipedia
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
The world's
most advanced
open source
database
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
Community-
driven
development
No
Roadmap
Commitfest


PostgreSQL Global Development Group


Core-Team: Steering Committee


Developer Conferences


Mailinglists, IRC, …


Open ToDo-List
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
Your
Reports
And
Requests

Matter!

PostgreSQL Development


Concept
Users and Developers


Implementation
Users and Developers


Internal QA
Regressiontest, Buildfarm


External QA
Lots of Beta Testers


Bug fixing
Open Bug Handling
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
Database
Feature
Comparison


Tables/Views
1/2
emulated with SP


Indexes
10/10


Capabilities
10/11
parallel queries


Other objects
6/6


Partitioning
4/6
Oracle, DB2, ...
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011


Compatibility layer Informix


Compatibility layer Oracle


Stored procedures


Database comparison


Tools to ease migration
Migration to
PostgreSQL
Standard SQL
Standard
Interfaces
Lots of
Bindings
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011
Advantages
outweight
Objections

Counter Arguments


Linux knowledge needed“


Have to train on PostgreSQL“


Difficult to hire PostgreSQL people“


Enterprise level support needed“


Community does not work“
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011


Semiconductor equipment data collection for a
deployment of several hundreds of servers



Semiconductor equipment data warehouse for a
multi-terabyte data warehouse


Student database of a lot of universities


Several retail warehouse applications


Customer serving system of German bank


Embedded database in products of a large telecom


Central databases of another large telecom


Lots of webshop systems
Migration to
PostgreSQL
All Over
The Place
Sustainable
Competetive
Advantage
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011


Choose a capable manager


Create a solid planning basis


Design top-down, implement bottom-up


Consider all processes and data traffic


No interim, temporary or isolated solutions


Essential parts have to be redundant


Remember training, maintenance and support
Migration to
PostgreSQL
Tools:
Compare
Databases
Migrate
Stored
Procedures
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011


Admins know PostgreSQL


Middleware supports PostgeSQL


Standard datatypes


Standard SQL code

Instant Return of Investment!
Migration to
PostgreSQL
Best Case
1 Day of
Consulting
1 Hour of
External Work
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011


600 Installations


$ 5,000 per database server


$ 150,000 up-front migration costs


$ 2,000 additional rollout costs


25 rollouts per month

Return of Investment
2 months after begin of rollout!
Migration to
PostgreSQL
Lots of
Licenses
Dual
Compilation
PostgreSQL
Enhancement
PostgreSQL Conference Europe
2011
www.credativ.com
credativ 2011


18
00 installations with 2 servers each


2,000 per installation per year


Migration costs € 1,000,000


1,000 additional rollout costs

per installation


125 rollouts (250 servers)

per month

Return of Investment
8 months after begin of rollout!
Migration to
PostgreSQL
Lot of
Migration
Work
Special
Features
Rewrite
PostgreSQL Conference Europe
2011
Michael Meskes
Mission
im
possible
?
!
I can replace my most important
databases with PostgreSQL!
PostgreSQL Conference Europe
2011