Dell PowerEdge External Media System 1434 Dell High Availability and Disaster
Dell PowerEdge External Media System 1434 Manual
View all Dell PowerEdge External Media System 1434 manuals
Add to My Manuals
Save this manual to your list of manuals |
Dell PowerEdge External Media System 1434 manual content summary:
- Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 1
Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server 2012 AlwaysOn Availability Groups Dell servers and storage options available for AlwaysOn Availability Groups deployment. Gopu Narasimha Reddy Dell Database Solutions Engineering - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 2
as is, without express or implied warranties of any kind. © 2012 Dell Inc. All rights reserved. Dell and its affiliates cannot be responsible for errors or omissions in typography or photography. Dell, the Dell logo, PowerVault, and PowerEdge are trademarks of Dell Inc. Intel is a registered - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 3
Groups Contents Executive summary ...4 Introduction ...4 Objectives...5 Why Dell server and storage hardware for AlwaysOn setup 5 Processors ...5 Memory ...5 Internal storage (HDD and SSD 5 Introduction to Microsoft SQL Server 2012 AlwaysOn Availability Groups (AVG 6 AlwaysOn Availability Groups - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 4
will be illustrated by a review of some of the possible user scenarios. We will also discuss how PowerEdge Servers can be combined in a variety of server and storage configurations that make Dell the right platform for deploying Microsoft AlwaysOn HA and DR solutions. Introduction Achieving the best - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 5
for deploying AlwaysOn AVG databases. The Dell PowerEdge R720/R820 supports up to 4 front loading 2.5-inch PCIe SSD drives. This innovative server architecture allows the deployment of high performing AVG databases on PCIe SSD drives of the server, and achieves better throughputs and failover - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 6
Groups The PowerEdge R720 supports up to 7 PCIe slots and offers an interface for several available storage categories such as fiber channel, iSCSI and Direct Attached Storage (DAS), making possible the installation of applications that require high-bandwidth on the same system. By combining - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 7
Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server 2012 AlwaysOn Availability Groups o manual failover) are supported. Windows Server Failover Cluster (WSFC): All availability replicas (primary and secondary) participating in the AVG deployment must be installed - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 8
internal storage and huge processing power, Dell's 12th Generation PowerEdge R720xd server is an excellent single platform choice for hosting AlwaysOn databases that have large processing power, memory, and high-performing storage requirements. R720xd supports a maximum of 38TB of internal - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 9
Server 2012 AlwaysOn Availability Groups The Dell H710 mini-integrated PowerEdge RAID Controller (PERC) card can be used efficiently to manage internal storage of the server is locally attached Reduced datacenter footprint and less power consumption when compared to shared storage solutions 9 - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 10
Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server per standard SQL Server failover instance installation. An FCI Server FCIs do not support automatic failover by availability groups, any availability replica that is hosted by an FCI can only be configured for manual - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 11
at the DR site (this is because Automatic failover is not supported when FCIs are deployed with AVG). Only a single SQL Server instance is active at either of the sites (primary and DR). With FCI, only one node will be actively servicing the user load; the other node will be idle (passive), and - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 12
be running on Node1 or Node2 at any point in time. Since the FCI instance does not support automatic failover/failback when we combined it with Availability Groups, we may have to do a manual failover to Node3. Since Node3 is Synchronous-Commit replica, failover can happen without any data loss. 12 - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 13
Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server 2012 AlwaysOn Availability Groups We validated the configuration outlined in Figure 4 using four PowerEdge R720 servers MYFCI instance as automatic failover is not supported when FCIs is implemented with AVG. Another - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 14
-loading PCIe SSD drives. Benefits Dell™ PowerEdge R720 and R820 servers support up to four 2.5-inch 350G front-access PCIe SSDs drives. Figure 7 shows a possible deployment of AlwaysOn Availability Groups on the PCIe SSDs drives of Dell PowerEdge servers. Figure 7. AVG deployments on SSD and HDD 14 - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 15
Dell High Availability and Disaster Recovery Solutions Using Microsoft SQL Server 2012 AlwaysOn Availability Groups In the above sample implementation, two PowerEdge R720 servers in the primary site were deployed with PCIe SSD drives. The databases that are part of the AVG are stored on the SSD - Dell PowerEdge External Media System 1434 | Dell High Availability and Disaster - Page 16
(such as Compellent, EqualLogic, and PowerVault), the PowerEdge servers provide an enterprise level server and storage combination for deploying AVG on shared storage. PCIe SSD Advantage: With PCIe based SSDs on Dell PowerEdge servers (eg. R720, R820), customers can enjoy high performing and cost
Gopu Narasimha Reddy
Dell Database Solutions Engineering
Dell High Availability and Disaster
Recovery Solutions Using Microsoft
SQL Server 2012 AlwaysOn Availability
Groups
Dell servers and storage options available for AlwaysOn Availability
Groups deployment.