MySQL Server Update Today, No Downtime

I use the home-computer I name ‘Phoenix’ as my Web-server. This means that I’m always looking for ways to complete routine system updates, without wanting my server to go offline, as my server going offline would also mean, that for several minutes, my site is not accessible to the public. My server would go offline for a few minutes, if I simply needed to reboot it.

Today came another time, when an update to my MySQL (Database-) Server became due. I have two instances of MySQL running:

  1. As a system process, which serves my Web-site and blog,
  2. As a user-process, which serves the desktop-PIM-daemon also known as “Akonadi”.

Simply having installed the MySQL update, will assure that the system-process is also restarted. But it will not assure, that the user-process is also restarted.

In such cases, what I can often do, is, after the update is finished, Log Out my user-session, and Log it back In. Doing so does not fully reboot the computer, but just restarts the user-space processes, which make up my session, including Akonadi, and including that MySQL user-process.

Today, after the update itself, I performed such a log-out-followed by the log-in. What this means is that my Web-site should have remained accessible the whole time. Yay!

This was the last time, I had accomplished the same thing.

Dirk

 

Routine WordPress Update Today.

One of the facts which I’ve written about often, is that I host my site, and therefore my blog, on my private computer at home, named ‘Phoenix’.

One advantage this gives me, is the ability to program my Web-server in any way I please. When people subscribe to Web-hosting services, unless they are subscribing to a Virtual Private Server, they receive whatever set of server-side resources their hosting service is willing to offer them. This way, I get to install those myself.

The WordPress blogging engine of this blog, is similar to ‘WordPress.org‘, but is actually a version, the core files of which are managed by the Debian Package Maintainers. This WordPress installation just received an update this morning, to version ‘4.1+dfsg-1+deb8u16′. One detail which is tricky in my case, about receiving updates to the core-files via the package-manager, is that I nevertheless subscribe to plug-ins, from WordPress.org. Therefore, If I did not manage the application of the package-update correctly, I could end up with a mess on my hard drive, since what most Debian package maintainers expect, is for their users to receive all updates to their software, from them.

I’m happy to say that this update seems to have taken place smoothly, and in a way that respects the arrangement of files which I have between core files, maintained by Debian, and plug-in files, maintained by me.

All systems are go, and there was no appreciable downtime.

Dirk

 

Routine Update to my Apache Server Today

As I have written many times, I host my Web-site and blog on my own server, from home. The actual Web-server is a complex piece of software called ‘‘.

Today, a set of updates was pushed through the Debian repositories, specifically to this server. This update meant that I was briefly offline from about 20h15 until 20h17.

My site is up again, and this time around, there was never any need for me to restart my caching daemon, for which reason the response of my server to the routine queries by readers should not be slowed down.

Enjoy.

Dirk