Reputation
544
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 9 28
Impact
~61k people reached

  • 0 posts edited
  • 0 helpful flags
  • 65 votes cast
May
29
comment Looking for a DNS Hosting provider with automatic failover and role switching
Actually there is an easier way (as I just noticed). See my answer...
May
29
answered Looking for a DNS Hosting provider with automatic failover and role switching
May
29
comment Looking for a DNS Hosting provider with automatic failover and role switching
1. My sql servers are hosted on the same machines as my web servers, so I can simply monitor those without expsosing the database to the internet 2. This point is irrelevant. The DNS server does not even need to know what the A record it is serving points to. It just looks up an A entry and returns an IP address, plain and simple. SQL server is responsible for automatic failover, and that is completely independent of DNS lookups. Point 3 can be solved with a DNS entry has a very low TTL (60 seconds)
May
29
asked Looking for a DNS Hosting provider with automatic failover and role switching
May
29
accepted Implementing Automatic failover with SQL Server 2008 R2 Web Edition
May
29
comment Looking for smart DNS hosting
Couldn't the second issue be worked around by using a very low TTL paired with a DNS resolving the IP for the database server? In other words using something like sql.mydomain.com in your connection string. Then it does not matter if the user hits the secondary or primary web server. Both are using the same database.
May
29
comment Looking for smart DNS hosting
But doesn' that create a single point of failure on the load balancer?
May
28
accepted What's the risk of disabling Network level authentication with Windows Remote Desktop?
May
27
comment Implementing Automatic failover with SQL Server 2008 R2 Web Edition
Good points, thanks a lot!
May
27
asked What's the risk of disabling Network level authentication with Windows Remote Desktop?
May
27
revised Implementing Automatic failover with SQL Server 2008 R2 Web Edition
edited title
May
27
asked Implementing Automatic failover with SQL Server 2008 R2 Web Edition
Jan
29
awarded  Popular Question
Jan
26
accepted Do I need these incoming open ports?
Jan
26
comment Do I need these incoming open ports?
@Nick Kavadias: The one that comes with the OS.
Jan
26
revised Do I need these incoming open ports?
added 9 characters in body
Jan
26
asked Do I need these incoming open ports?
Jan
11
comment How common are power supply failures in comparison to hard disk failures?
I know, but this is why I asked in this forum hoping I would find experiences sysadmins who can tell me about their experiences.
Jan
11
accepted How common are power supply failures in comparison to hard disk failures?
Jan
10
comment How common are power supply failures in comparison to hard disk failures?
Thanks, but I know all that already... This does not really answer my question.