LEMP Stack on Debian – MySQL 5.7

So Debian comes standard with MariaDB that initially was marketed as a drop-in replacement for MySQL. So, why not run with that right? Well, after a while developers came complaining that certain functions were not working. Long story short: they needed MySQL and not MariaDB. I did some reading about it and although MariaDB was originally…

Continue Reading

LEMP Stack on Debian – Nginx config

I want to to a quick recap on probably a couple of earlier posts about a somewhat ultimate LEMP config on Debian. Today the Nginx config. In this and the next few posts I’ll be setting up the webserver, MySQL 5.7 and PHP 7.2. These last two are not the Debian default so need some…

Continue Reading

Debian rsnapshot automatic backups – Checks 3

Checking our rsnapshot backups, we’ve covered the standard rsnapshot tools like alerting and the logs, a couple of commands to check source and target sums and the last thing to do is actual restore test. Now for file restores there is not much I can say, just because it is so simple. Files are being…

Continue Reading

Debian rsnapshot automatic backups – Checks 2

As said in the previous post, we’ve got exit 0, email alerts and rsnapshot logs to be _pretty_ sure our backup succeeded. Still there are extra checks to do. For the paranoid there are globally two extra ways to check your rsnapshot backups: sum checks and actual restores. Although the latter is actually a good…

Continue Reading

Debian rsnapshot automatic backups – Checks 1

First and maybe most important note is that rsnapshot is specifically designed to make these kind of backups and is being used worldwide at different providers and at different operating systems. An exit 0 means your backup succeeded. That being said, it wouldn’t be the first time that you’re getting an email for months saying…

Continue Reading

Debian rsnapshot automatic backups – Alerting

Alerting is not enabled by default in the rsnapshot mechanism. Still there are two easy ways to get an email alert going. Although an email alert is easy to setup, there are two things I do not like about it. First you can not configure to only send an email when a backup has failed,…

Continue Reading

Debian rsnapshot automatic backups – Configuration

Now the rsnapshot configuration file is easy readable, but a bit clumsy. When you know this, you won’t have any problems though. The case is, that you must use tabs in the file separating the constants from the variables, but use spaces separating the different variables from each other. For example: rsync_long_args TAB –delete SPACE –numeric-ids SPACE –stats….

Continue Reading

Debian rsnapshot automatic backups – Installation

After our introduction, today we’re installing the rsnapshot software and do a little preparation on the filesystem. Rsnapshot heavily depends on rsync which should be already installed on your Debian servers, but you’ll see it coming back in the first command anyway. rsync is one of these tools that is about as old as Linux…

Continue Reading