1 / 13

Linux on Power - Doubling your performance Using open source to improve the price / performance

19th November 2013. Inspired open source solutions. Linux on Power - Doubling your performance Using open source to improve the price / performance dynamics of managing data. Robin Porter Business Development Manager. James Freeman Enterprise Architect. Established 2007.

agrata
Download Presentation

Linux on Power - Doubling your performance Using open source to improve the price / performance

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 19th November 2013 Inspired open source solutions Linux on Power - Doubling your performance Using open source to improve the price / performance dynamics of managing data Robin Porter Business Development Manager James Freeman Enterprise Architect

  2. Established 2007 Open source software development house 2011 launched solutions and services One of the fastest growing Red Hat partners in UK Specialists in Virtualisation and Database I/S Technical solutions focus

  3. Data Explosion and the need for open source • 90% of the worlds data was created in the last two years • Majority is ‘unstructured’ • Oracle dominate RDBMS • PostgreSQL is the fastest growing open source database

  4. Open Source is the future • All organisations are looking to cut costs - Database infrastructure is #1 • Open source technologies deliver substantial cost savings • EnterpriseDB have made PostgreSQL Enterprise ready and delivered Oracle compatibility • 80% savings on licensing - is x86 the best hardware platform ? • Proof of concept - performance benchmarking

  5. Linux Performance on Power • Power7+ CPU Platform has huge potential - CISC vs. RISC • Especially for large multi-threaded workloads • But - development effort is still focussed on x86 • Don’t expect best performance out of the box • Tune. Tune. Tune.

  6. Case Study - PostgreSQL • PostgreSQL 9.2.4 • Big performance improvements over 9.1 and earlier • Especially multi-user workloads • Two types of benchmark • pgbench SELECT - simple reporting query benchmark • HammerDB - based on industry standard TPC-C benchmark simulating OLTP workloads • Reference system IBM X3650 M4 - 2 x Xeon E5-2680 - 16 core, 512GB RAM • Equivalently priced x86 tin

  7. pgbench - Step 1 - “Out of the box” • Compiled from source • Default toolchain • Factory configuration on hardware • Power7 = 31% more TPS than x86 ! 31%

  8. But.. we can do better • All tuning work undertaken in house at Quru • No source code changes • Under the guidance of IBM Raleigh / Montpellier • We managed to beat their results !

  9. pgbench - Step 2 - “Tuned” • 2 months testing and tuning • Re-compiled code • Hardware performance tuned • Kernel performance tuned • Application binaries profiled 52% 99% 31%

  10. HammerDB - TPC-C Benchmarks • Tuning gives PowerLinux competitive advantage • Power7 = 58% more NOPM than x86 ! 58%

  11. Quru tuning unlocks the performance of PowerLinux • SPEC CPU2006 • Publicly available at http://www.spec.org • “Base” figures are untuned - strict guidelines • “Peak” figures are tuned - freedom for tuning allowed

  12. Conclusions • Quru achieved a significant uplift in performance • Every environment is unique so tuning is essential • Our integrated solution is the future of Oracle cost containment in the enterprise • To find out more check out www.quru.com/ibmpower • Two whitepapers to follow and an event 10th December at IBM Southbank

  13. Thank You

More Related