I guess my #PowerShell scripts for our #SQLServer migration might be something of a hit. We'll see how they fare with 50-ish failover clusters here in a bit, but the tests with 10 or so were smooth as silk twice earlier today. I know this doesn't sound complicated — it's just failovers amirite? — but there are stumbling blocks that have to be accounted for including network latency, SIOS mirroring, Windows pending reboots, AD, DNS...y'know all of the usual wrenches getting thrown in the gears.
I forgot to mention these are four-node failover clusters using SQL Server Standard Edition which isn't supposed to be possible but we did it. So we're in the wind for support from Microsoft. With two nodes in one AZ and two in another, and three SIOS mirrors replicating between pairs of nodes.
@valthonis Test run was a resounding success. Next week we have an offsite in L.A., then coasting to the real deal in June. Then with that feather in our caps moving on to more cool projects.
Add comment