Oracle Exadata Database Machine racle Exadata Database Machine (Exadata) is a combined compute and storage system optimized for running Oracle Database pc software. Exadata debuted in 2008 because the first in Oracle’s group of “Engineered Systems”, understood to be software and”hardware engineered to come together”. New generations of Exadata are released approximately once a year.
Exadata combines compute that is scale-out, scale-out storage servers, InfiniBand networking and specialized software, packed in several hardware racks, with various sizing options. Exadata compute servers use Intel Xeon processors and the Oracle Linux operating system to run Oracle Database computer software. Exadata storage servers perform block storage functions and additionally run Exadata Storage Server Software to offload data database that is intensive into storage space, closest to the information.
Exadata DBA training
It really is Oracle’s claim that optimizing the entire compute/storage/networking infrastructure in Exadata for the Oracle Database permits it to end up being the most readily useful possible database host platform and that pre-integrating all the pc software and hardware simplifies setup, management, and troubleshooting for customers. Critics of Exadata point out that this limits it to operating Oracle Databases, and it cannot be used as a general-purpose host. Industry analysts at IDC classify Exadata as an “Integrated Platform” with Oracle Engineered Systems having over 50% market share as of March, 2015. Analysts at Gartner destination Oracle Engineered Systems in the leaders quadrant of their “Integrated Systems Magic Quadrant” report for 2014, giving Oracle the vendor that is top for “Integrated Stack techniques”.
As of 2015, Exadata is also available in the Oracle Public Cloud as a subscription service – the Oracle Database Exadata Cloud Service, also known simply as the Exadata Service october. Databases deployed in this Service include most of the features and choices of Oracle Database Enterprise Edition. Similarly, all Exadata features and capabilities are most notable Service. Oracle databases in the Exadata Service are 100% compatible with databases implemented on-premises, which enables customers to transition to the Cloud with no application changes. The infrastructure because of this service – such as the equipment, network, platform software and Exadata software, is handled by Oracle, while customers have complete ownership of their databases. Customers can perform all provisioning that is necessary the Oracle Cloud portal, with cloud-based automation tools available for backups, patching, expansion, etc.
Exadata is made to optimally run any Oracle Database workload or mix of workloads. Long running requests, characterized by information warehouse queries, reports, batch jobs and analytics, are reputed to run several times faster when compared with a main-stream, non-Exadata database server. Client references often cite performance gains of 10x or greater. Analytics workloads can additionally make use of the Oracle Database In-Memory option on Exadata for extra acceleration. Exadata’s ” Hybrid compression that is columnar feature is intended to cut back the storage usage of information warehouses and archive data because well as increase performance by reducing the number of I/O.
Transactional (OLTP) workloads on Exadata gain benefit from the incorporation of flash memory into Exadata’s storage hierarchy, and the”tiering that is automatic of data into memory, flash or disk storage space. Special flash algorithms optimize flash for response time database that is sensitive such as log writes. For high-end OLTP, all-flash storage (see Extreme Flash Storage Server below) eliminates the latency of disk media entirely.
All Exadata workloads take advantage of an extremely bandwidth that is high low latency internal InfiniBand material running a specialized database network protocol called iDB.
Database consolidation on Exadata is typical. To attenuate resource contention between competing databases and workloads, “resource management” features of Exadata enable prioritized allocation of CPU, I/O and network bandwidth.
Oracle Exadata Database Machine is for sale in two variants: one centered on two-socket database servers and one other based on eight-socket database servers. The two models differ only in the hardware used for the compute servers. The networking, storage servers and software are the same in both models.
The most Oracle that is recent Exadata Machine could be the X6 generation introduced in April, 2016.
The X6-2 compute servers feature a form that is small, 1 RU (Rack Unit) in height. They employ 2-socket Intel Xeon processors; each socket with 22 compute cores for 44 cores that are total compute server. Memory starts at 256 GB and will be expanded to 768 GB.
The Exadata X6-2 Database Machine base configuration has 2 compute servers and 3 storage servers, named a “Quarter Rack”. The same hardware is also obtainable in an “Eighth Rack” configuration with half of this processing turned off and half of the storage capacity either turned off or removed until needed. As the database workload and/or data size increases, additional compute and storage servers may be added to improve the amount of work performed in parallel. This is commonly called “scale-out”.
The X6-8 compute server makes use of servers that are eight-socket consume 5 RU in height and possess greater memory capacity compared to the X6-2. Whereas each X6-2 compute server contains 44 compute cores, the X6-8 server contains 144 compute cores. This permits big database workloads to easily “scale-up” within a compute server while nevertheless supporting Exadata’s “scale-out” expandability across multiple servers. The larger memory capacity of the X6-8 additionally favors in-memory database and very big OLTP, consolidation, and DW workloads. The Exadata X6-8 base configuration has 2 compute servers and 3 storage servers, but consumes a “Half Rack” of space like the x6-2. Additional compute and storage servers might be added until the rack is full.