Downloaded 17 times
Uploaded byEDB
Riding the Second Wave: Open Source for Relational Databases, Enterprise Postgres Day
The document discusses the transition to more complex systems going open source, known as the "second wave". It highlights how automation and DevOps allows replaceable first wave technologies to support more complex second wave systems. The talk focuses on how PostgreSQL remains relevant for data processing needs and how EnterpriseDB supports PostgreSQL for DevOps, continuous integration/delivery, containerization, and new features like pluggable storage engines and sharding.
Riding the Second Wave: Open Source for Relational Databases, Enterprise Postgres Day
- 1. 11 July 2019 RIDINGTHE SECOND WAVE Presented by Jan Karremans Director of Sales Engineering EnterpriseDB Open Source for Relational Databases
- 2. EnterpriseDB The Most CompleteOpen Source Database Platform Leader in the PostgreSQL community To Postgres what RedHat is to Linux Enterprise-grade Postgres Freeing companies from vendor lock-in
- 3. Jan Karremans @Johnnyq72 EXPERTISE BACKGROUND Oracle ACEAlumni EDB Postgres Advanced Server Professional 25 years of database technology 15 years of consulting 15 years of management 10 years of software development 10 years of technology sales 5 years of community advocacy 5 years of international public speaking
- 4. First wave SHARE 1955(SPLA) DECUS 1980’s GNU 1983 Linux 1991
- 5. First Wave Easy andreplaceable systems go open source first Editors Utilities Operating systems
- 6. Second wave More complexsystems Not so easy to replace With greater business risk & value
- 7. CREATING A SURF First waveand second wave crashing together Replaceable technologies support the management of more complex systems Automation of deployments and DevOps as sublime example of this surf
- 8. CREATING A SURF Development of applicationssubject to paradigm shift Waterfall to agile Continuous integration / delivery as new features need to be available quicker Applications get broken down in ever smaller granules
- 9. CREATING A SURF Relational, more relevantthen ever Need for data processing grows at light speed Relational database realm is still expanding SQL will never die
- 10. LOOKING FORWARD MORE ANDMORE PostgreSQL
- 11. Michael Stonebraker VISION Extensible relational databasesystem Today, as if it was built for tomorrow's challenges Relational databases are required more than ever and need to keep up
- 12. DevOps Struggles with traditionaldatabase vendor Paradigm shift dictates agility Traditional products are not designed to fit Strategic importance
- 13. DevOps Postgres and infrastructureas a code Singular focus on RDBMS Native integration capabilities Lowering effort for deployment
- 14. CI/CD Application development paradigmshift (granularity) On-line applications need on-line delivery Higher UX experiences boost complexity Larger teams don’t solve bigger issues
- 15. CI/CD Integration Waterfall to agileneeds integrated QA Blurring the lines between Development and Operations Shifting frontiers in application development
- 16. CI/CD Delivery Higher feature creation,demands higher feature delivery Building production workflows to support this Leading to microservices architecture
- 17. Containerization Integration continued, granularity Breakingup traditional structures even further Increase reusability and ease of maintenance Segregation of functionality
- 18. “IT WORKED ONMY COMPUTER” EDSON YANAGA
- 19. Containerization Just like onmy computer Build once, run everywhere – even amidst the Clouds Logical grouping of technology Removing interdependencies and make it work
- 20. Pluggable Storage Engine Whatwas true then, isn’t necessarily true now Using the extensibility system in new ways Making Postgres fit for the 22nd era of our times
- 21. Sharding for relational databases Pushingthe boundaries on the CAP theorem One atomic transaction over multiple clusters Scalability in today's world of increasing velocity
- 22. EnterpriseDB All Things Postgres PostgreSQL EnterprisePostgres Superset Oracle® Compatibility Features 24/7 Anytime, Anywhere Support
- 23. KNOWLEDGE We spent theday sharing insights and developments around Postgres ONE FOR THE ROAD There will be drinks and socializing directly after our wrap-up POSTGRESFEST Work hard, party hard… With live music and good times Thank you for attending Enterprise Postgres Day
- 24.
Editor's Notes
- #5 The "SHARE Program Library Agency" (SPLA) distributed information and software, notably on magnetic tape (17 oct. 1955) a worldwide system for transmission of free software for users of DEC equipment This was already after Richard Stallman was advocating Freedom in Software GNU: a case where an annoying printer couldn't be fixed because the source code was withheld from users. GNU’s not Unix
- #7 Looking from transactional database perspective there have been a couple of years (5) of relative quiet between the first and the second wave (2010 Linux had taken over 9 out of 10 servers running proprietary OS’s) OSS RDBMS are now flourishing.
- #10 Many new special purpose databases get introduced to answer special challenges This make up for the bulk of the exponential growth Core of the matter still is relational data processing (SQL will not die)
- #12 System very “to the core” (small footprint) In this world, change is the only constant
- #17 (which often require multiple smaller databases)
- #18 Traditional DevOps lags behind
- #22 C onsitency A vailability P artitioning