MSA Storage

MSA 1000, HA kit and SQL

 
Debra H
Advisor

MSA 1000, HA kit and SQL

We recently purchased a MSA 1000 San Kit with the HA kit. We have it configured to connect to 2 servers. One server manages the array and also manages a MySql database that takes hits all night long. The other server has several MS SQL databases. Whenever we initiate a backup through the MS SQL Enterprise Manager, we are writing to the same drive space on the array. Once the backup starts, we start to receive several errors from both the SAN array and the MS SQL server. The redundant controller beccomes active. 2 minutes later it swaps again. This continues until the MS SQL backup job is finished. What could be wrong?
17 REPLIES 17
BR894765
Valued Contributor

Re: MSA 1000, HA kit and SQL

I have seen such situation with improper cabling, when fibre switches was connected to each other.

Also without special clusterware servers must write only to drive space that they "own".

Debra H
Advisor

Re: MSA 1000, HA kit and SQL

I was told the cabling did not matter as long as each card was plugged into a switch and each controller was plugged into switch. Are there settings for which is primary?
BR894765
Valued Contributor

Re: MSA 1000, HA kit and SQL

What errors you got from array? What firmware version do you use?
Debra H
Advisor

Re: MSA 1000, HA kit and SQL

Firmware version on controller is 4.48.B342. We frequently receive the message below. It continuously goes from active to standby, active to standby. Eventually connections to drives fail. We can't backup our SQL db unless we reboot everything.

Description:
A 'Redundant Controller Active' trap signifies that the Storage Agent has detected that a backup array controller in a duplexed pair has switched over to the active role.

Details:
Controller Role 'Active'
Chassis Name 'SGM053801D'
Slot # 2
MEMORY 512
Model 3
Serial Number 'P56350HX3S90IQ
Uwe Zessin
Honored Contributor

Re: MSA 1000, HA kit and SQL

> I was told the cabling did not matter as long as each card was plugged into a switch and each controller was plugged into switch.

That is simply wrong. The 'ping-pong' strongly suggests a setup error.

The 'first' Fibre Channel adapter in the server as detected by the OS must connect to the first MSA controller and it must not have access to the second controller.
.
Debra H
Advisor

Re: MSA 1000, HA kit and SQL

We do have it setup this way. Each server has 2 HBA cards. HBA card A connects to Switch A, HBA card B connects to Switch B and the Switch connects to the controller. Same thing for second server. I am thinking of removing the multipath and redundancy.
BR894765
Valued Contributor

Re: MSA 1000, HA kit and SQL

HBA A from both servers must be connected to Switch A and this switch must be connected to one MSA controller, HBA B from both servers -- to switch B, switch B -- to another MSA controller. And do not put any link between switches.
Debra H
Advisor

Re: MSA 1000, HA kit and SQL

What determines which HBA is A or B? Also, did 4.48 firmware address this issue?
BR894765
Valued Contributor

Re: MSA 1000, HA kit and SQL