Questions tagged [dns]

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

Filter by
Sorted by
Tagged with
7
votes
3answers
15k 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 ...
6
votes
2answers
371 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 ...
6
votes
2answers
7k 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 ...
5
votes
1answer
899 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 ...
4
votes
2answers
714 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 ...
3
votes
1answer
48 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 ...
3
votes
2answers
3k 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 ...
2
votes
2answers
4k 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 ...
2
votes
1answer
15k 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 ...
2
votes
2answers
89 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, ...
1
vote
1answer
701 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 ...
1
vote
1answer
406 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 ...
1
vote
1answer
2k 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 ...
1
vote
2answers
408 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? ...
1
vote
0answers
11 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 ...
1
vote
0answers
137 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 ...
1
vote
0answers
286 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 ...
0
votes
1answer
643 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 ...
0
votes
1answer
32 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. ...
0
votes
0answers
30 views

MongoDB replica set in swarm gets very slow when one node is down

I created a 3 nodes replicaset with mongodb that I host in a swarm environment. To do so, I created 3 services mongo1, mongo2, mongo3 with the same configuration. When I challenged the resiliency of ...
0
votes
1answer
59 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, ...
0
votes
1answer
3k 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. ...
0
votes
0answers
370 views

How to create 2 MySQL Databases replication in real time, based on Dns Failover Website

At the moment I have server running with php+mysql+nginx+bind, its a backend system that i have developed for managing set-top-boxes(satellite boxes, iptv,ott boxes), based on clients actions it ...