The Hitchhiker's Guide to Cloud Native Databases: Prepare for the Cloud Native database future! (South Korea - Dec 4)

Transcript

1. The Hitchhiker's Guide to Cloud Native Databases Prepare for the Cloud Native database future APAC Tour '23 December 4, 2023 Seoul, South Korea @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 Running Stateful Workloads in Containers
14. @ViscosityNA www.viscosityna.com Containers are building blocks for the Cloud
15. @ViscosityNA www.viscosityna.com Containers increase Reliability
16. @ViscosityNA www.viscosityna.com Containers improve Durability
17. @ViscosityNA www.viscosityna.com Containers are Portable
18. @ViscosityNA www.viscosityna.com Containers maximize Capacity
19. @ViscosityNA www.viscosityna.com Containers deliver higher Performance
20. @ViscosityNA www.viscosityna.com Containers are more Efficient
21. @ViscosityNA www.viscosityna.com Containers are more Cost Effective
22. @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
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
24. @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!
25. @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
26. Containers are like lightweight Virtual Machines, right?
28. @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
30. @ViscosityNA www.viscosityna.com Games have structured playing surfaces and rules.
31. @ViscosityNA www.viscosityna.com Services deliver games to players.
32. @ViscosityNA www.viscosityna.com Images include the game rules and playing surface.
33. @ViscosityNA www.viscosityna.com Images are a minimal filesystem & metadata needed to run a service.
34. @ViscosityNA www.viscosityna.com Running an image starts a Container.
35. @ViscosityNA www.viscosityna.com A container is: A process on a host, and; A Union Filesystem.
36. @ViscosityNA www.viscosityna.com Container processes are isolated.
37. @ViscosityNA www.viscosityna.com A Union Filesystem has three layers: A Merge or Union Layer. An Upper Layer. A Lower Layer.
38. @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.
39. @ViscosityNA www.viscosityna.com
40. @ViscosityNA www.viscosityna.com The Upper (merge) layer isn't "real."
41. @ViscosityNA www.viscosityna.com The Upper (merge) layer isn't "real." It's a perceived (calculated) union of: • The game board & rules • Game play
42. @ViscosityNA www.viscosityna.com Containers persist state (moves) in the run-time layer of its Union Filesystem. Containers are stateful.
43. @ViscosityNA www.viscosityna.com Deleting a container removes its Union Filesystem (and its run-time layer). Containers are Ephemeral
44. @ViscosityNA www.viscosityna.com Images are immutable and never change.
45. @ViscosityNA www.viscosityna.com Stalemate!
46. @ViscosityNA www.viscosityna.com Shift the Image Right Moves fall off the game board: Changing an image changes the game!
47. @ViscosityNA www.viscosityna.com Images are immutable and can't persist state information. They are stateless.
48. @ViscosityNA www.viscosityna.com Images = Static templates Containers = Editable documents
49. @ViscosityNA www.viscosityna.com Containers are Magic!
50. @ViscosityNA www.viscosityna.com How much space do three containers use? 500MB + 500MB + 500MB 1,500MB 500MB 500MB 500MB + 500MB
51. @ViscosityNA www.viscosityna.com Multiple identical containers will share an image.
52. @ViscosityNA www.viscosityna.com Different containers share common layers.
53. @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
54. @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
55. @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
56. @ViscosityNA www.viscosityna.com Container /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit
57. @ViscosityNA www.viscosityna.com Container Image /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit
58. @ViscosityNA www.viscosityna.com Container Image /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit 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
59. @ViscosityNA www.viscosityna.com Container 19.20 Image /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit
60. @ViscosityNA www.viscosityna.com Container Image /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit 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
61. @ViscosityNA www.viscosityna.com Container 19.21 Image /etc/oratab /u01 ORACLE_HOME/dbs ORACLE_BASE/diag ORACLE_HOME/network/admin /u02 /u03 oraInventory ORACLE_BASE/audit
62. @ViscosityNA www.viscosityna.com Questions
63. @ViscosityNA www.viscosityna.com Contact Me: sean.scott@viscosityna.com https://linktr.ee/oraclesean