MySQL RDS Point-in-time restore

RDS for MySQL on AWS allows you to restore to any point in time for your backup retention period, minus the last 5 minutes or so. Restoration creates a new instance, it does not overwrite whatever instance you’re restoring. AWS’s use of the word restore is a bit confusing because restore often means “take your production database server and overwrite it with data from a backup”. As far as I can tell, Amazon never means this. When you restore, AWS creates another database server and writes all the data to the new instance, both when you’re using restoring to a point-in-time or from a DB snapshot. If you needed to switch servers, you’d have to point your database to the new instance.

Reference

Tagged with: ,
Posted in Databases, IT

Announcing Secrets Escrow

I’ve often wanted a way to have access to emergency-use passwords. When I as a database administrator, I didn’t need God-level permissions on my servers for everyday work, I only needed those in dire circumstances such as server failure. Since there wasn’t a good way to ensure I that I could fix stuff during emergencies, I just got God-level permissions. This isn’t the best idea, however. The more people with those permissions, the bigger the risk. In the end, it’s better to have everyday, low-risk permissions but a way to “break the glass” and get root/admin privileges during a crisis. Read more ›

Posted in Product-Launch

The technology behind Leaderboard

I just finished my first solo product, Leaderboard, a SaaS app for managing competitions. I’ve done tons of little side projects, but I either abandoned them or I built them only to learn a new language, framework, or stretch my programming ability. I’ve had a lot of things going on in my life since the beginning of the project (just like everybody else). Regardless if I make one cent or not, I’ve finished a product (meaning I got software working to a point that someone could pay me and built-in a way for someone to pay me). Read more ›

Posted in Programming

Announcing Leaderboard

I’m pleased to announce Leaderboard, a simple competition management service that helps organizers score their event. It’s my first product and I hope that it’s something that useful to competition organizers. Read more ›

Posted in Uncategorized

F# vs Clojure: new paradigms for old platforms

I decided that it was time to get into a new language. Being the unfocused, indecisive person that I am, I couldn’t decide between Clojure and F#, so I chose both. In a way, they are very similar. Both were made to interoperate with a mature, popular language inside of a VM while using an entirely different programming paradigm from its host language. Read more ›

Tagged with: , ,
Posted in Programming