cancel
Showing results for 
Search instead for 
Did you mean: 

mySQL changeover not completed

Community Veteran
Posts: 26,348
Thanks: 601
Fixes: 8
Registered: 10-04-2007

mySQL changeover not completed

It appears that the final stage of the changeover has not been completed. The London DNS servers are still returning the old IP addresses:
C:\>nslookup humbug.plus.net 212.159.6.9

Server: ptn-cdns01.plus.net
Address: 212.159.6.9

Non-authoritative answer:
Name: psh-custdb-02.plus.net
Address: 212.159.3.5
Aliases: humbug.plus.net


We should get:

C:\>nslookup humbug.plus.net ns1.force9.net

Server: ns1.force9.net
Address: 195.166.128.16

Name: ptn-custdb02.plus.net
Address: 212.159.7.144
Aliases: humbug.plus.net
jelv (a.k.a Spoon Whittler)
   Why I have left Plusnet (warning: long post!)   
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£13/month)
Mobile: iD mobile (£4/month)
25 REPLIES
JonathanW
Grafter
Posts: 2,648
Registered: 02-10-2007

mySQL changeover not completed

Its a DNS change, which I'm sure you're aware can take some time to hit all of the servers. Both of the authorative servers have the correct records on them, so its a case of waiting for the caching servers to catch up.

This isn't a major issue, as replication is still going to happen for a while whilst the DNS updates. This has already been mentioned by the man in charge of this work.
Community Veteran
Posts: 26,348
Thanks: 601
Fixes: 8
Registered: 10-04-2007

mySQL changeover not completed

So why when I put
printf("MySQL server version: %s\n", mysql_get_server_info());

in my script and run it on ccgi does it still say
MySQL server version: 4.0.18-log

:?:

If anyone is breathing a sigh of relief because everything is working this morning - think again :!:

We're still using the old servers. Cry
jelv (a.k.a Spoon Whittler)
   Why I have left Plusnet (warning: long post!)   
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£13/month)
Mobile: iD mobile (£4/month)
Community Veteran
Posts: 26,348
Thanks: 601
Fixes: 8
Registered: 10-04-2007

mySQL changeover not completed

I've put a little test script on my ccgi space which just displays the mySQL server version.

It is here: http://ccgi.elvin.plus.com/misc/sqlversion.php

If it says 4.0 we're still on the old servers - 4.1 we are on the new.
jelv (a.k.a Spoon Whittler)
   Why I have left Plusnet (warning: long post!)   
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£13/month)
Mobile: iD mobile (£4/month)
N/A

mySQL changeover not completed


It's showing as MySQL server version: 4.0.18-log still.

Re-crosses fingers; I had thought the change over went well, without any problems occurring! :mrgreen:
Community Veteran
Posts: 26,348
Thanks: 601
Fixes: 8
Registered: 10-04-2007

mySQL changeover not completed

What frightens me is the thought that after a little time with no problems they think all is well and turn the old servers off.

Still, they couldn't be that incompetant could they? ...
jelv (a.k.a Spoon Whittler)
   Why I have left Plusnet (warning: long post!)   
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£13/month)
Mobile: iD mobile (£4/month)
Community Veteran
Posts: 26,348
Thanks: 601
Fixes: 8
Registered: 10-04-2007

mySQL changeover not completed

I've now upgraded the script to


  • Show which mySQL server it is accessing
  • Which of the ccgi servers the script ran on
  • The IP address of the db server it accessed

We're still hitting the old servers - so it's not down to DNS propagation after this long.

The script is here: http://ccgi.elvin.plus.com/misc/sqlversion.php

It's gone awfully quiet at the PN end!

Edit: Add script URL
jelv (a.k.a Spoon Whittler)
   Why I have left Plusnet (warning: long post!)   
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£13/month)
Mobile: iD mobile (£4/month)
JonathanW
Grafter
Posts: 2,648
Registered: 02-10-2007

mySQL changeover not completed

Actually, it is still down to DNS not being updated yet. An nslookup run from cshell01 shows that the caching servers haven't updated yet.
Community Veteran
Posts: 26,348
Thanks: 601
Fixes: 8
Registered: 10-04-2007

mySQL changeover not completed

So wasn't the announcement that the changeover had been completed premature?

Just how long do DNS changes take to propagate to the caching servers?
jelv (a.k.a Spoon Whittler)
   Why I have left Plusnet (warning: long post!)   
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£13/month)
Mobile: iD mobile (£4/month)
N/A

mySQL changeover not completed


Non-authoritative answer:
humbug.plus.net canonical name = ptn-custdb02.plus.net

plus.net
primary name server = ns1.force9.net
responsible mail addr = hostmaster.uk
serial = 2006030801
refresh = 43200 (12 hours)
retry = 1800 (30 mins)
expire = 3600000 (41 days 16 hours)
default TTL = 86400 (1 day)

Looks like the SOA record is showing the TTL as being 1 day so it can take up to a day to refresh (though should do after 12 hours from the refresh timer).

Doing a query on all records associated with humbug doesn't throw up any specific TTL timers so the SOA values are used.
JonathanW
Grafter
Posts: 2,648
Registered: 02-10-2007

mySQL changeover not completed

No, the work has been completed and the servers are up and running. People are able to connect to the servers.

The changes on the auth servers have completed which means that as soon as the cached records on the other servers expire they'll go back to the auth server to refresh the records.
N/A

mySQL changeover not completed

Which at worst case (the caching servers updating just prior to the change) can take 12 hours if the refresh timer is used...
Community Veteran
Posts: 26,348
Thanks: 601
Fixes: 8
Registered: 10-04-2007

mySQL changeover not completed

Quote
No, the work has been completed and the servers are up and running. People are able to connect to the servers.


Correct me if I'm wrong, but the only way to be using the new servers right now is by explicitly using the new IPs or by using the authorative servers for DNS lookups?
jelv (a.k.a Spoon Whittler)
   Why I have left Plusnet (warning: long post!)   
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£13/month)
Mobile: iD mobile (£4/month)
N/A

mySQL changeover not completed

Or you can wait for the update to the caching dns server to occur.

One concern - are the servers still configured for replication so changes to the databases on the old servers will still be replicated across to the new servers?

If not then... i'll leave the rest of that sentance unsaid :twisted:
Community Veteran
Posts: 26,348
Thanks: 601
Fixes: 8
Registered: 10-04-2007

mySQL changeover not completed

This mornings Service Status posting said:
Quote
We are pleased to announce that the upgraded SQL platform has been launched. We would advise that you check your sites to ensure that everything is functioning correctly and if there are any issues we would recommend contacting the author of the script in question.


What the hell is the point of telling us to check our sites if the DNS hasn't updated and we're still running against the old servers?
jelv (a.k.a Spoon Whittler)
   Why I have left Plusnet (warning: long post!)   
Broadband: Andrews & Arnold Home::1 (FTTC 80/20)
Line rental: Pulse 8 Home Line Rental (£13/month)
Mobile: iD mobile (£4/month)