Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [dns]

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

39 questions
14
votes
3 answers

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 user in this domain network without having to type…
Mr.Z
  • 241
  • 1
  • 2
  • 4
7
votes
2 answers

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 is on multiple subnets, similar to what's…
Elijah W. Gagne
  • 705
  • 2
  • 12
  • 22
7
votes
2 answers

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 different database server without changing the…
SwissCoder
  • 369
  • 1
  • 4
  • 11
5
votes
1 answer

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 method is to use a scalar CLR function (similar…
James Lupolt
  • 4,278
  • 5
  • 31
  • 46
4
votes
1 answer

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 feedback about it. It is using SQL0216 with…
Philippe
  • 517
  • 6
  • 15
4
votes
2 answers

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 availability. Cluster network name resource 'Cluster…
Green
  • 41
  • 1
  • 1
  • 3
4
votes
2 answers

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 replicating our other processes to get consistent…
WernerCD
  • 1,245
  • 3
  • 11
  • 19
3
votes
0 answers

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 CNAME at this server (the MI is in a VNet that is…
Lickrob
  • 84
  • 1
  • 9
3
votes
2 answers

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 DNS names, it all stops. On the Master…
Dave Rix
  • 1,343
  • 9
  • 16
2
votes
2 answers

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 simple (one is literally returning one row from a…
user156809
  • 121
  • 1
  • 3
2
votes
2 answers

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, matching foobar.example.org to the first one above and…
Daphne Preston-Kendal
  • 131
  • 4
1
vote
2 answers

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? In mssql I'd have named instances as an option To…
ShawnMTherrien
  • 107
  • 1
  • 1
  • 6
1
vote
1 answer

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 containing two columns namely domain and ip address…
SandV
1
vote
0 answers

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 sessions cannot be connected. The secondary mongod…
user3752071
  • 11
  • 1
1
vote
2 answers

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-server (same subnet) client (different…
Chiu Chun Yu
  • 21
  • 2
1
2 3