Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [dns]

For use in questions relating to the Domain Name System and associated processing.

Filter by
Sorted by
Tagged with
0 votes
0 answers
20 views

Can't get hostname for your address flooded in error log even if skip-name-resolve is enabled and many unauth users in processlist in percona 8.0.25

Information about the currently configured percona servers : We are using percona 8.0.25 server. Mysql service is running with skip-name-resolve enabled. host_cache_size=753 but the ...
Sana Ansari's user avatar
0 votes
2 answers
36 views

AD DNS manager records duplication with SQL always on failover cluster

We are managing our SQL Always On listeners records in 2 active directory servers (they are syncing each other) and we came across an issue which we couldn't pinpoint the cause for.We are testing ...
Yishai's user avatar
  • 1
0 votes
1 answer
42 views

MS SQL Server alias and DNS server

I have a MS SQL Server S hosting a MS SQL Server instance I. I would like another machine M to be able to connect to that instance remotely via the TCP port P. I created an alias A = S\I,P on both S ...
Léa Massiot's user avatar
1 vote
0 answers
35 views

Primary MongoD hit 1M active sessions in cache

Overview We're running a sharded MongoDB cluster, using community edition v4.4. The primary mongod in one of the data shards ('shardX' for short) has hit active sessions in cache limit of 1M and new ...
user3752071's user avatar
0 votes
2 answers
125 views

After SQL Server 2019 Availability Group failover, I need to wait half hour to connect database by available listener ip from client

After SQL Server 2019 Availability Group failover, I need to wait half hour to connect database by available listener ip from client. There are the following servers in this case: node1, node2, AD-...
Chiu Chun Yu's user avatar
0 votes
0 answers
42 views

Postgres / Npgsql slow connection due to Hosts file organisation

I'm not really sure if this is the right place to post this but I happened across a peculiar behaviour yesterday. Historically, when debugging locally, our application's first connection to a given ...
Jmase's user avatar
  • 21
0 votes
0 answers
87 views

DNS permissions for Availability Groups

can anyone tell me the correct permissions for the Listener and Cluster records in DNS? At the moment I have a single subnet AG where the Listener VNN owns the cluster DNS entry and vice versa, so the ...
alexP012's user avatar
1 vote
0 answers
164 views

How can I connect to my replicaset via DNS and private IP?

I have 2 node setup 10.1.0.7 - mongodb-1.com (primary) 10.1.0.8 - mongodb-2.com (secondary) here is my mongod.conf net: port: 27017 bindIp: 0.0.0.0 tls: mode: allowTLS ...
JRA's user avatar
  • 149
0 votes
1 answer
1k views

Updating DNS on Availability Group database servers

We have always on availability group that spans across different data centers. Our network team has decommissioned some DNS servers and those servers will need to be updated with the active ones on ...
SQL_NoExpert's user avatar
  • 1,061
0 votes
1 answer
369 views

Return Current Connection CName

I'm wondering if anyone knows if there is a way to return the name that was used to connect to the SQL server rather than the actual server's name. For instance I typically connect to the server via a ...
Davin Studer's user avatar
0 votes
0 answers
146 views

Linked Server Using a DNS Alias Returning Bad Data

Somehow on the same DEV server we have two Linked Servers to the same PROD server. While that, in and of itself, is not an issue; we have noted something we can't explain and we wonder of anyone else ...
Steve_Malcolm's user avatar
0 votes
1 answer
579 views

MultiSubnetFailover=true for DBMSes besides SQL Server

A connection string for SQL Server can contain MultiSubnetFailover=true, to handle multiple DNS A records, letting the client try to connect to every IP address of a domain (or subdomain) name, to ...
uncaged's user avatar
  • 189
0 votes
1 answer
734 views

Failover and DNS propagation delays

When a DBMS fails over after a failure, if it fails over to a server in a different and unrelated data center, then the IP address of the subdomain name of that database will need to be changed in ...
uncaged's user avatar
  • 189
1 vote
1 answer
527 views

How to see urls of incoming SQL Server traffic?

We are migrating the dns entry for our SQL Server database from an machine name to a C-Name, in preparation for moving it from a bare metal box to a virtual machine. We have switched all the ...
Dan Csharpster's user avatar
1 vote
2 answers
37k views

Windows Cluster can't update DNS record

Setup: Windows server 2016 standard edition. SQL server 2016 standard edition. 2 nodes configured in a cluster without witness quorum. all member of the same Active Directory domain. 1 Availability ...
Matthieu Ducorps's user avatar
0 votes
2 answers
604 views

PostgreSQL failover: Who is responsible for handling it? How do clients connect to the new leader?

On a high level, consider two PostgreSQL instances on two separate nodes: the leader and its hot standby. Replication from leader to follower is configured. Consider that the leader node crashes. Two ...
Pedro Lopes's user avatar
3 votes
0 answers
2k views

DNS CNAME for a SQL Managed Instance (Azure)

I currently have an on Prem SQL Instance that has a DNS CNAME set up against it via our On Prem DNS Server. I am looking to move this server to an Azure Managed Instance and I want to point the DNS ...
Lickrob's user avatar
  • 84
1 vote
0 answers
19 views

details on how to connect to geographically close datacenter

I am reading a book about distributed systems. One of the options of data replication mentioned is the use of a "multi leader" approach and place each leader in a different datacenter. The main point ...
sanjihan's user avatar
  • 263
6 votes
2 answers
3k views

Are CNAME aliases for connection strings a good idea?

To be very flexible and move database to different servers more easily, we came up with the idea of using an alias per database. So by simply changing a DNS entry, we can route all queries to a ...
SwissCoder's user avatar
0 votes
1 answer
319 views

Postgresql responses are slow without internet

I have a Postgres service in Centos 7 and it works normally. Each time when the internet service (by an IPS) is down, the responses are slow, other times the DNS is reset by an electrical trouble, ...
user avatar
0 votes
1 answer
573 views

Duplicate Ips for cluster nodes causing backup issues

We have a four node cluster (SQL Server 2014 on Windows 12) and we recently setup heart beat network on the nodes following a best practices source after experiencing some cluster instability issues. ...
Prathibha Vemulapalli's user avatar
1 vote
0 answers
189 views

Domain Independent Cluster on AWS

I am trying to work out whether it's possible to create a Domain Independent Workgroup Cluster in AWS (on Windows Server 2016 for use with SQL 2017 Availability Groups). This environment also has no ...
Matt's user avatar
  • 53
4 votes
1 answer
475 views

Using DNS per application in ConnectionStrings

I have come across an idea recently when I had to migrate a ton of in-house applications to a new SQL server. The more I look at it, the more it sounds perfect, but I wanted to ask the community for ...
Philippe's user avatar
  • 507
4 votes
2 answers
80k views

Cluster network name resource 'Cluster Name' failed registration

I have a fail-over cluster set between two Windows Server 2016 machines, and I'm seeing errors regarding the DNS record, both for the cluster itself and for any listener I try to add in SQL high ...
Green's user avatar
  • 41
1 vote
1 answer
3k views

Multi-Subnet AG - DNS flips to secondary IP

I have a 3-node FCI: 1 primary / 1 secondary co-located in same data center on same subnet, and 1 secondary in a DR data center on another subnet. Periodically, the virtual IP (VIP) for the AG ...
Jim Vogler's user avatar
0 votes
1 answer
8k views

MySQL DNS issue: skip-name-resolve connection fast but cannot log into email

MySql is used here with remote network connections, and after a reboot of the server these connections started taking 20-30 seconds to connect causing timeouts. Connections used to be nearly instant. ...
STWilson's user avatar
  • 181
1 vote
1 answer
899 views

ODBC can't connect to internal MySQL without external network

Running ODBC 5.2 (10.0.0.10) and MySQL 4.x (10.0.0.50). Yes, I know that ODBC 5.x dosen't officaly support MySQL 4.x but it was working fine for ~8 months till now when we have little problems with ...
Gen's user avatar
  • 193
2 votes
2 answers
177 views

Creating an index of wildcard DNS names

I want to have a table column which will be filled with wildcard-type DNS entries, like *.example.org *.popularisp.net such that I can make fast queries against actual reverse DNS hostnames, ...
Daphne Preston-Kendal's user avatar
1 vote
0 answers
440 views

IP from a different subnet is registered even after node and resource were removed

We run two SQL server at primary site in AlwaysOn High Availability Group on subnet 10.10.0.0/24 A third SQL server is running on secondary site in a different subnet 10.10.1.0/24 We have had third ...
clunkyorange's user avatar
1 vote
1 answer
932 views

AlwaysOn Listener and DNS

We have two DNS servers which replicate entried between them and we recently had a DNS issue where some of the listener addresses were removed from one of the servers only. At that point some of our ...
Tom's user avatar
  • 1,549
1 vote
2 answers
715 views

PostgreSQL/ Linux, way to have DNS forward to a port/cluster?

Aws linux(centos) ec2 Host: mydb. 10.10.10.10. 3 clusters: ports 5432, 5433, 5434 What I'd like to see is: db2.mydb or mydb/db2 connect/fwd to cluster2 (5433). Anything Linux or psql come to mind? ...
ShawnMTherrien's user avatar
1 vote
1 answer
1k views

How to design database for DNS?

What tables will be there.Also as read percentage will be significantly larger than write, is indexing on columns advised? What other precautions are necessary? For now, I can just think of 1 table ...
user avatar
5 votes
1 answer
1k views

Suggest better design pattern for reverse DNS lookups

I'm working on a project where I need to look up the hostnames associated with IP addresses who were logged making HTTP requests. The lookups currently happen as part of a daily ETL job. The current ...
James Lupolt's user avatar
  • 4,258
7 votes
2 answers
9k views

How do I change SQL Server 2012 Availability Group DNS subdomain?

Questions: how can I get my availability group to be registered as ag-ewgtest.sql.company.com given that my server thinks of itself as server.company.com. Setup: my SQL Server 2012 availability group ...
Elijah W. Gagne's user avatar
2 votes
2 answers
9k views

MySQL slow queries - Fast using PHPMyAdmin , low CPU and RAM usage

I have a site running on Amazon EC2 , which runs fast and contains some reasonably complex MySQL queries. Part of that site is an API which serves out data to another site. These queries are very ...
user156809's user avatar
14 votes
3 answers
30k views

How to grant multiple users privileges; MySQL

I have the following code: GRANT SELECT,INSERT,UPDATE ON db1.* TO ‘user’@example.com; I am a beginner in mySQL, I was wondering if there is a method in which I can specific the privileges for every ...
Mr.Z's user avatar
  • 241
4 votes
2 answers
755 views

Remove nulls from TSQL connection string

I have a bunch of queries, against a couple different databases, that I use to generate delimited reports. I'm trying to create some new reports against a MSSQL database and I'm having trouble ...
WernerCD's user avatar
  • 1,225
3 votes
2 answers
4k views

MySQL Replication via DNS Failure

I'm having some trouble using replication when the machines are configured to use host names instead of IP addresses. The "skip-name-resolve" is OFF. If I use IP addresses, everything is fine. Using ...
Dave Rix's user avatar
  • 1,353