Dell Acceleration Appliances for Databases User Manual

ION Accelerator™ Appliance 2.4.1 Configuration Guide 7.25.2014

3

Part Two: First Boot and Connection 4

First Boot Setup _______________________________________________________________________ The ION Accelerator software comes pre-installed on th

For standalone mode, ION Accelerator supports Fibre Channel and iSCSI protocols; however, only one of these protocols can be running at a time. For

The ION Configuration Summary dialog appears, with a summary of the selected protocol and mode (HA or standalone). 4. Select Yes to proceed w

NETWORK CONFIGURATION OVERVIEW The basic network configuration process for ION Accelerator is as follows: 1. Set the hostname and routing informatio

2. Select Hostname/DNS at the top of the Network Settings screen. 3. Clear the selection for “Change Hostname via DHCP”. 4. Type the hostname and

CONFIGURING THE MANAGEMENT PORT The management port is connected by external cable and is publicly visible. This port needs to be configured so your

4. Select “Statically assigned IP Address” as shown above. 5. Type the IP address and subnet mask for your network, using the screen above as a gu

iSCSI Guidelines If you are configuring multiple cards for iSCSI, ensure each card is placed on a different subnet. If both iSCSI ports are configure

Copyright Notice The information contained in this document is subject to change without notice. Fusion-io MAKES NO WARRANTY OF ANY KIND WITH REGAR

All other ports are configured as normal for iSCSI. Below is a sample screen before the port configuration is done: 1. Edit the first port with the

After split-port configuration, results for the first node will look similar to this: After split-port configuration, results for the second node

VERIFYING THE NETWORK SETTINGS With your configuration choice completed (default DHCP, modified DHCP, or static IP address), the Network Settings scr

3. Select Next to continue to the Clock and Time Zone screen (shown below). 16

SETTING THE CLOCK AND TIME ZONE 1. To select the Time Region, select Region (left side of the screen) and press the Down arrow to select your regi

SETTING THE DATE AND TIME In this screen you can manually change the current date and time for the server, or you can synchronize the server time wit

ENABLING THE HA CLUSTER If you are using the HA feature, the Enable Cluster screen appears, as shown below. (If you are not using HA, skip ahead to P

3. Choose the correct IP subnet to assign to the primary channel (192.168.1.0 in the example above). 4. In similar manner, choose the correct IP s

If the password you selected is not sufficiently strong, a warning message appears so you can change the password. 2. Confirm the password you enter

Connecting to ION Accelerator ______________________________________________________________________ If you are setting up a permanent HA cluster,

CONTENTS Overview ...

1. Type admin for the admin username. 2. Type the password in the second field (this is the password you created in First Boot). 3. Click Login.

If the host name has changed, the service restarts, and the login process is initiated again. After re-direction, the login dialog appears agai

Changing the Management IP Address 1. Ensure that both nodes are up. 2. In the CLI, run system:setup cluster to display the Setup dialog for clust

3. Change the iSCSI port IP address in the dialog. 4. Select OK and press Enter. 5. For Linux initiators, add the new target session to the init

Part Three: HA and Host Configuration 27

HA (High Availability) and Configuring Clusters _____________________________________________________________________ If you are not planning to

The diagram below shows basic LUN access (exported volumes) in an HA configuration. LUN 0 LUN 0LUN 1 LUN 1LUN 0LUN 140Gb In this simplified example,

FABRIC AND CLUSTER INTERCONNECT CARDS (ISCSI) The photos below show common fabric and cluster interconnect cards, with ports labeled. As you configur

Multipathing Overview _____________________________________________________________________ For information on managing initiators, such as crea

ABOUT MULTIPATHING Multipath I/O (MPIO) establishes multiple routes and connections to a storage array, using redundant physical paths (adapters, cab

Changing the IP Addresses for Cluster Interconnect Ports ... 25 Changing the iSCSI Port IP Addr

Configuring Multipathing on Windows _____________________________________________________________________ INSTALLING MULTIPATH ON WINDOWS When MP

Installing Multipath on Windows Server 2012 To install MPIO on a server running Windows Server 2012 R2, 1. Start Server Manager. 2. Click Tools and

4. Click Next on “Before You Begin”. 5. Select Role-based or Feature-based installation and click Next. 6. In the left pane, click Features and se

Configuring Multipathing on Windows Server 2008 To configure Windows multipathing on Windows Server 2008, 1. Open the MPIO Control Panel (Start >

6. Right-click on an ION LUN to display its properties. 7. In “Select the MPIO Policy” on the MPIO tab, make sure “Round Robin With Subset” is sel

10. Click OK to exit each dialog, until prompted to restart the system. 11. If you are running in standalone mode, click Yes to reboot, and the

Configuring Multipathing on Windows Server 2012 To configure multipathing on Windows Server 2012, 1. Open the MPIO Control Panel and type mpio in th

4. Type the hardware ID, which is Vendor ID (eight characters) plus Product ID (16 characters). 5. Click OK exit each dialog. 6. Open the Windows

9. Click Details to display the DSM Details dialog. 10. Make sure that “Path Verify Enabled” is checked, as shown above. 11. Click OK to exit each

CONFIGURING ISCSI INITIATORS FOR WINDOWS The instructions in this section apply to multipathing for Windows Server 2008 R2. Each initiator iSCSI port

Discovering ION Target Portals from the RHEL Initiator ... 54 Creating RHEL Initiators in

HA Mode 1. Follow steps 1 to 3 in the Standalone Mode instructions above. 2. Go to Control Panel > MPIO > Add Device Hardware ID. 3. Specify

2. Log in to each target port and click Quick Connect. After successful login to all four targets, the target connection and discovery should be se

Favorite Targets Tab 3. To view the LUN discovery in Server Manager, open the Disk Management volume list. Disk 1 in the example below shows the di

4. To see the discovered LUN as an MPIO multi-path configuration disk device, with two active and two standby paths, right-click Disk 1 and select P

initiator:create -a W2K8 iqn.1991-05.com.sqa.microsoft:win-ru3kmomq0ov#192.168.11.8 win_2 id win_2 UUID iqn.1991-05.com.sqa.microsoft:win-ru3kmomq0

Configuring Multipathing on Linux _____________________________________________________________________ INSTALLING MPIO ON LINUX The basic compon

Installing Multipathing in HA Mode To install multipathing in an ION Accelerator HA environment, use the multipath.conf file as explained below. The

3. Restart multipathd as indicated on the first line. # copy this file to /etc/multipath.conf and restart multipathd defaults { user_friendly_

(See Creating RHEL Initiators in ION Accelerator for sample multipath –ll output.) Setting the Node Session Timeout for iSCSI If you are using the iS

HA Mode 1. Copy the following file to /etc/multipath.conf, or copy the settings from this file to the existing multipath.conf file. 2. Follow the

Windows Clustering Hot Fixes ... 77 Appendix A:

# Uncomment next 2 lines for FC; do not use for SRP or iSCSI. # fast_io_fail_tmo 15 # dev_loss_tmo 60 } } 2. Run s

Discovering ION Target Portals from the RHEL Initiator To see all the target portals that are discovered, you can run the iscsiadm command from the c

Creating RHEL Initiators in ION Accelerator 1. From ION Accelerator (standalone or HA), create an initiator group in the CLI: inigroup:create RHEL

Initiator Group 29f1007e-1751-11e3-8482-0015178fbc10 The Fusion ION LUN is now discovered with a MPIO multi-path configuration disk device, with two

Performance Tuning and Filesystems for Linux Initiators _____________________________________________________________________ The iontuner utility

For best use with NUMA initiators, each storage volume should be exported only to initiator ports on one of the initiator’s NUMA nodes. When multiple

Script for Mounting the Filesystem #!/bin/sh ### BEGIN INIT INFO # Provides: mount-ion-filesystems # Required-Start: multipathd # Required-Stop: mult

grep -v '^#' /etc/fstab | while read dev mountpoint vfstype options freq passno; do is_ion_lun "$dev" && umount "$de

Troubleshooting Linux Issues _____________________________________________________________________ LOGIN FAILURE WITH RHEL INITIATORS Problem Whe

Solution To resolve this issue, 1. Add the following code to the end of the /lib/udev/rules.d/50-udev-default.rules file: # InfiniBand KERNEL==&quo

Part One: Introduction

SOLVING NETWORK MANAGER AND UDEV ISSUES WITH RHEL 6.4 Problem When using the Mellanox ConnectX®-3 driver, mlx4_en, in RHEL, the Network Manager and u

In: /lib/udev/rules.d/75-persistent-net-generator.rules by adding this line: DRIVERS=="mlx4_core", ENV{MATCHDEVID}="", ENV{MATCHI

Resolving Path Failures during Multipathing Scans If a path fails while multipathd is scanning the path UID, then multipathd won't recognize tha

66

Part Four: Application Tuning 67

Best Practices for Oracle Database _______________________________________________________________________ This section outlines best practices

• Use the 512B sector size when exporting volumes to initiators. If you need to export LUNs with a 4KB sector size, use Oracle or third-party-provid

ASM STORAGE CONFIGURATIONS The configurations described below are variations that may serve your particular storage needs, using Oracle ASM and ION A

It is very important to note that this count of files (6 OCR and 5 Voting) means one of the LUNs will not have a Voting File. It is critical that no

Best Practices for MS SQL Server _____________________________________________________________________ This section outlines best practices for us

Overview _______________________________________________________________________ ION Accelerator™ software runs on a shared-storage appliance,

of external memory pressure that requires further analysis. OTHER BEST PRACTICES • When formatting the partition that will be used for SQL server da

Configuring HA with Windows Server Failover Cluster (WSFC) _____________________________________________________________________ If you are deplo

4. Click the Policies tab. 5. Set "Period for restarts" to 1:00. 6. Set “Maximum restarts in the specified period” to 30. 7. Set &qu

2. In the Failover section of the tab, set the maximum number of failures as 30 in 1 hour. 3. In the Failback section, select “Allow failback:

Windows Clustering Hot Fixes _____________________________________________________________________ Several hot fixes for Windows Clustering are

78

Appendixes 79

Appendix A: Dell PowerEdge R720 Configuration _______________________________________________________________________ The pictures below show vario

Low-Profile Slot Assignments Non-HA, FC Non-HA, iSCSI HA, FC HA, iSCSI Slot 1 empty empty Cluster Interconnect (both Eth ports) Left port =

Appendix B: About the ION Accelerator Appliance Guides _______________________________________________________________________ The ION Accelerato

INTEROPERABILITY Operating Systems and Multipathing For information on specific OS software versions to use, refer to the Interoperability Matrix ava