Re: multiple domain names mapped to a single IP
Am 02.03.2017 um 16:41 schrieb Bruce Ferrell: There are two ways to approach this: 1.) Turn off name resolution in MySQL and only do the ACL by IP. This is probably best as name resolution can slow the database and cause outright app failure if DNS fails for any reason. 2.) Make absolutely certain the names resolve correctly in DNS... Then see point 1 above. he is talking about *server* address not the client that you always should use "skip-name-resolve" and never ever set permissions based on reverse-DNS because a) when DNS lags everything lags and b) it is easy for many people which control the PTR of their zone let it answer what ever yxou wanted to see for grant access but again: pointing with several hostnames to the same IP has nothing to do with reverse-lookup at all (nowhere) on the other hand it makes no sense at all in context of a database-server because it has no concept of vhosts at all On 3/2/17 7:01 AM, Kaushal Shriyan wrote: Is there any pros and cons to multiple domain names mapped to a single IP work in MySQL client server setup like in case of httpd webserver there is a concept of VHost having multiple domain names mapped to a single IP? For example :- int-mysqldbserver1.example.com :- 192.168.0.11 int-mysqldbserver2.example.com :- 192.168.0.11 Will there be a issue when i point full qualified domain name in the application which uses mysql client program since both domain names are pointing to the same IP? Any help will be highly appreciable. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: multiple domain names mapped to a single IP
Kaushal There are two ways to approach this: 1.) Turn off name resolution in MySQL and only do the ACL by IP. This is probably best as name resolution can slow the database and cause outright app failure if DNS fails for any reason. 2.) Make absolutely certain the names resolve correctly in DNS... Then see point 1 above. On 3/2/17 7:01 AM, Kaushal Shriyan wrote: Hi, Is there any pros and cons to multiple domain names mapped to a single IP work in MySQL client server setup like in case of httpd webserver there is a concept of VHost having multiple domain names mapped to a single IP? For example :- int-mysqldbserver1.example.com :- 192.168.0.11 int-mysqldbserver2.example.com :- 192.168.0.11 Will there be a issue when i point full qualified domain name in the application which uses mysql client program since both domain names are pointing to the same IP? Any help will be highly appreciable. Regards, Kaushal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: multiple domain names mapped to a single IP
Am 02.03.2017 um 16:01 schrieb Kaushal Shriyan: Is there any pros and cons to multiple domain names mapped to a single IP work in MySQL client server setup like in case of httpd webserver there is a concept of VHost having multiple domain names mapped to a single IP? For example :- int-mysqldbserver1.example.com :- 192.168.0.11 int-mysqldbserver2.example.com :- 192.168.0.11 Will there be a issue when i point full qualified domain name in the application which uses mysql client program since both domain names are pointing to the same IP? Any help will be highly appreciable as long there are no tls certificates are verified which in that case should contain SAN for both names a client don't care anyways for names, it just connects to a IP address relsoved over whatever method (/etc/hosts, DNS, NSS) how would a client which resolves "int-mysqldbserver1.example.com" even know that "int-mysqldbserver2.example.com" exists - it can't which answers the primary question -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
