DBA From The Cold (8/8/2014)
Hello,I'm setting a new SQL Server 2012 two node cluster and have a quick question about the virtual IPs of for both the cluster and SQL itself.
I've been doing a bit of research (aka googling) but cannot find an answer.
My question is, I have two vLANs for Production and Management traffic. Can I create the cluster's VIP on the management vLAN and the SQL Server VIP on the Production vLAN? Is this supported (or even possible)?
The idea is to keep all traffic going to the cluster (which will be admin traffic) away from the Production traffic, or am I barking up the wrong tree?
Any help or advice would be most appreciated.
Andrew
Unless you're going to give everybody access to manage the cluster and make hundreds of calls to the cluster CAP it's not going to be an issue. The cluster CAP is purely the management access point and having it on the same VLAN shouldn't even be a concern IMHO
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉