Add Oracle Exadata Configuration Assistant Tutorial
Oracle Exadata Configura2on Assistant (OECA) for Exadata X5-‐2 & X4-‐8 Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | OECA for Exadata Overview X5-2 In-Memory X5-2 EF OLTP • New database workloads require different compute to storage raIos • ElasIc configuraIons allow users to incrementally expand compute and/or storage capacity as per their business needs • Oracle Exadata ConfiguraIon Assistant (OECA) for Exadata facilitates scoping and analyzing elasIc configuraIons and reporIng environmental specificaIons 16x Database Servers 5 x HC Storage Servers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 8x Database Servers 8x EF Storage Servers New ElasIc X5-‐2 ConfiguraIon in Detail X5-‐2 Quarter Rack (EF or HC) • Start with a Quarter Rack – 2 Database Servers – 3 Storage Servers • Add DB or Storage servers (max 22 per rack) EF X5-‐2 Database Servers – Mix EF and HC storage servers in same rack – No need for half rack upgrade, or full rack upgrade Extreme Flash • Assembled with requested servers by Oracle High Capacity • Standard Configura2ons also kept HC X5-‐2 Storage Servers – Or add servers incrementally at customer site – Can add X5-‐2 servers to older (v2 to x4) machines – Eighth Rack, Quarter Rack, Half Rack, Full Rack – Eighth to Quarter Upgrade (Compute, Storage, Both) Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | CreaIng Workload OpImized ConfiguraIons DB In-‐Memory Machine 16 Database Servers + 5 High Capacity Storage Servers Extreme Flash OLTP Machine Data Warehousing Machine 8 Database Servers + 8 Extreme Flash Storage Servers 8 Database Servers + 14 High Capacity Storage Servers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Other Database Machine Types Exadata Storage Expansion – Specialized rack with only Exadata Storage Servers • No database servers – 4 to 19 X5-‐2 storage servers X4-‐8 Database Machine – 2 to 4 8-‐socket Xeon DB servers • 2TB to 6TB DRAM each – 3 to 14 X5-‐2 storage servers – For high-‐end OLTP, large consolidaIon, in-‐memory DB Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | Introducing OECA – Simplifying the ElasIc ConfiguraIon Planning Process • OECA is an “Excel” Based Visual Basic applicaIon that will allow the user to rapidly plan Exadata ElasIc ConfiguraIon Scenarios • Release Notes – Requires Microsoi Excel – Must enable Macros in Excel – Windows Only Support for Now – These training slides reflect a recent version of the tool but may appear differently than the latest version of the tool Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | CreaIng a Workload OpImized ConfiguraIon • The following demonstraIon supports a planned Exadata X5-‐2 Database In-‐Memory Deployment DB In-‐Memory Machine • OECA for Exadata will produce a “visual” representaIon of the intended configuraIon • The tool will also produce the Performance and Environmental CharacterisIcs for this configuraIon – Similar to what is done in the Exadata Datasheet for Full, Half, Quarter, Eighth Racks etc. 16 Database Servers + 5 High Capacity Storage Servers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | CreaIng a Workload OpImized ConfiguraIon • Step 1 – Launch ApplicaIon DB In-‐Memory Machine – The Following Screen Appears 16 Database Servers + 5 High Capacity Storage Servers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | CreaIng a Workload OpImized ConfiguraIon • Step 2 – Select X5-‐2 in the “SelecIon” Dropdown DB In-‐Memory Machine Click X5-‐2 or DB Machine and SER Click X4-‐8 for 8 Socket Reset wipes the current Config Click 3 IB Switches to add a Spine. Min 2 Leafs required CalculaIons will appear once a legal configuraIon is selected 16 Database Servers + 5 High Capacity Storage Servers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | CreaIng a Workload OpImized ConfiguraIon • Step 3 – Increment the X5-‐2 DB to 16 DB In-‐Memory Machine DB Servers appear in the proper Uxx Rack locaIon and the proper order Note appears telling the user what to add to build a legal configuraIon 16 Database Servers + 5 High Capacity Storage Servers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | CreaIng a Workload OpImized ConfiguraIon • Step 4 – Increment X5-‐2L HC to 5 DB In-‐Memory Machine Memory, Storage and Number of Cores are calculated here Legal configuraIon achieved and calculaIons appear HC and/or EF Servers appear in the proper Uxx Rack locaIon and the proper order 16 Database Servers + 5 High Capacity Storage Servers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | CreaIng a Workload OpImized ConfiguraIon • Step 5 – Scroll to See the Environmental Report DB In-‐Memory Machine 16 Database Servers + 5 High Capacity Storage Servers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | CreaIng a Workload OpImized ConfiguraIon • Step 6 – Scroll to See the Performance Report DB In-‐Memory Machine 16 Database Servers + 5 High Capacity Storage Servers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | OECA for Exadata Summary X5-2 In-Memory X5-2 EF OLTP • Internal Tool to facilitate scoping and analyzing elasIc configuraIons and their environmental specs • Supports X5-‐2 DB Machine as well as Storage Server ElasIc ConfiguraIons • Supports X4-‐8 ElasIc ConfiguraIons • Allows quick reporIng and analysis of Exadata Performance, Cores, Memory, Power, Cooling etc for a given configuraIon • Visually demonstrates how the elasIc configuraIon will appear in the end system • QuesIons? Contact Gurmeet Goindi at [email protected] 16x Database Servers 5 x HC Storage Servers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. | 8x Database Servers 8x EF Storage Servers Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
© Copyright 2024