Roger Hosto
Articles
Writing about databases, infrastructure, and whatever else comes up.
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.
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 …
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 …
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 …
Apr 6, 2016 · Databases Administration
MongoDB Script for counting records in collections in all the databases
Here is a quick script. I wrote for a co-worker. var host = "localhost" var port = 27000 var dbslist = db.adminCommand('listDatabases'); for( var d = 0; d < dbslist.databases.length; …
Oct 20, 2015 · Databases Administration
Apache Oozie - Shell Script Example.
Recently I needed the ability to allow a user to submit jobs that required them to pass arguments to a shell script. While it’s easy enough to submit a job …
Jul 16, 2015 · Databases Administration
Connecting Tableau to DataStax Cassandra with Cassandra CQL ODBC.
Recently, I did some testing with Tableau Desktop connecting to DataStax Cassandra using their newly released DataStax ODBC driver. Before the release of the DataStax ODBC driver, the only way …