The database server and software is being updated by our hosting company. This means we need to migrate the data to the new system and this means a few changes for a short period.
newsotadata has had writes disabled. It writes to the same DB files as the old sotadata does.
sometime this evening (UK time) sotadata will be taken off line whilst the data is migrated.
once migration is complete, sotadata will switch to the new database
time zones permitting, newsotadata will be switched over (Andrew VK3ARR is 10hrs ahaead of me)
summits site will switch to the new database
The old DB will remain available for read operations and this means Jon’s new summits webpages and SOTAwatch 3 should keep working during the migration.
I have a snapshot taken at about 1530Z 2019-Jun-04. This is what will be restored. Now I could turn write access to the old db back on but any activations and chases submitted to it will be lost so there seems no point.
What is good is that SW3 and the new summits site are still working.
Good luck with the project, and hope the bits and bytes don’t get into a fuss with each other. And hopefully Garmin won’t be making more changes in the middle of this headache.
If it gets really aggravating, just reference this old scene from the original “Tron” ( - YouTube ) and maybe your bit will show up to help. Or at least provide a chuckle.
Things are looking good. I’d enable things now but I want to do a few tests with Jon and Andrew 1st then clean up things. Sadly my employer wants me to do some work so this will need to wait till this evening UK time.
OK, well that took longer than expected for all sorts of boring and tedious reasons.
The database is now back online using a new faster DB server and DB software. In addition whatever was causing the web server to crawl is also fixed. I was seeing downloads of about 12-30kbytes/sec and earlier it was back up to around 4Mbytes/sec, about 100x faster.
Now this is important… if you all rush to login and upload / download then there may be issues, so take it steady.
There is still a web server upgrade to come. Expect more interuptions.
A member of my local club told me very proud that he entered just today his activations to the database.
I was looking at newsotadata and told him that nothing is there.