I am contemplating migrating our cPanel 11.30 server to use a remote MySQL server due to server load. I understand that I must move the databases manually (using mysqldump, etc). My main concern is the clients PHP-based sites that use MySQL.
Almost all of the scripts have some sort of 'host' designation in the mysql connection, and, of course, they are all set to 'localhost'. If I migrate to a remote MySQL server, will all of the clients have to update their PHP to use the new hostname? Or does the my.conf changes 'remap' the localhost requests to the remote server?
Thanks!
Almost all of the scripts have some sort of 'host' designation in the mysql connection, and, of course, they are all set to 'localhost'. If I migrate to a remote MySQL server, will all of the clients have to update their PHP to use the new hostname? Or does the my.conf changes 'remap' the localhost requests to the remote server?
Thanks!
