DX8200D for SQL Acceleration Solution Overview The Lenovo DX8200D for SQL Acceleration is designed to bring the full set of hyperconverged infrastructure beneﬁts to customers with mission-critical SQL applications. By combining compute, networking and storage into a compact 2U server platform, the DX8200D for SQL Acceleration can reduce IT costs, deliver high levels of performance, simplify operations, eliminate single points of failure, and provide greater ﬂexibility for SQL environments. Available as All Flash Array (AFA) as well as Hybrid Flash Array (HFA) models, the DX8200D SQL Acceleration delivers these beneﬁts to a wide range of customers across multiple industries and SQL application environments. and changes to production environments. Most IT organizations do not have the time, resources or the luxury to make significant changes to their production applications.
Solution: How It Works Networking
The Lenovo DX8200D for SQL Acceleration appliance is designed to help customers overcome the challenges associated with today’s SQL environments. These solutions address the performance (latency), core exploitation, uptime (high availability), disaster recovery (D/R) and flexibility concerns faced by customers around the world.
• I/Os go to internal storage. Latency from networking layers and from external storage protocols are gone. All I/Os (reads & writes) now happen internally at high speed between server memory and storage devices, across multiple lanes. • Easy to expand. Customers can add additional memory, internal disks or direct attach JBODs (disk enclosures) as nodes scale up. All of this happens non-disruptively. Customers also have the option to add additional nodes to their environment, as they scale out. • No single point of failure. Best practices suggest deploying 2 nodes to create a high availability SQL failover cluster with mirrored data to eliminate disruption to production environments in case of failures, as shown below.
Challenges with today’s SQL environments IT organizations are constantly challenged to meet SQL application demands. Key challenges include: • Higher performance, exploitation of available cores, elimination of long queues and performance bottlenecks
• Continuous uptime of production SQL instances, creating always ON environments, effective SQL failover clusters that eliminate single points of failure • Operating an increasingly dynamic SQL environment with limited budgets • Improved I/O operations by eliminating high latency associated with external storage access and complex networking layers (SQL application performance is negatively impacted by inefficient I/O protocols.) • Effective Business Continuity deployments that give the ability to resume operations quickly at a second site in case of unplanned events at primary, production location For years, DBAs have tried to meet these challenges by tuning databases, altering queries or modifying applications. This requires significant expertise, development work
Key Beneﬁts •
Simplification: Compute, Networking and Storage combined into a single, 2U node. These are pre-configured, pre-tested, ready to go solutions.
For added protection, the nodes can be physically separated and placed in different buildings in a campus environment, or housed in another datacenter, because the DX8200D for SQL Acceleration supports stretch clusters for up to 100 km. Operations continue uninterrupted in case one node goes down. This implementation provides zero RTO (Recovery Time Objective) and zero RPO (Recovery Point Objective), meeting the highest demands for always on systems. For effective D/R, a third node can be located anywhere (unlimited distance) and via asynchronous replication, creating a backup environment that is flexible and adjustable to meet customers’ business continuity requirements. Async Repl
• Reduced cost as customers no longer have to purchase separate servers to host SQL applications or