Powerplay: Postgres and Lenovo for the Best Performance & Savings

© 2014 EnterpriseDB Corporation. All rights reserved. 2 •  Why Lenovo System x and EnterpriseDB are a powerplay •  Lenovo X6 Servers: Fast, Agile, Resilient •  EnterpriseDB Postgres Plus: Supports traditional and Big Data workloads •  Savings: Lower your Total Cost of Ownership 90%+ •  Migration Strategies and Case Study •  What’s next? Agenda

© 2014 EnterpriseDB Corporation. All rights reserved. 3 Postgres Plus Advanced Server Postgres Plus Cloud Database High Availability PerformanceManagement REMOTE DBA 24x7 SUPPORT PROFESSIONAL SERVICES TRAINING EDB Serves All Your Postgres Needs PostgreSQL Security

© 2014 EnterpriseDB Corporation. All rights reserved. 5 Postgres is the 4th most popular database (DB-Engines, November 2014) Gartner Magic Quadrant October 2014 •  Community leadership — EnterpriseDB is the primary contributor to the PostgreSQL community and is responsible for many new features of PostgreSQL, including JSON. •  Functionality — The functionality of EnterpriseDB's Postgres Plus has increased greatly, and with the Oracle Compatibility Feature is now more than sufficient to run both mission-critical and non-mission-critical applications. •  Stability and compatibility — References specifically call out compatibility with Oracle, the stability of the DBMS and product support as strengths.

© 2014 EnterpriseDB Corporation. All rights reserved. 6 •  EDB is a focus partner of System x at Lenovo •  Teaming up to support Oracle customers looking to migrate to Postgres Plus •  Lenovo’s largest Systems x resellers and SIs are teaming with EDB •  Red Hat is an EDB partner and a strategic investor in EDB EDB and Lenovo: Trusted Partnership

© 2014 EnterpriseDB Corporation. All rights reserved. 8 8 The Leading x86 Portfolio 1P & 2P Rack & Tower systems High-‐end systems Broad rack and tower portfolio to meet a wide range of client needs from infrastructure to technical computing Up to 8 socket enterprise-class x86 performance, resiliency, security Integration across assets in systems and SW for maximum client optimization and value Optimize space-constrained data centers with extreme performance and energy efficiency Converged/Blade systems Dense systems BladeCenter iDataPlex System x

© 2014 EnterpriseDB Corporation. All rights reserved. 9 Lenovo X6 servers: Innovation that Matters Benefits Fast • 100 percent faster compute performance • 3 times more memory capacity • 50 percent more flash storage capacity • 3 times lower latency

© 2014 EnterpriseDB Corporation. All rights reserved. 10 Lenovo X6 servers: Innovation that Matters Benefits Fast • 100 percent faster compute performance • 3 times more memory capacity • 50 percent more flash storage capacity • 3 times lower latency Agile • Modular design supports next gen processor and memory upgrades • Can reduce acquisition costs up to 28%

© 2014 EnterpriseDB Corporation. All rights reserved. 11 Lenovo X6 servers: Innovation that Matters Benefits Fast • 100 percent faster compute performance • 3 times more memory capacity • 50 percent more flash storage capacity • 3 times lower latency Agile • Modular design supports next gen processor and memory upgrades • Can reduce acquisition costs up to 28% Resilient • Self-healing processor, I/O and memory features can improve availability • Upward Integration Modules (UIMs): provide hardware visibility to hypervisor for best system and VM management.

© 2014 EnterpriseDB Corporation. All rights reserved. 14 POSTGRES innovation ENTERPRISE reliability 24/7 support Services & training Enterprise-class features & tools Indemnification Product road-map Control Thousands of developers Fast development cycles Low cost No vendor lock-in Advanced features Enabling commercial adoption of Postgres

© 2014 EnterpriseDB Corporation. All rights reserved. 16 Security ADVANCED SERVER POSTGRES PLUS •  Enhanced Auditing •  Row Level Security (VPD) •  SQL Injection attack guard •  Server-side code protection •  Multiple US Gov’t certifications including EAL2

© 2014 EnterpriseDB Corporation. All rights reserved. 17 Bundled Tools ADVANCED SERVER POSTGRES PLUS •  Oracle, SQL Server & PostgreSQL to Postgres Plus replication •  Enterprise management, monitoring, and tuning •  Multi-master replication •  HA failover protection •  Backup and recovery •  Oracle, SQL Server & MySQL to Postgres Plus migration •  Update monitoring

© 2014 EnterpriseDB Corporation. All rights reserved. 18 Performance ADVANCED SERVER POSTGRES PLUS •  Faster Partitioning - 400x faster writes & 76x faster selects •  SQL Profiler – fix slow workloads •  Bulk Data Loader - 2x faster •  Index Advisor - speeds up inquiries •  Query Hints - optimizer control •  DynaTune - memory upgrades •  Bulk Collect/Fetch/Binding of arrays •  Dynamic runtime statistics reveals SQL wait bottlenecks

© 2014 EnterpriseDB Corporation. All rights reserved. 19 Postgres maximizes value by enabling a wider range of workloads from a relational database: •  Postgres’ Object-Relational roots provides flexibility and extensibility for unstructured data types, languages and plug-ins •  Handles many NoSQL workloads with support of XML, JSON and HStore (key-value store) data types •  Foreign Data Wrappers enable read/write integration with other NoSQL technologies •  Postgres Plus Advanced Server connector for Hadoop •  Non-durable (unlogged) storage capability Not just traditional workloads, but also Big Data with ACID compliance

© 2014 EnterpriseDB Corporation. All rights reserved. 21 Oracle Enterprise Edition EDB Postgres Plus Advanced Server License Fee Per Core (2 sockets/8 cores) (x86 processor) (2 sockets/8 cores) (x86 processor) Database $47,500 included in subscription Partitioning $11,500 Included Data Guard $11,500 Included Diagnostics $5,000 Included Total License Fee per Core $75,500 included in subscription Total License Fee per Server (CapEx) (0.5 core factor) $302,000 $0 Annual support/subscription cost per core 22% of License Fee $6,900 per socket Annual Support/Maintenance per Server (OpEx) $66,440 $13,800 Total 3 Year License and Support Cost $501,320 $41,400 Oracle vs. EDB TCO Comparison on x86 No CAPEX Annual OPEX reduction 79% 3 YR TCO cost savings 92%

© 2014 EnterpriseDB Corporation. All rights reserved. 22 Oracle Migration Assessment 22 Oracle 1. Analyze Oracle schema layout for supported features in PPAS 2. Review features used in Oracle client application 3. Supported features and recommended fixes Difficult Easy 4. Overall composite score and migration plan with workarounds and time estimates Survey: 51% needed slight to no app changes to migrate

© 2014 EnterpriseDB Corporation. All rights reserved. 23 •  Run applications written for Oracle virtually unchanged •  No need to retrain Oracle DBAs and developers •  Support for PL/SQL language and OCI interoperability •  Replication for easy sharing of data 23 Database Compatibility with Oracle Compatible with: Oracle Developers Oracle Applications Everything works on PPAS! Your businessYour appsYour people No disruption to your ongoing operations!

© 2014 EnterpriseDB Corporation. All rights reserved. 24 71% of surveyed IT organizations using Postgres Plus Advanced Server identified the ability to use existing Oracle DBA skills as having the greatest impact on the productivity of their DBA team. The ability to onboard an Oracle DBA and convert him to a Postgres DBA, while being able to leverage infinite cache for better scalability, is one of the greatest benefits we’ve achieved with EnterpriseDB. Survey: Reuse of Oracle DBA Skills

© 2014 EnterpriseDB Corporation. All rights reserved. 25 Replaced Oracle with EnterpriseDB for its online gaming destination and reduced its database TCO by nearly 80% 80% of applications selected to move from Oracle ran on Postgres with little or no modification •  PPAS •  Services, training and support •  Oracle Migration Assessment PRODUCTS PURCHASED •  Open source alternative to Oracle with a lower TCO and greater licensing flexibility •  Oracle migration capabilities •  Scalability & reliability •  High availability KEY CUSTOMER REQUIREMENTS •  Ability to leverage its existing database administrator and developer talent •  Ease of moving existing Oracle applications to the new database •  Commercial-grade quality and reliability, including backup and recovery standards, to support mission- critical applications •  Scalable, high performance execution OTHER KEYS TO SUCCESS

© 2014 EnterpriseDB Corporation. All rights reserved. 26 •  90%+ TCO reduction vs. Oracle •  Robust, mission critical capabilities •  Close partnership with Lenovo •  Full array of support & services packages EDB on Lenovo System x The x86 Price-Performance Choice

Powerplay: Postgres and Lenovo for the Best Performance & Savings

More Related Content

What's hot

Viewers also liked

Similar to Powerplay: Postgres and Lenovo for the Best Performance & Savings

More from EDB

Recently uploaded

Powerplay: Postgres and Lenovo for the Best Performance & Savings