The Hitchhiker's Guide to Cloud Native Databases

Transcript

1. The Hitchhiker's Guide to Cloud Native Databases KSAOUG Riyadh - 8 November 2025 Seàn Scott Oracle ACE Director Managing Principal Consultant Viscosity North America
2. The Hitchhiker's Guide to Cloud Native Databases KSAOUG Riyadh - 8 November 2025
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 Workloads decoupled from the Cloud Portable across Clouds
13. @ViscosityNA www.viscosityna.com Containers are building blocks for the Cloud
14. @ViscosityNA www.viscosityna.com Containers increase Reliability
15. @ViscosityNA www.viscosityna.com Containers improve Durability
16. @ViscosityNA www.viscosityna.com Containers are Portable
17. @ViscosityNA www.viscosityna.com Containers maximize Capacity
18. @ViscosityNA www.viscosityna.com Containers deliver higher Performance
19. @ViscosityNA www.viscosityna.com Containers are more Efficient
20. @ViscosityNA www.viscosityna.com Containers are more Cost Effective
21. @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
22. @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
23. @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!
24. @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
25. Containers are like lightweight Virtual Machines, right?
27. @ViscosityNA www.viscosityna.com Games have structured playing surfaces and rules.
28. @ViscosityNA www.viscosityna.com Services deliver games to players.
29. @ViscosityNA www.viscosityna.com Images include the game rules and playing surface.
30. @ViscosityNA www.viscosityna.com Images are a minimal filesystem & metadata needed to run a service.
31. @ViscosityNA www.viscosityna.com Running an image starts a Container.
32. @ViscosityNA www.viscosityna.com A container is: A process on a host, and; A Union Filesystem.
33. @ViscosityNA www.viscosityna.com Container processes are isolated.
34. @ViscosityNA www.viscosityna.com A Union Filesystem has three layers: A Merge or Union Layer. An Upper Layer. A Lower Layer.
35. @ViscosityNA www.viscosityna.com A Union Filesystem has three layers: A Merge or Union Layer: The service. An Upper Layer: The container. A Lower Layer: The image.
38. @ViscosityNA www.viscosityna.com The Upper (merge) layer isn't "real."
39. @ViscosityNA www.viscosityna.com The Upper (merge) layer isn't "real." It's a perceived (calculated) union of: • The game board & rules • Game play
40. @ViscosityNA www.viscosityna.com Containers persist state (moves) in the run-time layer of its Union Filesystem. Containers are stateful.
41. @ViscosityNA www.viscosityna.com Deleting a container removes its Union Filesystem (and its run-time layer). Containers are Ephemeral
42. @ViscosityNA www.viscosityna.com Images are immutable and never change.
43. @ViscosityNA www.viscosityna.com Stalemate!
44. @ViscosityNA www.viscosityna.com Shift the Image Right Moves fall off the game board: Changing an image changes the game!
45. @ViscosityNA www.viscosityna.com Images are immutable and can't persist state information. They are stateless.
46. @ViscosityNA www.viscosityna.com Images = Static templates Containers = Editable documents
47. @ViscosityNA www.viscosityna.com Containers are Magic!
48. @ViscosityNA www.viscosityna.com How much space do three containers use? 500MB
 + 500MB 
 + 500MB 500MB 500MB
 + 500MB 
 + 500MB 1,500MB 500MB 500MB 500MB +
49. @ViscosityNA www.viscosityna.com Multiple identical containers will share an image.
50. @ViscosityNA www.viscosityna.com A Containerfile is a recipe for building images.
51. @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
52. @ViscosityNA www.viscosityna.com Different containers can share common layers.
53. @ViscosityNA www.viscosityna.com Different containers can share common layers. "Higher" layers provide distinct functionality.
54. @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
55. @ViscosityNA www.viscosityna.com The challenge for Cloud Native DBAs Images are stateless Containers are ephemeral but... Databases require statefulness and persistence!
56. @ViscosityNA www.viscosityna.com Bare Metal/VM Host /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03
57. @ViscosityNA www.viscosityna.com Container /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03
58. @ViscosityNA www.viscosityna.com Container Image /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03
59. @ViscosityNA www.viscosityna.com Container Image /etc/oratab /u01 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
60. @ViscosityNA www.viscosityna.com Container Image High-performance storage /etc/oratab /u01 /u02 /u03 Stateless and immutable Stateful and ephemeral Stateful and persistent! ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin
61. @ViscosityNA www.viscosityna.com Container 19.26 Image /etc/oratab /u01 /u02 /u03 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin
62. @ViscosityNA www.viscosityna.com Container Image /etc/oratab /u01 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
63. @ViscosityNA www.viscosityna.com Container 19.27 Image /etc/oratab /u01 /u02 /u03 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin
64. The Hitchhiker's Guide to Cloud Native Databases KSAOUG Riyadh - 8 November 2025
65. Questions? Contact Me! sean.scott@viscosityna.com https://linktr.ee/oraclesean www.viscosityna.com
66. @ViscosityNA www.viscosityna.com Contact Me: sean.scott@viscosityna.com https://linktr.ee/oraclesean