aiming for an interactive presentation. If not possible, questions will be answered at the end Slides and recording will be made available via email at: [email protected]
Database Management System emphasizing in extension and SQL compliance • Specialized role within computer systems administration • Develop and operate the data storage ecosystem that digital business rely on • Philosophy for software development • Mix of culture, development, operations, and tools that allow for development, and improvement of products at a faster rate • Cross-disciplinary community of practices dedicated to the study of building, evolving, and operating rapidly-changing resilient systems at scale
both OLAP and OLTP workloads. It is a great general purpose database with performance benchmarks to prove its case • No single commercial entity driving the roadmap ◦ Vibrant, and growing community ◦ Constantly adding new features and innovating • Extremely extensible, supports multiple programming languages, and data models (multi-model) ◦ SQL ◦ Document (XML, JSONB) ◦ Key value 7 Performant Extensible, scalable, and community driven Built for speed
flexible open-source relational DBMS • Popular among developer and used in a wide range of applications • Easy integration with DevOps tools ◦ Ansible ◦ Jenkins ◦ Chef • Robust security features ◦ SSL Encryption ◦ Authentication • Ability to handle large volumes of data with ease 11 Easy integration with DevOps tools Extensible, highly-available, and scalable Secure
of a traditional database administrator with the principles of DevOps. • Responsible for managing the DB’s used by an organization’s applications, while working closely with developers, testers, and other IT professionals to ensure that the DB is integrated into the overall DevOps process 12
in Postgres • DevOps tools and principles • Database design principles • Scripting and programming • Security expertise • Collaboration and communication • Troubleshooting and problem-solving • Familiarity with cloud technologies 14
developers and other IT professionals • Automates database provisioning, deployment, and scaling using tools like Ansible, Chef, or Puppet • Designing and implementing high availability and disaster recovery solutions • Implementing database monitoring and logging systems to ensure high performance and availability • Developing and maintaining CI/CD pipelines to continuously deploy database changes • Managing and optimizing database infrastructure on cloud platforms like: AWS, Azure and GCP • Managing and monitoring Postgres replication and sharding • Ensuring database security and compliance with regulator standards • Supporting and troubleshooting Postgres-related issues • Installing, configuring and upgrading Databases and software • Monitoring and optimizing database performance • Creating, maintaining, and testing backup and recovery procedures • Designing and implementing data models and database schemas • Managing database storage and capacity planning • Ensuring data integrity and consistency • Troubleshooting and resolving database issues • Providing technical support to application developers and end-users • Developing and implementing disaster recovery plans
open source operator designed to manage PostgreSQL workloads on any supported Kubernetes cluster running in private, public, hybrid, or multi-cloud environments. • Originally built by EDB, released open source under Apache License 2.0 and submitted for CNCF Sandbox in April 2022 • Cloud Native PostgreSQL adheres to DevOps principles and concepts such as declarative configuration and immutable infrastructure.” • Open source ◦ https://github.com/cloudnative-pg/cloudnative-pg • Documentation available at: ◦ https://cloudnative-pg.io/documentation/1.19/
deploying and managing Postgres ◦ High availability ◦ Disaster recovery • Kubernetes adoption is rising and becoming the de facto orchestration tool • Handling Postgres clusters “the Kubernetes way” enables Cloud Native usage patterns ◦ Spinning up disposable clusters during tests ◦ One cluster per microservice and one database per cluster • CloudNativePG attemps to encapsulate years of Postgres cluster management into an operator seeking to automate known management tasks
integrated with DevOps ❖ Kubernetes is a tool to get familiarized with, and is no longer only for applications. K8s has matured to support databases ❖ Utilize ◦ Kubernetes operator ◦ Persistent volumes for data storage ❖ Automate as many tasks as possible ❖ Develop a monitoring strategy ❖ Test and validate your database backups 21
dougortiz
biwashi
tomohisa
jpishikawa
yokawasa
sansan33
oracle4engineer
.PNG){kind=avatar}
aloerina
bengo4com
kakehashi
os1ma
ufuk
tenderlove
aleyda
trallard
kneath
3n
sugarenia
bkeepers
honnibal
moore
jeffersonlam
hannesfritz
