Roger Hosto

Articles

Writing on databases, infrastructure, and whatever else comes up.

All Data & AI Databases Administration Development Open Source Software Personal System Administration Uncategorized

Aug 27, 2026 · Databases Administration

The IKEA method of Database Design

I recently re-encountered the IKEA concept and recognized its relevance to database design.

Aug 17, 2026 · Data & AI

Google AI Professional Certifications

I recently spent the weekend earning the Google AI Professional Cert

Jun 29, 2026 · Personal

Prioritizing Projects Effectively

This document provides a comprehensive guide to project prioritization. It begins by reframing the challenge of deciding which projects to tackle first, emphasizing the importance of evaluating initiatives based on …

Jun 3, 2026 · Databases Administration

Back to Basics: ORM and Its Impact on Database and Data Architecture

TL;DR: Object-Relational Mapping (ORM) makes it easier for developers to work with databases by automatically translating between code and data. ORMs boost productivity and code maintainability but can introduce performance …

Jun 1, 2026 · Personal

After several years away from blogging

After several years away from blogging

Jan 5, 2018 · Databases Administration

MySQL Error: 1062 'Duplicate entry' Error

The all too common MySQL 'Duplicate entry' Error. mysql> show slave status\G; *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: master-mysql.local Master_User: repl Master_Port: 3306 Connect_Retry: …

Mar 3, 2017 · Databases Administration

Installing MariaDB 10.1 on CentOS 6.8

MariaDB is a fork of the MySQL; it is notable for being led by the original developers of MySQL and is community-developed. The original developers forked it due to concerns …

Feb 28, 2017 · Open Source Software

Linux Mint

Linux Mint Linux Mint is a community-driven Linux distribution based on the popular Ubuntu and Debian. Initially released on August 10, 2006, and with ten years to grow, it has …

Nov 14, 2016 · Databases Administration

Querying Apache Hadoop Resource Manager with Python.

Querying Apache Hadoop Resource Manager with Python. I was recently asked to write a script that would monitor the running application on the Apache Hadoop Resource Manager. I wonder over …

Aug 26, 2016 · Databases Administration

Resizing InnoDB Logs

If you have already created your database and you change the setting for "innodb_log_file_size=###M" and restart here you database and get an error that looks something like InnoDB: Error: log …

Page 1 of 7 Older →