17 Mar Video: Extra-Large Oracle Databases on AWS – RMOUG Training Days 2020 Session
FlashGrid was proud to be the Diamond Sponsor of Rocky Mountain Oracle User Group Training Days 2020 conference, held on February 18th-20th in Denver, CO.
Art Danielov, CEO/CTO of FlashGrid, gave a presentation about extra-large Oracle databases on AWS. The proposed architecture enables running databases over 100 TB in size on Amazon Web Services EC2 infrastructure.
We published the full video of the session. For your convenience, below is an index of slides and key topics that were discussed.
0:44 Start of the talk
1:23 Challenges of running 100+ TB database on AWS
4:22 Meet EC2 i3en.metal and r5n.metal instances
5:56 How to make use of i3en.metal / r5n.metal for 100+ TB databases?
7:30 SkyCluster for AWS | Engineered Cloud System
9:00 Extra-Large Single Instance Databases
13:50 Question: Failgroups
14:21 RAC, 3-way Mirroring
20:07 RAC, 3-way Mirroring, extra EBS storage
20:54 RAC, 2+2 Mirroring, Multi-AZ
25:08 RAC, 1+1 Mirroring
27:47 Question: read-intensive services and ASM
29:08 Question: ASM, failgroups, different disk types
30:21 Question: migrating data to a cluster on AWS
31:35 Question: switching over to cluster on AWS
31:56 RAC, 2+1 Mirroring
32:49 RAC, 2+1 Mirroring, Multi-AZ
34:15 3 RAC nodes, up to 60 TB
35:43 Question: can this be deployed in practice?
36:10 Question: voting disk
37:48 2 RAC nodes, up to 60 TB
38:12 Question: 2-node vs 3-node configurations
39:35 Question: EBS and local disks
40:53 Question: is data loss possible?
42:31 Some more background info about SkyCluster for AWS
42:40 SkyCluster | Oracle DBA Friendly
45:12 SkyCluster | Security and Control
46:19 SkyCluster | Compatibility
47:38 SkyCluster | Tech Support
49:29 SkyCluster Launcher for AWS
52:15 Contact info for questions and links to more information