Starwind and MSSQL on the same server

Software-based VM-centric and flash-friendly VM storage + free version

Moderators: anton (staff), art (staff), Max (staff), Anatoly (staff)

Post Reply
herman
Posts: 2
Joined: Tue Jul 07, 2015 5:37 pm

Tue Jul 07, 2015 5:54 pm

Hello, we are currently testing out Starwind in our lab environment. We are planning to use it for 2-node MS SQL failover clustering. I would like to know if it is acceptable/supported to have both Starwind and MSSQL installed on the same server node? So instead of having 3 servers (2x Starwind, 2x MSSQL), we will only have 2.

Thanks in advance!
User avatar
anton (staff)
Site Admin
Posts: 4021
Joined: Fri Jun 18, 2004 12:03 am
Location: British Virgin Islands
Contact:

Thu Jul 09, 2015 8:15 am

Yes, absolutely supported scenario. That's the way we "workaround" need in Enterprise licenses for SQL Server AlwaysOn AG (Availability Groups). With StarWind replication you can go SQL Server Standard and AlwaysOn FCI (Failover Clustered Instances).
herman wrote:Hello, we are currently testing out Starwind in our lab environment. We are planning to use it for 2-node MS SQL failover clustering. I would like to know if it is acceptable/supported to have both Starwind and MSSQL installed on the same server node? So instead of having 3 servers (2x Starwind, 2x MSSQL), we will only have 2.

Thanks in advance!
Regards,
Anton Kolomyeytsev

Chief Technology Officer & Chief Architect, StarWind Software

Image
herman
Posts: 2
Joined: Tue Jul 07, 2015 5:37 pm

Tue Jul 14, 2015 6:29 am

That's great! So if we set up this way, am I right in understanding that the iSCSI initiator should point to the targets as follows (given there are 2 iSCSI target NICs per node).

Node 1:
127.0.0.1
<IP of iSCSI NIC 1 of node 2>
<IP of iSCSI NIC 2 of node 2>

Node 2:
127.0.0.1
<IP of iSCSI NIC 1 of node 1>
<IP of iSCSI NIC 2 of node 1>

Another quick question - as we are using VMware, should we use the PVSCSI controller (instead of the usual LSI Logic SAS) for the drives where the Starwind img files are stored?

Thank you very much!
User avatar
darklight
Posts: 185
Joined: Tue Jun 02, 2015 2:04 pm

Wed Jul 15, 2015 4:08 pm

Hi Herman!

Connections listed seem to be OK to me.

I would recommend to setup the whole configuration as simple as possible. Each additional feature you enable could possibly lead to strange issues and problems. Simple means stable :)
Vladislav (Staff)
Staff
Posts: 180
Joined: Fri Feb 27, 2015 4:31 pm

Mon Jul 27, 2015 11:48 am

Hope the topic was helpful.

Thank you all!
Post Reply