Re: multiple domain names mapped to a single IP

2017-03-02 Thread Reindl Harald
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 ce

Re: multiple domain names mapped to a single IP

2017-03-02 Thread Bruce Ferrell
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

Re: multiple domain names mapped to a single IP

2017-03-02 Thread Reindl Harald
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-mysqld

multiple domain names mapped to a single IP

2017-03-02 Thread Kaushal Shriyan
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-mysqld

Re: Changing a field's data in every record

2017-03-02 Thread Hal.sz S.ndor
2017/02/18 ... debt: Is there a formula to change the format of the data in a single field in every record of a table? She has a "timestamp” in a text field formatted as 2017|02|16|04|58|42 and she wants to convert it to a more human readable format like 2017-02-16 @ 04:58:42 It no