The Hitchhiker's Guide to Cloud Native Databases - APAC Community Tour '23 - Auckland

Transcript

1. The Hitchhiker's Guide to Cloud Native Databases Prepare for the Cloud Native database future APAC Tour '23 December 11, 2023 Auckland, New Zealand @ViscosityNA www.viscosityna.com Sean Scott
2. Database Reliability Engineering 
 Business Continuity ⁘ HA & DR 
 Automation ⁘ Observability Real Application Clusters ⁘ Data Guard ⁘ Sharding Containerization ⁘ Terraform ⁘ Ansible Exadata & Engineered Systems AHF ⁘ TFA ⁘ GIMR ⁘ CHA Sean Scott Oracle ACE Director Data on Kubernetes Community Ambassador Managing Principal Consultant Viscosity North America @ViscosityNA www.viscosityna.com
4. An Open Community for 
 Data on Kubernetes https://dok.community
5. @ViscosityNA www.viscosityna.com Oracle on Docker Running Oracle Databases in Linux Containers Free sample chapter: 
 https://oraclesean.com
7. BOI - SEA 642 km SEA - ICN 8,394 km ICN - NRT 1,260 km NRT - MEL 8,144 km MEL - AKL 2,644 km AKL - LAX 10,467 km LAX - BOI 1,085 km 32,635 km
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 Cloud Native = DBA 2.0
14. @ViscosityNA www.viscosityna.com Running Stateful Workloads in Containers
16. @ViscosityNA www.viscosityna.com Containers are building blocks for the Cloud
17. @ViscosityNA www.viscosityna.com Containers are more Efficient. They maximize Capacity and deliver more Cost-Effective solutions.
18. @ViscosityNA www.viscosityna.com Containers are Portable and improve Reliability, leading to more Durable systems.
19. Containers are like lightweight Virtual Machines, right?
20. @ViscosityNA www.viscosityna.com Virtual Machines Containers 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 Extra Capacity!
21. @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
23. @ViscosityNA www.viscosityna.com Virtual Machines: Bootable OS, often heavy Install MS Word separately for every document A 100-page book of games & puzzles Containers: Support one application or service One copy of MS Word shared by all documents A sheet of paper with a Tic-Tac-Toe grid
26. @ViscosityNA www.viscosityna.com Applications and Games exist within structured environments defined by rules.
27. @ViscosityNA www.viscosityna.com The rules and "game board" are expressed as Images: minimal filesystems & metadata that deliver services.
28. @ViscosityNA www.viscosityna.com "Running" an image creates a Union Filesystem and starts an isolated process on the host. These are Containers.
29. @ViscosityNA www.viscosityna.com A Union Filesystem has three layers: A Merge or Union Layer. An Upper Layer. A Lower Layer.
30. @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.
31. @ViscosityNA www.viscosityna.com
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 A Containerfile is a recipe for building images. Each step creates a Layer.
44. @ViscosityNA www.viscosityna.com Multiple identical containers will share an image. Different containers may share common layers.
45. @ViscosityNA www.viscosityna.com Base Linux OS Oracle 19.3 Home Preinstall RPM Oracle 19.20 RU One-off Patches Base Linux OS Oracle 19.3 Home Preinstall RPM Oracle 19.21 RU One-off Patches
46. @ViscosityNA www.viscosityna.com Base Linux OS Oracle 19.3 Home Preinstall RPM Oracle 19.20 RU One-off Patches Oracle 19.21 RU One-off Patches
47. @ViscosityNA www.viscosityna.com Oracle mixes software and configuration.
48. @ViscosityNA www.viscosityna.com Bare Metal/VM Host /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit Software Configuration
49. @ViscosityNA www.viscosityna.com Container /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit Software Configuration (Image) (Container)
50. @ViscosityNA www.viscosityna.com Image Layer Container Layer Union Layer Immutable image layer Ephemeral container layer Computed union layer Oracle Database software + default configurations Modified configurations + log and audit files Unchanged software + overlaid configuration + added log and audit files
51. @ViscosityNA www.viscosityna.com Container /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin oraInventory ORACLE_BASE/audit /etc/oratab
52. @ViscosityNA www.viscosityna.com Image Layer Container Layer Volume Union Layer
53. @ViscosityNA www.viscosityna.com Container Image /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit /etc/oratab
54. @ViscosityNA www.viscosityna.com Container Image /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit /etc/oratab podman run --name ORCLDB \ --volume /oradata/ORCLDB/inv:/u01/app/oracle/oraInventory \ --volume /oradata/ORCLDB/cfg:/dbconfig \ --volume /oradata/ORCLDB/diag:/ORACLE_BASE/diag \ --volume /oradata/ORCLDB/audit:/ORACLE_BASE/audit \ --volume /oradata/ORCLDB/data:/u02 \ --volume /oradata/ORCLDB/redo:/u03 \ oracle/database:19.20-EE
55. @ViscosityNA www.viscosityna.com Container 19.20 Image /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit /etc/oratab
56. @ViscosityNA www.viscosityna.com Container 19.20 Image /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit /etc/oratab podman stop ORCLDB podman rm ORCLDB podman run --name ORCLDB \ --volume /oradata/ORCLDB/inv:/u01/app/oracle/oraInventory \ --volume /oradata/ORCLDB/cfg:/dbconfig \ --volume /oradata/ORCLDB/diag:/ORACLE_BASE/diag \ --volume /oradata/ORCLDB/audit:/ORACLE_BASE/audit \ --volume /oradata/ORCLDB/data:/u02 \ --volume /oradata/ORCLDB/redo:/u03 \ oracle/database:19.21-EE
57. @ViscosityNA www.viscosityna.com Container 19.21 Image /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit /etc/oratab
58. @ViscosityNA www.viscosityna.com Container 19.21 Image /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit /etc/oratab podman stop ORCLDB podman rm ORCLDB podman run --name ORCLDB \ --volume /oradata/ORCLDB/inv:/u01/app/oracle/oraInventory \ --volume /oradata/ORCLDB/cfg:/dbconfig \ --volume /oradata/ORCLDB/diag:/ORACLE_BASE/diag \ --volume /oradata/ORCLDB/audit:/ORACLE_BASE/audit \ --volume /oradata/ORCLDB/data:/u02 \ --volume /oradata/ORCLDB/redo:/u03 \ oracle/database:19.21-EE
59. @ViscosityNA www.viscosityna.com Questions
60. @ViscosityNA www.viscosityna.com Contact Me: sean.scott@viscosityna.com https://linktr.ee/oraclesean