The Database Administrator's Guide to Cloud Native Databases

Cloud adoption is driving standardization on cloud-native technologies, and databases—which have (so far) avoided this trend—are under mounting pressure to fall into line. Make no mistake: databases running natively in the cloud enjoy the same benefits as any other application, and enterprises that hesitate will quickly yield a competitive advantage.

This session prepares database and systems administrators for the inevitable cloud-native future. It illustrates key differences between legacy infrastructure and container platforms, how to leverage container architecture to simplify database management, ways to jump-start and scale adoption in their organization, and how cloud-native technologies generate strategic and business value.

Transcript

1. LAOUC Community Tour 2024 2 a 23 de Agosto 2024 The Database Administrator’s Guide to Cloud Native Databases
2. Database Reliability Engineering MAA ⁘ RAC ⁘ RMAN 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
3. www.viscosityna.com @ViscosityNA Oracle on Docker Running Oracle Databases in Linux Containers Free sample chapter: https://oraclesean.com
5. km mi Mexico 3,584 2,227 Guatemala 1,056 656 Costa Rica 854 531 Panama 1,813 1,127 Chile 4,985 3,098 Brazil 2,617 1,626 Uruguay 1,567 974 Argentina 221 137 Paraguay 1,037 644 Home 9,753 6,061 ------ ------ 27,487 17,081 ¡Me gustan los aviones! ¡Me gustas tú! ¡Me gusta viajar! ¡Me gustas tú! ~ Manu Chao
6. @ViscosityNA www.viscosityna.com What are containers?
7. @ViscosityNA www.viscosityna.com Three complete operating systems Three application/executable directories
8. @ViscosityNA www.viscosityna.com Three complete operating systems Three application/executable directories
9. Containers are like lightweight virtual machines, right?
11. @ViscosityNA www.viscosityna.com www.viscosityna.com @ViscosityNA 13 Oracle DB on a laptop 2018 MacBook Pro 15", 2.2GHz 6-core Intel Core i7, 16GB, 1TB SSD
12. @ViscosityNA www.viscosityna.com Virtual Machines: Start a complete OS Containers: Support a single application or service
13. @ViscosityNA www.viscosityna.com Virtual Machines: Start a complete OS A 100-page book of puzzles and games. Containers: Support a single application or service
14. @ViscosityNA www.viscosityna.com Virtual Machines: Start a complete OS A 100-page book of puzzles and games. Containers: Support a single application or service A single page of paper with a Tic-Tac-Toe board.
16. @ViscosityNA www.viscosityna.com Games have a playing surface and structured rules.
17. @ViscosityNA www.viscosityna.com Services support games and players.
18. @ViscosityNA www.viscosityna.com Images include the rules and game board for a service.
19. @ViscosityNA www.viscosityna.com Images are the minimum necessary collection of files and metadata needed to run a service.
20. @ViscosityNA www.viscosityna.com Executing an image starts a container.
21. @ViscosityNA www.viscosityna.com A container is: a host process and a Union File System.
23. @ViscosityNA www.viscosityna.com A Union File System has three layers: A union or overlay layer. An upper layer. A lower layer.
24. @ViscosityNA www.viscosityna.com A Union File System has three layers: A union or overlay layer: The game. An upper layer. The moves. A lower layer. The playing surface and rules.
26. @ViscosityNA www.viscosityna.com The union (overlay) layer is not "real".
27. @ViscosityNA www.viscosityna.com The union (overlay) layer is not "real". It’s a perceived (calculated) view of the superimposed layers below.
28. @ViscosityNA www.viscosityna.com The union (overlay) layer is not "real". It’s a perceived (calculated) view of the moves and game board.
29. @ViscosityNA www.viscosityna.com Containers are magic!
30. @ViscosityNA www.viscosityna.com Three complete operating systems Three application/executable directories
31. @ViscosityNA www.viscosityna.com How much space is used by three containers? 500MB + 500MB + 500MB 500MB 1, 500MB 500MB 500MB +
32. @ViscosityNA www.viscosityna.com Multiple identical containers share a single image.
33. @ViscosityNA www.viscosityna.com Multiple similar containers share common image layers.
34. @ViscosityNA www.viscosityna.com Containers save their state (the moves) in the upper layer of their Union Filesystem. Containers are stateful.
35. @ViscosityNA www.viscosityna.com Container Properties
36. @ViscosityNA www.viscosityna.com Containers are ephemeral.
37. @ViscosityNA www.viscosityna.com Deleting a container deletes its layer.
38. @ViscosityNA www.viscosityna.com Ephemeral has no time limit.
39. @ViscosityNA www.viscosityna.com Ephemeral has no time limit. On a large enough scale, everything is ephemeral.
40. @ViscosityNA www.viscosityna.com Images are immutable and never change.
41. @ViscosityNA www.viscosityna.com Stalemate!
42. @ViscosityNA www.viscosityna.com
43. @ViscosityNA www.viscosityna.com
44. @ViscosityNA www.viscosityna.com Volumes
45. @ViscosityNA www.viscosityna.com Volumes "externalize" container directories.
46. @ViscosityNA www.viscosityna.com Database containers DB Software Configuration Data Container Local disk Container layer
47. @ViscosityNA www.viscosityna.com Rule #1 for database images: If a database exists, start it. If not, create a new database.
48. @ViscosityNA www.viscosityna.com Starting a database container docker run -d \ --name ${CONTAINER_NAME} \ -v /data/${CONTAINER_NAME}:<data_directory> \ <image_name>
49. @ViscosityNA www.viscosityna.com Rule #1 for database images: If a database exists, start it. If not, create a new database.
50. @ViscosityNA www.viscosityna.com Database containers DB Software Configuration Data Container Local disk Container layer
51. @ViscosityNA www.viscosityna.com Database containers DB Software Configuration Data Container Local disk Container layer
52. @ViscosityNA www.viscosityna.com Cloning a database cp -rpT /data/${CONTAINER_NAME}/ \ /data/clone
53. @ViscosityNA www.viscosityna.com Cloning a database cp -rpT /data/clone/ \ /data/${CONTAINER_NAME}
54. @ViscosityNA www.viscosityna.com Cloning a database cp -rpT /data/clone/ \ /data/${CONTAINER_NAME} cp -rpT /NFS/gold_data/clone/ \ /data/${CONTAINER_NAME}
55. @ViscosityNA www.viscosityna.com Building Images
56. @ViscosityNA www.viscosityna.com A Containerfile is a recipe for creating an image.
57. @ViscosityNA www.viscosityna.com Oracle Enterprise Linux 8 Oracle 19.20 patch Oracle 19.21 patch Oracle 19.3 Prerrequisitos
58. @ViscosityNA www.viscosityna.com Upgrading a database in a container Oracle 19.20 Configuration Data Container Local disk Container layer
59. @ViscosityNA www.viscosityna.com Upgrading a database in a container Oracle 19.20 Configuration Data Container Local disk Container layer
60. @ViscosityNA www.viscosityna.com Upgrading a database in a container Configuration Data Container Local disk Container layer Oracle 19.21
61. www.viscosityna.com @ViscosityNA Questions and Contact Me sean.scott@viscosityna.com https://linktr.ee/oraclesean