MySQL

A collection of 2 posts

Off-site Backup of your Ubuntu Linode with Duplicati (with MySQL, Jira, and GitLab) + Healthchecks.io

I use a two-pronged approach to back up up my Ubuntu Linodes: I use Linode's own backup serviceDuplicati to back up specific directories & mysqldump of my databases to Backblaze B2For an overview

Full Story

Sunset and Sunrise Calculation Based on Latitude, Longitude and UTC Offset for MySQL

This is an implementation of the United States Naval Observatory's algorithm for calculating sunrise/sunset based on latitude, longitude, and current timezone. It is a translation of a solution published on CodeProject by

Full Story