Remote MySQL server IP change issue

rasa

• July 31, 2016 01:14

Hello everybody i hope you having grate time in any where you are in today i get a new server for Our remote and dedicated database server ( DB server is Esxi VM ) i Cloned the DB server after shut it it down to new server and change THe ip address of the CentOS ( VM ) DB server hostname : dbs1.domain.com Server hostname : hosting.domain.com Server IP : 1.2.3.4 DB Server IP : 2.3.4.5 New IP after Clone to new server : 3.4.5.6 ive switched DB to local From Mysql Profile and removed Remote server profile than i re add DB server with new password before this i reset the MariaDB ( on remote server )root user password because of forget that ! also ive updated DB Server host name IP (2.3.4.5) in /etc/hosts file with new DB server Ip (3.4.5.6) address and also i did the same on DB Server here is the strange thing when i shut down the OLD server and did change ips and reboot both cpanel and remote db server also ive checked /root/.my.cnf and /root/.my.cnf.remote hostname and user pass and eved added [host=3.4.5.6] additional to host=dbs1.domain.com i can ping hostname for db server and cpanel server form each server to correct ip ! also when i add remote profile it connect to hostname and do all updates and system apps databases change also i could connect to phpmyadmin and see all databases from root or even open specific databases from user Cpanel i also white-listed new DBserver ip on hosting server CSF ( the same was applied on DB server for IP of hosting server ) but on websites all of them get database connection error ! ( 110 Connection Timeout ) this mean they could not reach new database server when phpmyadmin could reach it on same server right after i trun old server ON websites back to working condition without problem ( and for the website that i changed db password on new server and updated its config i get access denied erro instead of working condition on old DB server or Connection time out on New server ) it seems something prevent websites acknowledge new dbserver Ip address( they all set hostname as DBServer so when i change Ip address of host name they most connect to new Ip and server ) is there any thing missing in my steps and configuration ?

• 

  rasa

  • July 31, 2016 23:49

  tonight ive tested again create another clone with a new IP ! result is the same ( i dont expect change in result !!! ) what kind of cache websites may use to query host names to old ips ?!

  0
• 

  rasa

  • August 01, 2016 00:33

  ive tried Ip address instead of host name in wordpress configurations ! and every thing worked like normal cpanel to db server connection is working i cannot update all websites host name for db server to ip there must be a cache software

  0
• 

  cPanelMichael

  • August 01, 2016 17:48

  Hello, Check to see if the new server's hostname resolves to the correct IP address from the cPanel server with commands such as:
  host host.remote-mysql-server.com ping host.remote-mysql-server.com
  Does it resolve to the correct IP address? Thank you.

  0

Please sign in to leave a comment.