Breakthrough Performance, Scaling, Reliability and Efficiency
Mellanox InfiniBand and Ethernet server adapters and switches provide fault-tolerant and unified connectivity between database servers and storage, allowing for very high efficiency of CPU and storage capacity usage. The result is a significantly higher level of performance at reduced hardware cost. In fact, the leading database providers already provide Scale-Out products over Mellanox RDMA-based interconnect solutions:
» Oracle Exadata
Oracle Exadata - 10X the Performance at 50% Hardware Cost
Using Mellanox QDR 40GbE/s InfiniBand Oracle RAC query throughput performance can reach 50GbE/s.
Mellanox QDR 40GbE/s InfiniBand-based server adapters and switches provide fault-tolerant and unified connectivity between clustered database servers and native InfiniBand storage, allowing for very high efficiency of CPU and storage capacity usage. The result is 50% less hardware cost to achieve the same level of performance.
The InfiniBand network within an Oracle Database Machine and Exadata II is a whopping 880GbE/s, and the high-performance I/O pipe to the Exadata storage array delivers 21GbE/s of disk bandwidth, 50GbE/s of flash cache bandwidth, and 1 million IOPS.
The Mellanox InfiniBand network allows the Oracle Database Machine and Exadata systems to scale to 8 racks of servers and hundreds of storage servers by just adding wires - allowing servicing of multi-petabyte databases at breakneck speeds in a fully fault-tolerant and redundant environment.
For more Information please read:
» IBM DB2 pureScale
IBM DB2 pureScale - Keeping Up with Today Business Demand
Today, response times for banking transactions are measured in seconds. To remain competitive in such an environment, enterprises need a continuously available, scalable, and high-performance infrastructure that can accommodate not only growth over time, but also peaks in activity and demand. With its ease and transparency of system and application scaling, the clustering technology of IBM DB2 is designed for these environments. DB2 provides the scale-out capabilities that enable enterprises to meet a full spectrum of processing requirements.
One of the key elements of a DB2 server cluster is the high-speed fabric interconnect between the DB2 members and the central DB2 pureScale component, the DB2 Cluster Caching Facility (CF). Mellanox connectivity solutions enable DB2 pureScale to run at the highest performance and efficiency and achieve extreme scalability as demand grows.
For more information please read:
- SAP over DB2 pureScale
- DB2 pureScale over Mellanox Interconnect Solutions
- Virtualize the IBM DB2 pureScale over RoCE
» Microsoft SQL Server 2012
Microsoft SQL Server 2012 - Analyze 1,000 Terabytes of data in 1 second
There has never been a more exciting time in the world of data which is fundamentally transforming the industry. Enterprises that use data and business analytics to drive decision-making are more productive and deliver higher return on equity than those that do not. As such, the modern solutions must also support non-traditional data sources like big data. In order to help organizations successfully transition to the modern world of data, Microsoft introduced SQL Server 2012 Parallel Data Warehouse (PDW) appliance - the next version of the scale-out massively parallel processing (MPP) data warehouse appliance that includes a breakthrough data processing engine that enables query across Hadoop and relational database at the same time.
The PDW appliance runs Microsoft SQL 2012 Built over commodity servers and Mellanox 56GbE/s FDR InfiniBand solution as the unified interconnect between servers and storage and enables access to storage over the Remote Direct Memory Access (RDMA) mechanism. It results in increased speed, scalability, requires fewer computing resources and less IT efforts. Benchmarks shows that compared to the previous generation, the new PDW appliance completes queries 50 times faster and doubles the rate of data loading speed. However the new performance record requires 50% less hardware along with 50% reduction in energy consumption.
For more information please read:
Online Transaction Database
In recent years, clustering has become the technology of choice for database systems. It has proven to be the most efficient way to meet today’s business requirements: high performance, high-availability, and scalability at a lower cost of ownership. In order to achieve these goals it is critical to choose the right interconnect solution.
One of the most important parameters that a business process must meet is its Recovery Time Objective (RTO), which defines the maximum allowed downtime of a service due to failure. Not meeting RTO can result in the unacceptable consequences associated with a break in business continuity. As most enterprise applications use databases, RTO must also include the time required to restore the entire database. For example, the expected RTO for databases used in data warehouses is between 12 hours and a few days. However, this RTO range surely cannot apply to Online Transaction Processing (OLTP) systems, where the expected RTO is much more challenging and is in the order of minutes to a few hours, depending on the size of the database storage.
Recently, a tier-1 Fortune 100 Web2.0 company wanted to build a high performance database system that would be capable of handling tens of millions of mobile user requests per day in real time, while keeping the total cost of ownership intact.
The company's original database system was based on 1GE network technology, which presented a number of challenges: Scaling the architecture and technology infrastructure was expensive and time consuming; the company's ability to meet the demands of a near-real-time response to its mobile customers was limited; and, in case of database failure, it took them more than 7 days to restore the database system, which was extremely slow compared to their 6-hour goal. This brought the company to consider using a faster and more efficient interconnect technology that would enable the company to meet all these demands, while also cutting down the costs associated with maintaining the infrastructure.
Working jointly with Mellanox Technologies, a leading supplier of end-to-end connectivity solutions for data center servers and storage, a modular database clustered solution was developed that utilizes Mellanox end-to-end InfiniBand and Ethernet Technologies. The solution supports the deployment of a single database across a cluster of servers and provides superior fault tolerance, performance, and scalability without any need to change applications. The solution provides a near-real-time response for the mobile users and also a 4-hour recovery time, 33% faster than the company's target. In addition, it offers customer continuous uptime for all of its database applications, on-demand scalability, lowered computing costs, and record-breaking performance.
- Solution Brief: Mellanox Partners with Enmotech to Create an Industry Leading, High Performance, Open Architecture, All-in-One Machine
- Solution Brief: Building a High-Performance Intra-City Active-Active Database Cloud Platform
- Solution Brief: HPE, Mellanox and Micron Demonstrate All-Flash MS SQL Server on Storage Spaces Direct: More Than 2.5 Million Transactions per Minute
- Solution Brief: Analyze 1,000 Terabytes of Data in 1 Second!
- Solution Brief: Data Warehousing and Online Transaction Processing
- Solution Brief: SQL Server 2012 Parallel Data Warehouse
- Solution Brief: Quasardb and Mellanox Deliver Ultra-High Performance DB for FSI
- Oracle RAC 12c Ref Architecture with ION Accelerator
- Mellanox InfiniBand Solutions Accelerate Oracle's Data Center and Cloud Solutions (OOW'12)
- SAP® Application with DB2 pureScale Feature
- SMB Advanced Networking for Fault Tolerance and Performance
- Case Study: Oracle
- Case Study: Orace 12c RAC with EMC ScaleIO Scale-Out Storage Over InfiniBand
- IBM, Intel Post Top Results for SAP Transaction Banking
- One Billion Complex Transactions at Lower TCO