Roger Hosto
Articles
Writing about databases, infrastructure, and whatever else comes up.
May 16, 2011 · Development
Simple HTTP Server with Python
Ever needed a quick web server to share something with a Windows user from you Linux box. Python has really easy to use embedded HTTP Server. Just try the following.shell> …
Jan 15, 2011 · Databases Administration
Slacking over the Holidays
So December was an interesting month for me, with a few changes in my personal career and the holidays. I take a week off. Which of course lead me spending …
Nov 19, 2010 · Databases Administration
Connecting PHP to An Oracle Instance on RedHat or CentOS 5
Here lately it seems that everyone wants to connect to Oracle, but I have to admit this was the first time someone asked me to get PHP to talk to …
Nov 18, 2010 · Databases Administration
Quick Start To Using MongoDB with Python on Linux
With it's rapid growth in popularity MongoDB is quickly becoming one of the top NoSQL Databases out there and with Python being one of the top ten programming languages according …
Nov 7, 2010 · Databases Administration
Connecting Python to Oracle.
In the current world of heterogeneous networks it seems that you need to be able to connect to ever type of database system out there. In a recent project, I …
Nov 5, 2010 · Development
Why You Should Looking at Python.
Python is an interpreted, interactive, object-oriented programming language. Python includes modules, classes, exceptions, very high level dynamic data types and dynamic typing. Python has also been one of the top …
Oct 25, 2010 · Databases Administration
Calculating The Percentage of Max Connections in with MySQL 5.1.9 and higher
For longest time it had bugged me that there wasn't an easy way to put "SHOW STATUS", "SHOW VARIABLES", or "SHOW PROCESSLIST" variables into queries, so I could easily calculate …
Oct 14, 2010 · Databases Administration
MySQL Functions for Converting IP Address to an Integer and Back Again
So after my MySQL server-id idea. I was asked to come up with a function to Convert IP Address. So here it is. use test; DROP FUNCTION IF EXISTS IpToInteger; …
Oct 8, 2010 · Databases Administration
Amazon Cloud Sends in the MySQL Clones
Amazon is making it easier, and cheaper, to roll out copies of MySQL for very large websites across its cloud. On Tuesday, the company announced an update to its Amazon …
Sep 22, 2010 · Databases Administration
Coming up with a unique MySQL server-id
The server-id, is used in replication to give each master and slave a unique identity. For each server participating in replication, you should pick a positive integer in the range …