I saved the hardest for last. While technically not really that hard, I did want to keep the website up and running during as much of the migration as possible. As an extra complicating factor, to ease server space on my server, I stopped storing as much data in the mysql database and was storing… Continue reading Migrating mybiketraffic.com
Tag: systems
DNSmasq-uerading
ATT Fiber has been absolutely fantastic. Zero downtime for the first month and incredibly fast. One of the challenges is ATT is making money off of DNS errors. I don’t have a problem with that at all, but they have locked down their modem/router combo so that you cannot change the DNS server to force… Continue reading DNSmasq-uerading
Migrating MySQL5.6 to MySQL8.0
Whew, this turned out to be quite problematic for one of my oldest databases with spatial data. The problem turned out to be that MySQL5.6 was quite flexible with how you used spatial datatypes. I had a table with a POLYGON data type, but I had stored a bunch of LINESTRING geometries instead. MySQL5.6 …… Continue reading Migrating MySQL5.6 to MySQL8.0
di2stats.com migration
One of my longest running projects with many thousands of users now is the website di2stats.com. I just added this message to the import page and disabled the import functionality so that I can migrate the database and file data to a new server. I started the migration process this morning (which I will detail… Continue reading di2stats.com migration