The Hitchhiker's Guide to Cloud Native Databases

Transcript

1. The Hitchhiker's Guide to Cloud Native Databases Database, Cloud & Developer Day • Utrecht • 13 November 2025 Seàn Scott Oracle ACE Director Managing Principal Consultant Viscosity North America
2. The Hitchhiker's Guide to Cloud Native Databases
3. Database Reliability Engineering MAA ⁘ RAC ⁘ RMAN ⁘ ZDLRA ⁘ ASM Data Guard ⁘ Sharding ⁘ Partitioning Information Lifecycle Management Exadata & Engineered Systems Database Modernization Upgrades ⁘ Patching ⁘ Migrations Cloud ⁘ Hybrid Automation DevOps ⁘ IaC ⁘ Containers ⁘ Terraform Vagrant ⁘ Ansible Observability AHF ⁘ TFA ⁘ CHA ⁘ CHM
4. Oracle on Docker Running Oracle Databases in Linux Containers Free sample chapter: h tt ps://oraclesean.com
5. Tech Superstars Unite Get worldwide recognition as an Oracle ACE Oracle.com profile page Exclusive content Your own Oracle cloud account Swag, certification exam credit & event passes Networking events Travel support Learn more at: ace.oracle.com @oracleace Linkedin.com/groups/72183 @oracleace.bsky.social
6. 10 Conferences 15 Presentations 5 Panels 🌐 15 Time Zones 33 Days 54:28 Hours 15 Nations • 16 Airports • 20 Flights 43,826 km 23,664 nm and More Trains Trains Trains
7. @ViscosityNA www.viscosityna.com Cloud Native is DBA 2.0
8. @ViscosityNA www.viscosityna.com Evolution From on-premises to Cloud to Cloud Native
10. @ViscosityNA www.viscosityna.com On-Prem: Bare Metal and VM Resources directly provisioned to workloads Inflexible, scales poorly Capacity based on projected requirements Difficult to move
11. @ViscosityNA www.viscosityna.com Cloud: Containers Workloads decoupled from resources Scale to meet demand Moving within a cloud is easier Moving to different clouds is difficult
12. @ViscosityNA www.viscosityna.com Cloud Native: Orchestration/Automation Workload abstraction Decoupled infrastructure API-driven management Portable across Clouds
13. @ViscosityNA www.viscosityna.com Cloud Databases: Compute Lift and shift VMs to cloud Scalability limited by compute shape Legacy function and management "Cloud" in name only!
14. @ViscosityNA www.viscosityna.com Containers are building blocks for the Cloud
15. Containers are like lightweight Virtual Machines, right?
16. @ViscosityNA www.viscosityna.com Three full operating systems bin/lib app 3 Guest OS bin/lib app 1 Guest OS bin/lib app 2 Guest OS Hypervisor Host OS Three application/executable directories bin/lib app 3 bin/lib app 1 bin/lib app 2 Container Runtime Host OS
17. @ViscosityNA www.viscosityna.com Virtual Machines Three full operating systems bin/lib app 3 Guest OS bin/lib app 1 Guest OS bin/lib app 2 Guest OS Hypervisor Host OS Containers Three application/executable directories bin/lib app 3 bin/lib app 1 bin/lib app 2 Container Runtime Host OS
18. @ViscosityNA www.viscosityna.com Virtual Machines Three full operating systems bin/lib app 3 Guest OS bin/lib app 1 Guest OS bin/lib app 2 Guest OS Hypervisor Host OS Containers Three application/executable directories bin/lib app 3 bin/lib app 1 bin/lib app 2 Container Runtime Host OS Extra Capacity!
19. @ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA 13 Oracle Databases on a Laptop 2018 MacBook Pro 15", 2.2GHz 6-core Intel Core i7, 16GB, 1TB SSD
21. @ViscosityNA www.viscosityna.com Games have structured playing surfaces and rules.
22. @ViscosityNA www.viscosityna.com Services deliver games to players.
23. @ViscosityNA www.viscosityna.com Images include the game rules and playing surface.
24. @ViscosityNA www.viscosityna.com Images are a minimal filesystem & metadata needed to run a service.
25. @ViscosityNA www.viscosityna.com Running an image starts a Container.
26. @ViscosityNA www.viscosityna.com A container is: A process on a host, and; A Union Filesystem.
27. @ViscosityNA www.viscosityna.com Container processes are isolated.
28. @ViscosityNA www.viscosityna.com A Union Filesystem has three layers: The Merge or Union Layer. The Upper Layer. The Lower Layer.
29. @ViscosityNA www.viscosityna.com A Union Filesystem has three layers: The Merge or Union Layer: The service. The Upper Layer: The container. The Lower Layer: The image.
32. @ViscosityNA www.viscosityna.com The Upper (merge) layer isn't "real."
33. @ViscosityNA www.viscosityna.com The Upper (merge) layer isn't "real." It's a perceived (calculated) union of: • The game board & rules • Game play
34. @ViscosityNA www.viscosityna.com Containers persist state (moves) in the run-time layer of its Union Filesystem. Containers are stateful.
35. @ViscosityNA www.viscosityna.com Deleting a container removes its Union Filesystem (and its run-time layer). Containers are Ephemeral
36. @ViscosityNA www.viscosityna.com Images are immutable and never change.
37. @ViscosityNA www.viscosityna.com Stalemate!
38. @ViscosityNA www.viscosityna.com Shift the Image Right Moves fall off the game board: Changing an image changes the game!
39. @ViscosityNA www.viscosityna.com Images are immutable and can't persist state information. They are stateless.
40. @ViscosityNA www.viscosityna.com Images = Static templates Containers = Editable documents
41. @ViscosityNA www.viscosityna.com Containers are Magic!
42. @ViscosityNA www.viscosityna.com How much space do three containers use? 500MB
 + 500MB 
 + 500MB 500MB 500MB
 + 500MB 
 + 500MB 1,500MB 500MB 500MB 500MB +
43. @ViscosityNA www.viscosityna.com Multiple identical containers will share an image.
44. @ViscosityNA www.viscosityna.com Base Linux OS Oracle 19.3 Home Preinstall RPM Oracle 19.26 RU One-off Patches Base Linux OS Oracle 19.3 Home Preinstall RPM Oracle 19.27 RU One-off Patches
45. @ViscosityNA www.viscosityna.com A Containerfile is a recipe for building images.
46. @ViscosityNA www.viscosityna.com Different containers can share common layers.
47. @ViscosityNA www.viscosityna.com Different containers can share common layers. "Higher" layers provide distinct functionality.
48. @ViscosityNA www.viscosityna.com Base Linux OS Oracle 19.3 Home Preinstall RPM Oracle 19.26 RU One-off Patches Oracle 19.27 RU One-off Patches
49. @ViscosityNA www.viscosityna.com The challenge for Cloud Native DBAs Images are stateless Containers are ephemeral but... Databases require statefulness and persistence!
50. @ViscosityNA www.viscosityna.com Bare Metal/VM Host /u01/app/oracle ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03
51. @ViscosityNA www.viscosityna.com Container /u01/app/oracle ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03
52. @ViscosityNA www.viscosityna.com Container Image /u01/app/oracle ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03
53. @ViscosityNA www.viscosityna.com Container Image /u01/app/oracle ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 Stateless and immutable Stateful and ephemeral
54. @ViscosityNA www.viscosityna.com Container Image /u01/app/oracle ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 podman run --name ORCLDB \ --volume /oradata/ORCLDB/cfg:/dbconfig \ --volume /oradata/ORCLDB/diag:/ORACLE_BASE/diag \ --volume /oradata/ORCLDB/data:/u02 \ --volume /oradata/ORCLDB/redo:/u03 \ oracle/database:19.26-EE
55. @ViscosityNA www.viscosityna.com Container Image High-performance storage /u01/app/oracle /u02 /u03 Stateless and immutable Stateful and ephemeral Stateful and persistent! Persistent storage ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin
56. @ViscosityNA www.viscosityna.com Container 19.26 Image High-performance storage /u01/app/oracle /u02 /u03 Persistent storage ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin
57. @ViscosityNA www.viscosityna.com Container Image High-performance storage /u01/app/oracle Persistent storage ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 podman stop ORCLDB podman rm ORCLDB podman run --name ORCLDB \ --volume /oradata/ORCLDB/cfg:/dbconfig \ --volume /oradata/ORCLDB/diag:/ORACLE_BASE/diag \ --volume /oradata/ORCLDB/data:/u02 \ --volume /oradata/ORCLDB/redo:/u03 \ oracle/database:19.27-EE
58. @ViscosityNA www.viscosityna.com Container 19.27 Image High-performance storage /u01/app/oracle /u02 /u03 Persistent storage ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin
59. The Hitchhiker's Guide to Cloud Native Databases
60. Questions? Contact Me! sean.scott@viscosityna.com https://linktr.ee/oraclesean www.viscosityna.com