For MangoLassi.it Forum Geeks: StarWind Virtual SAN NFR (not-for-resale) License!
-
@scottalanmiller Because I am more familiar with setting SQL Server up in a failover cluster. I prefer it this way.
And no, I've never had any issues with corrupted databases or anything like that due to problems with a storage node exploding or going offline for other reasons.
-
@scottalanmiller said:
@dafyre said:
I am currently using Starwind in my Lab to provide shared storage for my MS-SQL Server Failover cluster. It works great!
Why are you not using application layer failover for your database?
He is... he is using the failover built into MS-SQL Server.
-
@coliver Actually, no... It's the Windows Failover Clustering.
-
-
I'm running this on a not-so-great hardware setup as this is just a test environment I have setup. Starwind works quite well despite this fact too.
-
@dafyre said:
@scottalanmiller Because I am more familiar with setting SQL Server up in a failover cluster. I prefer it this way.
And no, I've never had any issues with corrupted databases or anything like that due to problems with a storage node exploding or going offline for other reasons.
No, but it is a risk. Just be aware that the database has full HA built in that is completely safe. This would not be. There is always a risk of corruption and NO not from the storage blowing up. That's not how it happens. It is your hypervisor that corrupts it, not the storage. So you are not picturing the issue, which is loss of memory contents.
-
@coliver said:
@scottalanmiller said:
@dafyre said:
I am currently using Starwind in my Lab to provide shared storage for my MS-SQL Server Failover cluster. It works great!
Why are you not using application layer failover for your database?
He is... he is using the failover built into MS-SQL Server.
Um, that's impossible MS SQL Server can't affect MySQL.
-
@scottalanmiller said:
@coliver said:
@scottalanmiller said:
@dafyre said:
I am currently using Starwind in my Lab to provide shared storage for my MS-SQL Server Failover cluster. It works great!
Why are you not using application layer failover for your database?
He is... he is using the failover built into MS-SQL Server.
Um, that's impossible MS SQL Server can't affect MySQL.
Wait... isn't he running MS-SQL? I'm really confused now :(.
-
@coliver said:
@scottalanmiller said:
@coliver said:
@scottalanmiller said:
@dafyre said:
I am currently using Starwind in my Lab to provide shared storage for my MS-SQL Server Failover cluster. It works great!
Why are you not using application layer failover for your database?
He is... he is using the failover built into MS-SQL Server.
Um, that's impossible MS SQL Server can't affect MySQL.
Wait... isn't he running MS-SQL? I'm really confused now :(.
MySQL. He's used to MS SQL Server.
-
I'm going to slowly back out of the conversation.
-
Both of you re-read my post, lol. I am running this on a Microsoft SQL Server. I prefer to run Microsoft SQL Server using Windows Failover Clustering.
:trollface:
-
@dafyre said:
Both of you re-read my post, lol. I am running this on a Microsoft SQL Server. I prefer to run Microsoft SQL Server using Windows Failover Clustering.
:trollface:
Ah that helps. Thanks!
-
OH!! It is MS SQL Server. Writing it as MS-SQL made my eyes think that it was MySQL.
-
lol. Nope... MySQL is always MySQL. I've run that on a Windows Failover Cluster too... just not right now.
-
@scottalanmiller said:
@dafyre said:
I am currently using Starwind in my Lab to provide shared storage for my MS-SQL Server Failover cluster. It works great!
Why are you not using application layer failover for your database?
Because that would require two SQL licenses (but that may actually be required anyway).
-
That link goes to an Office 365 login page. I don't use Office 365. Got a login we can use to get to the form?
-
@Dashrender said:
@scottalanmiller said:
@dafyre said:
I am currently using Starwind in my Lab to provide shared storage for my MS-SQL Server Failover cluster. It works great!
Why are you not using application layer failover for your database?
Because that would require two SQL licenses (but that may actually be required anyway).
I was assuming MySQL when I said that which has free Galera application level failover.
-
Took me to O365 too.
-
The form is probably not marked as publicly accessible.
-
Awesome! Thanks for extending this to ML users.
Now to find a lab to set this up in.