Understanding Server 2012r2 Clustering
-
@Dashrender said:
While I'm annoyed at my own ignorance and lack of thought process, reading Scott's posts have definitely added to my understand and helped me to change my thinking process. Not saying I always see it his way, but I try to be more encompassing in my thought process - but even my current phone project is showing that I'm still lacking.
I'm lacking too, but I'm not down about it. I just like getting free advice from Scott. Companies pay thousands for the kind of advice that we get here for free.
I have only have around 100 users, so neither a SAN/HA or DAGs/clustering were ever a real consideration for me. But that user count could be going up to 200 soon through mergers and acquisitions (or a new job
), so it's something I'm trying to understand a bit more about.It seems to me that we should avoid treating SAN/HA as an alternative to DAG/application clustering as really they're different solutions to different problems. SAN/HA addresses minimising downtime whilst DAG/clustering also addresses data loss. So you need to identify your problem and then select your solution, rather than picking your solution first.
-
I definitely agree with Scott and have learned a lot from him through threads here and on SW!
I am a firm believer in the right tools for the right job. The SAN vs Local Storage (DAG, replication, etc, etc) will always be a decision to be made. And I am coming to agree more and more with @scottalanmiller that Local Storage + Replication + Good Backups will almost always be the better answer for an SMB.
My take-away from my first and only SAN deployment (as smoothly as it went, it could have been much, much, much worse) is that you must define what you are looking for clearly (both to yourself, your team, and to your vendor of choice). You must also do your own research about the products the vendor recommends. We were recommended a number of solutions that were FT only and not true HA. Once your vendor has made you a quote for "Product X" check and make sure the product's company defines things the same way that you do. If you think "Product Y" may be a better fit for what you are wanting, then ask your vendor about it.
Never be afraid to second guess yourself, your vendor, or your peers in a respectful way.
-
@Carnival-Boy said:
It seems to me that we should avoid treating SAN/HA as an alternative to DAG/application clustering as really they're different solutions to different problems. SAN/HA addresses minimising downtime whilst DAG/clustering also addresses data loss. So you need to identify your problem and then select your solution, rather than picking your solution first.
Let me add at that scale. HA addresses minimising downtime, but SAN does not. SAN actually exacerbates downtimes all other things being equal. Many people, especially sales people, conflate SAN with "buying super expensive equipment* which is not the same thing. You can but $60K SAN that are crazy reliable. This is very true. But for even better uptime than two hosts connected to a $60K SAN, you could just buy a $60K server that has fewer points of failure but matches or beats the expensive SAN in all the ways that it is reliable. That's part of the sales trick, making SANs look more reliable than servers by comparing entry level servers to high end SANs. But at the same levels, they are equally reliable (or slightly weighted to the advantage of servers due to massively larger volumes) so anything that is done to make a SAN reliable can be done to make a single server more reliable.
So while HA is all about uptime and a SAN may or may not be a part of that strategy, the real value to a SAN is in scalability. SANs are more flexibly scalable than any other solution. Scalable means in number of supported physical hosts. So if you need to scale to very large host counts, SAN is the obvious choice. That's SAN's one strong suit - and it is a big one. But when you don't need that one thing, SAN lacks its major "pro" and just comes with the "cons."
-
@Carnival-Boy said:
So you need to identify your problem and then select your solution, rather than picking your solution first.
That's huge. So many SMBs (and I assume enterprises but I see it rarely there) approach with the solution and then try to figure out how to make it work. I see it constantly where people start with "I need a SAN" and can't tell you why they feel that they need or want it. The desire for the SAN is often the starting point of the conversation rather than a clear business need. So when you ask what their goal is or how they are servicing the business, they are lost.
-
@scottalanmiller said:
@Carnival-Boy said:
So you need to identify your problem and then select your solution, rather than picking your solution first.
That's huge. So many SMBs (and I assume enterprises but I see it rarely there) approach with the solution and then try to figure out how to make it work. I see it constantly where people start with "I need a SAN" and can't tell you why they feel that they need or want it. The desire for the SAN is often the starting point of the conversation rather than a clear business need. So when you ask what their goal is or how they are servicing the business, they are lost.
If you can't answer the why I need $product , then chances are you really don't need it. I think @Carnival-Boy got it spot on though. Identify the problem and find products that solve that problem... Not buy the square peg and try to make it fit into the smaller moon-shaped hole.
-
Maybe I missed it, but it seems there is a huge amount of discussion are HA and SANs on Spiceworks, but relatively little on application clustering and DAGs or SQL Server resilience. So this thread is something of an eye-opener for me.
If you work on the premise that databases aren't a good fit for VMware HA and shouldn't be installed on a (non-redundant) SAN then I believe you rule out nearly every mission critical system an SMB is likely to use.
Thinking of my own environment, I have ERP, Sharepoint, EDM, Exchange and AD, all of which are databases. It's only really the file server that isn't (and a lot of that is moving to the Sharepoint and EDM servers). The other servers aren't really mission critical and/or are fairly static, like print servers, so can be fired up from a backup very easily without significant loss of data.
So protecting and managing databases becomes the key. And the resellers I've dealt seem to have very little knowledge or experience of SQL Server. Possibly because they're from a hardware background, or possibly because there isn't much money in SQL Server in the SMB marketplace. So they're pushing a hardware solution when a software solution is what SMBs really need (I guess).
-
@Carnival-Boy said:
Maybe I missed it, but it seems there is a huge amount of discussion are HA and SANs on Spiceworks, but relatively little on application clustering and DAGs or SQL Server resilience. So this thread is something of an eye-opener for me.
I'm on a good percentage of those discussions (I think) and DAG does not come up too often. Very often the people considering SANs are not actually listing their workloads and only, so they say, trying to get the platform to HA and not really considering if that fixes the workloads or not. But for SMBs, applications that have DAG available to them are few. Exchange tends to be hosted. SQL Server tends to be the Express (no DAG) edition.
But lots of workloads are similar, even without DAG. Active Directory Domain Controllers don't use DAG but have their own application layer failover. Same for MySQL and other databases.
-
@Carnival-Boy said:
If you work on the premise that databases aren't a good fit for VMware HA and shouldn't be installed on a (non-redundant) SAN then I believe you rule out nearly every mission critical system an SMB is likely to use.
Absolutely. This is what I've been saying to SMB - SAN is for one purpose only scale. Spiceworks even had me give a webinar in February about that. SMBs look to enterprises for "what to do" but enterprises all have scale (by definition) and SAN is about cost savings for them. SMBs tend to look at SAN not understanding its purpose and being confused by enterprise storage consolidation and thinking that that somehow applies to them, which it does not. Not that no SMB should have SAN, but it is few and far between and always for the purpose of storage consolidation at scale. SAN does not provide reliability, SAN hurts reliability but can be beneficial for other reasons and made (at cost) to overcome the inherent reliability concerns.
HA is not as much a "never for SMBs" thing as SANs, but it should be rare. SMBs often think that they need HA far beyond the needs of huge enterprises like investment banks (think Canary Wharf) and other enormous, big money loss outage companies. Some need HA and some get HA for cheap which changes the equation (Active Directory HA is super cheap) but going after platform HA (what VMware offers) rarely does what they think and almost never makes sense. It's really focused on technology like web servers where load balancers have not been implemented.
-
@Carnival-Boy said:
Thinking of my own environment, I have ERP, Sharepoint, EDM, Exchange and AD, all of which are databases. It's only really the file server that isn't (and a lot of that is moving to the Sharepoint and EDM servers). The other servers aren't really mission critical and/or are fairly static, like print servers, so can be fired up from a backup very easily without significant loss of data.
File servers are typically "good" HA workloads. Minor risk for data loss and data loss is typically really tiny (like one file or two that you can restore as a single file from backup rather than the whole system). There are other solutions to consider. DFS on Windows, for example, and full fault tolerance with DRBD on Linux or HAST on FreeBSD. These can be complicated to implement, but are all free. In cases where you might spend a lot of money on VMware's HA offering, you could go beyond HA to complete fault tolerance without using VMware, for free (but with some effort.)
So in that case, it is a trade off depending on your needs.
-
@Carnival-Boy said:
So protecting and managing databases becomes the key. And the resellers I've dealt seem to have very little knowledge or experience of SQL Server. Possibly because they're from a hardware background, or possibly because there isn't much money in SQL Server in the SMB marketplace. So they're pushing a hardware solution when a software solution is what SMBs really need (I guess).
The profit margin and "not my fault, call the vendor" benefits of a SAN are enormous. A single sale might set up a salesman for a month or two without needing to make another sale. And the "blame the vendor" benefits are huge. It's very hard to complain to your salesman when a SAN fails, they have another throat to give you to choke. Whereas if they recommend something else, the only throat to choke might be theirs, and they don't want to deal with that even if it is in your interest.
You are correct, there is very little call and very little money in SQL reliability for the SMB. It would be rather surprising that any salesman have been trained on and often might not even be aware of how databases really work. Database skills tend to be more enterprise leaning.
-
@scottalanmiller said:
But for SMBs, applications that have DAG available to them are few. Exchange tends to be hosted. SQL Server tends to be the Express (no DAG) edition.
Oh really? What's the definition of SMB? I don't have a lot of experience. Most of the companies I've worked for have around 100 users. In Europe we use the term SME which I think is generally up to 250 employees. I'd have thought anything over 50 users and you would be avoiding Express for mission critical applications and anything over 150 users and you'd be giving serious consideration to database availability and using Enterprise licencing and features.
-
@Carnival-Boy said:
Oh really? What's the definition of SMB? I don't have a lot of experience. Most of the companies I've worked for have around 100 users. In Europe we use the term SME which I think is generally up to 250 employees. I'd have thought anything over 50 users and you would be avoiding Express for mission critical applications and anything over 150 users and you'd be giving serious consideration to database availability and using Enterprise licencing and features.
There is no hard and fast rule, but pretty typically SMB is 20 - 500 users (but lots of people disagree, many say 1 - 200, IBM says 2,000 - 5,000, etc. IBM considers anything under 2,000 to not be a business.) SME, in the US, is the category above SMB. Sort of. But the names, of course, make no sense at all. But SME is generally used to refer to larger, maybe 250 - 1,000, person companies.
But regardless of those murky definitions, most companies under 500 users that I see tend to use Express. That doesn't mean that lots don't, but most tend to try to go for free. Database needs for SMBs tend to be pretty light and only so many workloads use SQL Server.
At 100 users I'm not sure I've seen enterprise licensing in more than one or two companies. It's decently rare there, I think.
Now what really tends to make sense for companies in that range is to often not have SQL Server at all since it is extremely expensive and the prices really only tend to make sense for larger businesses where the benefits of SQL Server can be leveraged. You can get the high end features of SQL Server for free from players like PostgreSQL.
-
If you think about SQL Server availability cost, getting an HA SQL Server setup is very costly. In a typical (what's typical?!?!) 100 person company, the cost can be brutal. Data loss might be of serious concern, but generally uptime is not (is four years once a decade worth tens of thousands of dollars to protect against?) A good, single server setup for database with good RAID and good backup can reduce the risk of data loss to extremely low levels while keeping availability to perfectly acceptable levels (for most companies.)
It takes a bit of risk analysis and every business (and workload) is unique. But pretty often, HA is not needed. Even for 1,000 person companies for nearly all workloads.
-
@scottalanmiller said:
most companies under 500 users that I see tend to use Express.
Gosh. Obviously 500 users doesn't mean 500 concurrent users, but still, I wouldn't want 500 users accessing Express. That performance can't be great.
For ERP systems where a new system can run into hundreds of thousands of dollars, the cost of SQL Server Standard is pretty trivial in my opinion. It's less than $10k for a basic 2 core licence.
-
@Carnival-Boy said:
Gosh. Obviously 500 users doesn't mean 500 concurrent users, but still, I wouldn't want 500 users accessing Express. That performance can't be great.
Well keep in mind that most applications that would be talking to a database would not be being used by 500 users in a 500 user company. There are cases where that would happen, but many where it would not.
Think about an accounting system. That might use SQL Server. In a 500 person company, maybe 20 would access that particular system. Lots of systems are like that.
ERP is a heavy one, typically, and often used by many people. But most companies don't use ERP.
-
@Carnival-Boy said:
For ERP systems where a new system can run into hundreds of thousands of dollars, the cost of SQL Server Standard is pretty trivial in my opinion. It's less than $10k for a basic 2 core licence.
You don't get DAG with Standard, though.
-
@scottalanmiller said:
But most companies don't use ERP.
Ah, right. That'll explain it then. I work in ERP so in my world *every *company uses ERP.
