What the heck is Exadata storage

At OpenWorld last week, Oracle and HP announced an HP Oracle database machine and Exadata storage server hardware. product page.

If you read the news article, which has a broken link from the Oracle home page, you get the basics that HP and Oracle have jointly announced a new rack solution that is pre-configured to run the Oracle 11g database in a real application cluster (RAC), using 64 processing cores, Oracle Enterprise Linux, and upto 168 Terabytes of storage. The servers are HP Proliant D180 servers with two Intel 2.66 Ghz quad-core processors, capacity for 12 three and a half inch disks, 8G of memory, and dual InfiniBand network connections. I recommend reading more in the data sheet. What is new from Oracle is the Exadata Storage Server Software to manage this storage. Along with this is a new plug-in for Enterprise Manager to help manage this storage device.

The difference between this and standard storage is that the storage can either be raw storage or can be used as an offload storage device to minimize queries. It is typically used for a data warehouse where queries return large sets of data. With the exadata storage software, the storage processors can pre-process the SQL request and return the results to the database engine. It is important to note that this software is designed to be used with the HP hardware and only the HP hardware. It is not designed to be used with other servers or storage solutions. This product is directly targeted at the Netezza and Teradata solutions. The intent is to bring some of these old solutions to 10g and beyond and help with performance tuning. Most of the Netezza and Teradata solutions are on 9i or older and not tuned very well. A high end comparison of the Netezza, Teradata, and HP-Oracle solution shows that they both hold the same amount of disk but the HP-Oracle solution has substantially more database cores (4 for Netezza, 32 for Teradata, and 64 for HP-Oracle). The HP-Oracle solution also has 3x the memory and 20x the network speeds. Many of the Netezza customers are running into scalability problems where they need multiple boxes to host the data and are running into one source of truth issues because some data is replicated on both boxes and there are no consistency tools to keep the data synchronized.

You can scale the solution from one box to 18 boxes inside of one physical hardware rack. This gives you 65 Terabyes of storage using SAS storage or 216 Terabytes using SATA storage. The peak performance inside the box is 18 GB/second for data transfer. You can also use Infiniband to connect to another hardware rack to scale across multiple servers since each system has 2 Infiniband switches. The database engine comes pre-installed but is not configured to use RAC, partitioning, advanced compression, security, or enterprise manager options like diagnostic and tuning. You can run this system in single instance without RAC and split the data appropriately for a data warehouse. The single instance is configured to have a database instance that is managed by ASM. ASM then knows how to talk to the Oracle exadata cell manager and offload the queries to the exadata cell. You can have multiple exadata cells behind the Infiniband switch.

The 11g database has been enhanced to take advantage of the exadata storage. A new component called iDB (Intelligent Database protocol) runs in the database kernel and maps database operations to the exadata processors or launches the query locally. This protocol allows the exadata processors to perform functions like table scans, compression, and OLAP functions. The iDB protocol is built on top of RDSv3 (Reliable Datagram Sockets) and runs over InfiniBand. All of these protocols are open standard and publicly defined.

Two important points about this architecture is that when a SELECT…WHERE is issued against a table, a traditional storage device will return the table and the database engine will sort the where clause and drop the results that are not relevant. The exadata storage will do the select and the sort at the disk and only return the results after the where clause is performed. The second way of reducing the data transferred is to return only the columns requested and not the whole table. In a traditional storage device the table is returned and the columns that are not requested are dropped. In the exadata storage, the storage processor will perform the sort and only return the requested information across the data channel.

Another new feature of the exadata storage node is the ability to manage I/O resources. In traditional database management, you have been able to allocate CPU and memory utilization based on jobs or processes. You can allocate 30% of your processing to finance and 70% of your processing to payroll. The problem with this model is that a finance job could swamp the I/O resources with a simple request even though it does not use more than 30% of the processor. With the exadata storage you can allocate resources to the I/O channel as well. With this model you get 30% of your I/O allocated to finance as well as 30% of your database engine.

One of the impacts that this might have on business is that a single user can be given 10% of a machine and 10% of the I/O bandwidth. This user can be given the ability to run ad-hoc queries into the data warehouse without consuming more than 10% of all resources. This isn’t true with most business intelligence engines. We typically see problems with Cognos or Business Objects systems in products. Database resources can be restricted to a user or group and not let them overload the storage system with open ended queries.

The sales model for this box is a little different. Oracle sells the product and HP delivers the hardware pre-configured to the customers. Oracle handles the first line of support and HP provides the 2nd tier along with break-fix and spares. This machine does not come with database licenses. This allows customers to use existing licenses and not have to purchase new licenses. The warranty for this machine is 3 years parts and labor.

For those of you that are graphical in nature, technical” overview, is a good pictorial review of what I have been talking about.

My gut feeling… this is a new technology. It is a game changer. The big question is will this become mainstream for many companies or will it just be an Amazon and Google solution? If I were a hosting company and wanted to host Oracle, this would be the solution. I would choose this over visualization any day. If I were a telco or vendor with a large number of customers that needed target marketing, it would be an easy choice. My biggest problem is that in Houston, this isn’t the case outside the oil and gas industry. It might be viable for health care. It might be viable for utility companies. It might be viable for service companies. Time will tell.

418 thoughts on “What the heck is Exadata storage”

  1. I am glad for commenting to let you understand of the remarkable experience my cousin’s daughter undergone reading through yuor web blog. She learned a wide variety of details, with the inclusion of what it is like to have an ideal coaching character to have the mediocre ones completely master specific problematic subject matter. You undoubtedly did more than our expectations. I appreciate you for offering those useful, healthy, edifying and even easy guidance on the topic to Jane.

  2. I needed to put you one bit of note so as to give many thanks once again with your exceptional ideas you’ve featured in this article. This has been simply particularly open-handed of you to provide freely what many people would have supplied as an e book to get some money for their own end, principally given that you could possibly have done it in the event you wanted. These strategies also served to provide a easy way to be certain that many people have the identical zeal the same as my very own to see many more when considering this problem. Certainly there are a lot more fun moments in the future for individuals that examine your blog.

  3. A lot of thanks for all your valuable work on this web page. Kate enjoys carrying out investigation and it’s really easy to understand why. Many of us notice all concerning the dynamic means you render efficient guides by means of this blog and strongly encourage response from visitors on this situation plus our favorite child is truly becoming educated a whole lot. Enjoy the remaining portion of the year. You have been carrying out a splendid job.

  4. I truly wanted to compose a small message to thank you for all of the nice points you are posting at this site. My extended internet research has at the end of the day been compensated with reasonable strategies to write about with my good friends. I ‘d say that we site visitors actually are very lucky to be in a good place with very many perfect professionals with helpful things. I feel quite grateful to have seen the webpage and look forward to so many more cool minutes reading here. Thanks a lot once more for all the details.

  5. I and also my buddies were actually digesting the great information found on the website while before long I got a terrible suspicion I had not expressed respect to the web site owner for those tips. My ladies are actually totally very interested to read through all of them and have in reality been taking pleasure in these things. We appreciate you simply being considerably kind and for deciding on these kinds of awesome issues most people are really wanting to know about. My very own honest apologies for not expressing appreciation to sooner.

  6. I want to point out my passion for your generosity giving support to men and women that really need assistance with your area of interest. Your real commitment to passing the message all through came to be incredibly good and has regularly helped those like me to realize their goals. Your amazing interesting publication indicates much a person like me and much more to my peers. Warm regards; from each one of us.

  7. I needed to compose you the little note to finally thank you so much once again on your wonderful secrets you have shown on this page. It’s quite extremely generous of you to supply unhampered all most people might have offered for sale as an ebook to generate some bucks for themselves, principally considering the fact that you might well have tried it if you ever wanted. The points as well served as a fantastic way to recognize that someone else have a similar desire like my own to know the truth great deal more on the subject of this issue. I know there are thousands of more pleasant times ahead for people who read your blog post.

  8. I truly wanted to construct a quick comment to thank you for those lovely points you are sharing here. My extended internet look up has finally been paid with good insight to talk about with my classmates and friends. I would mention that most of us readers actually are undeniably fortunate to exist in a notable network with so many outstanding individuals with useful guidelines. I feel truly happy to have come across your entire webpages and look forward to so many more pleasurable minutes reading here. Thanks again for everything.

  9. I not to mention my guys happened to be checking the best thoughts found on the website then all of the sudden developed a terrible feeling I had not expressed respect to the blog owner for those secrets. The young men came for that reason happy to see all of them and now have pretty much been using those things. Thank you for getting so kind and also for considering certain remarkable subjects most people are really desirous to learn about. Our sincere apologies for not expressing appreciation to earlier.

  10. I needed to write you one bit of remark so as to say thank you yet again for these striking methods you have provided on this page. It was quite extremely open-handed with people like you to offer extensively exactly what some people would have supplied as an ebook to earn some profit for themselves, most importantly seeing that you could have done it in the event you considered necessary. Those tactics additionally worked to become easy way to be aware that most people have the identical desire similar to my own to know the truth great deal more with regards to this matter. I am certain there are many more pleasurable periods ahead for folks who scan your blog.

Leave a Reply

Your email address will not be published. Required fields are marked *