Over the weekend we are performing a number of maintenance activities.
- Upgrade central database for c9 powered websites
- Setup a second streaming replication backup server
Saturday Night/Sunday morning, service was down for about two hours. From 3 am to 5 am for live server upgrade.
I was hoping to also upgrade the first replication backup server during this time; but the upgrade path requires me to recopy the entire database. Which is going to take 16 hours; so I abandoned trying to do this while websites were down.
Luckily most of copying can occur while websites are still running. Once copy is completed, I will need to take websites down again for about 15 minutes to establish and test the replication link. This will happen Sunday night/monday Morning.
Monday I will commission the second replicate server and finalize the migration. After another planned 15 minute outage late Sunday night, there should be no further planned downtime of c9 services.