Archived Exadata Webcasts:
- Oracle Exadata Storage Server Technical Deep Dive. Part I.
- Agenda for Part I:
- Brief Technical Architecture Overview
- Understanding Producer/Consumer Data Flow Dynamics
- Some “How” and “Why” Comparisons of Exadata versus Conventional Storage
- Storage Join Filters
- Agenda for Part I:
Note: There is 4 minutes and 30 seconds of “dead air” at the begging of this webcast. Please advance your player to the point prior to playback.
- Oracle Exadata Storage Server Technical Deep Dive. Part II.
- Agenda for Part II:
- Where Does All That “Brainy” Software Fit In?
- More on Storage Join Filters (we were a bit rushed for time in Part I)
- What Value Proposition Does Exadata Bring to “Brainy” Software?
- Agenda for Part II:
- Oracle Exadata Storage Server Technical Deep Dive. Part IV.
- Agenda for Part IV:
- I Need Scalable Shared Storage for Real Application Clusters Data Loading!
- Where Am I Supposed to Stage My Flat Files?
- Oracle Database File System (DBFS)
- Introduction
- Brief Architectural Overview
- Performance Baseline (synthetic)
- Brief Administrative Commands Overview
- Staging Flat Files
- Loading from DBFS-based External Tables
- Agenda for Part IV:
The following are some of my (not so) recent papers: Some of these require membership to their respective websites. A Paper About Oracle’s Direct NFS Feature in Oracle11g (www.oracle.com) The Flexible Database Cluster Architecture These papers cover the deployment methodology known as the Flexible Database Cluster for Oracle Real Application Clusters (RAC). The Flexible Database Architecture consisted of Linux Servers, SAN Storage, Oracle and HP/PolyServe:
- A 16-Node Linux Cluster for RAC–The Flexible Database Cluster Architecture. This was the paper that covered the first series of FDC proof of concept testing. The testing was done in IBM’s labs in Raleigh N.C. The paper was accepted into OOW proceedings that year, hence the OOW “skin”.
- Joint IBM Whitepaper Covering AMD Opteron based BladeCenter Flexible Database Clusters Architecture (Architecture, Fault Injection Analysis, Performance), or you can get it from AMD’s site here.
- A Consolidation proof point of 60 Oracle10g databases managed within a 14-Node Linux Cluster. Joint IBM Whitepaper Covering a 14-Node BladeCenter Implementation of the Flexible Database Cluster Architecture (Architecture, RAC Performance, Linux Clusters)
- A Couple of TechTarget Webinars:
The Tens Project The Tens Project was the largest Oracle9i RAC database on Linux at the time it was executed. This paper covers a proof of concept of a 10TB database (on 10TB of redundant SAN storage) accessed by a 10-Node Linux cluster running Oracle9i Real Application Clusters servicing 10,000 simulated users. Imagine that, a VLDB RAC configuration way back in 2002. Scalable Fault-Tolerant NAS for Oracle This paper covers many NAS architecture topics related to Oracle and provides good coverage of scalable NAS principles in general. Book Collaborations I was the technical reviewer and I also contributed to Julian Dyke and Steve Shaw’s Oracle10g RAC on Linux book. I contributed to Madhu Tumma and Mike Ault’s Oracle10g Book from Rampant Press. The most enjoyable book effort I was ever a part of was this section of James Morle’s book Scaling Oracle8i which, while outdated (only by Oracle release number), is a very important book for anyone trying to get deep into Oracle. Very Old Papers Even though this paper about multiple buffer pools in Oracle, still available on the Computer Measurement Groups’s website, covers a topic in Oracle8i the principles of the paper are still useful in an Oracle10g environment. I intended to re-validate the measurements with 10gR2 as soon as possible, but in the meantime, if you are a member of CMG, this paper might be worth a read. And there was this Solid State disk related paper from 2001.
Gidday Kevin. The link “PolyServe’s ODM I/O Monitoring User Guide” doesn’t work. Love this site – just found it.
Hi Kevin,
Regarding the HP Enterprise File Service NAS gateway device, I remember reading in an earlier post that you were part of the team benchmarking the device before you moved to Oracle.
Does the Enterprise File Service NAS gateway device do double-caching (At the NAS and the SAN) or simply passes the request onto the SAN device behind it? I could not find much information about this aspect in the whitepaper. Also regarding snapshots – does it need to be done on the Array or does the NAS gateway do snapshots on it’s own?
Thanks
Krishna
Krishna,
The EFS Clustered Gateway will serve files from its filesystem using direct I/O if you wish, so the cache model using Oracle in that case would be:
SGA->SAN Array Cache->Track Buffer per drive
The layers omitted are the the page cache on the DB server (NFS client) since Oracle uses O_DIRECT opens and the page cache on the NAS heads in the CG since you would tend to mount file systems with the EFS CG DBOptimized mount option…although testing might show you much improved performance allowing the NAS gateway heads to cache as well.
I’m not at HP any longer, but I know that it isn’t until the next major release of the EFS CG software (runs in the NAS heads analogous to NetApp OnTap) that the product will support snapshots in the NAS tier. So, today you have to use the downwind EVA/XP snapshots and replication (e.g., EVA CA).
Yes, I did the testing and was in fact the Chief Architect of all Oracle solutions on that platform. If I hadn’t been, there would be no Oracle support on the EFS CG since there was a significant bit of correctness that needed to be architected early on.
Hi there
Sure it got mentioned some where, where is episode 3 of Oracle Exadata Storage Server Technical Deep Dive. I see 1,2 and 4.
Thanks
G
Ah, George…you know from the inside why I’m too busy.
Hi there
ahh, ok so not posted yet, still trying to dig yourself out of the mountain size pile of work then.
G
Kevin
Regarding Exadata V1, is it logically possible to build a non-Oracle supplied DBM?
e.g. procure and build 8 x DL360s and 14 x DL180s. Create a 8 node RAC configuration across the 360s using the storage presented by the dedicated storage servers (180s). If so, how would the storage be presented to ASM from the 14 nodes as one logical pool? Would ASM have the capability to direcly manage disk mirroring? Would i need to configure the dedicated storage servers built out in the cab independently to expose block data to all of the RAC compute nodes? If so, how – global network block devices/cluster lvm/GFS etc?
Look fwd to hearing from you.
Best.