424 reputation
821
bio website collectserver.info
location Maidenhead, United Kingdom
age 39
visits member for 3 years, 6 months
seen 7 hours ago

I'm an Oracle certified Database Administrator

I've worked extensively with both Oracle and Postgres, in various roles from DBA to developer. I have a basic working experience with SQL Server and MySQL.


2d
comment Send ctrl-alt-del to nested RDP session
This is particularly helpful if 'Computer C' is Server Core.
Nov
28
awarded  Constituent
Nov
25
answered What is the best way of restricting user profile size in a Terminal Server environment?
Nov
24
awarded  Excavator
Nov
24
revised How do I install dotNet Framework 3.51 on Windows Server 2012 core?
added powershell version
Nov
24
suggested approved edit on How do I install dotNet Framework 3.51 on Windows Server 2012 core?
Nov
22
awarded  Civic Duty
Nov
17
awarded  Caucus
Aug
5
awarded  Notable Question
Jul
5
awarded  Yearling
Jul
5
accepted Website high availability without load-balancer?
Jul
5
comment Website high availability without load-balancer?
... whereas my proposed setup would mean there is a negative impact for the duration of the downtime. This isn't acceptable and is exactly what I wanted to find out in advance by asking here, so thank you very much. Please tell me if if missed the point in though!
Jul
5
comment Website high availability without load-balancer?
I've read and re-read this and all the comments, and I think I now understand you. You know that my plan never involves changing the NS records, but you are cautioning that this will mean a "randomly slow experience" for (half of?) client DNS resolution during the downtime of one VM. Your mention NS updates is presumably referring to the theoretical case when we manually update NS records during extended downtime to mitigate this? During downtime the current setup doesn't affect new connections after the VM is detected as down, ...
Jul
4
comment Website high availability without load-balancer?
OK, thanks, you've been a great help!
Jul
4
comment Website high availability without load-balancer?
The new scheme breaks because of caching of where the name server is, and the old scheme breaks because of caching of where the web server is. Are these failure modes identical or (for example) are ISPs more likely to ignore TTLs on nameserver records?
Jul
4
comment Website high availability without load-balancer?
@MadHatter I've tried to clarify the question: we are happy with the less-than-perfect nature of DNS load-balancing - the current setup is adequate for the service. But I don't want to make it worse and I'm asking if the change I'm suggesting would do that.
Jul
4
revised Website high availability without load-balancer?
added 198 characters in body
Jul
4
comment Website high availability without load-balancer?
Thanks, I will look into haproxy. Just to note though, we are using DNS load balancing presently and it is fine for our needs - the question is really just about whether I'd be making things worse (in terms of HA, not load-balancing) with the change I'm suggesting
Jul
4
comment Website high availability without load-balancer?
oh wait, sorry @MadHatter, no there can't be a single point of failure
Jul
4
comment Website high availability without load-balancer?
@MadHatter that's not the current set-up (which distributes the load) but it is what I mean by "If load-balancing was not a requirement", yes