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 Oracle. It was a lot less painful then I thought it would be, so here is what I did. A long with the standard PHP…
Databases Administration
Covering NoSQL, Relational Database, Data Visualization, and Reporting.
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 to Tiobe Software’s Programming Community Index. I’ve decided to write a quick how-to to show you just how easy it is to get started with…
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 was asked, to take an existing MySQL and Python system and get it to connect to an existing Oracle Data Warehouse system. To be honest,…
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 stuff like max connections percentage. Then MySQL 5.1.9 came out and you could final start to do SELECT statements on information_schema.GLOBAL_STATUS, information_schema.SESSION_STATUS, information_schema.GLOBAL_VARIABLES, information_schema.SESSION_VARIABLES and…
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; DELIMITER // CREATE FUNCTION IpToInteger ( ipAddress CHAR(15) ) RETURNS INT UNSIGNED DETERMINISTIC BEGIN DECLARE o1,o2,o3,o4 char(3); DECLARE IpInteger INT UNSIGNED; SET o1 = REPLACE(SUBSTRING(SUBSTRING_INDEX(…
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 Relational Database Service that will let users create and delete multiple Read Replicas of MySQL instances in minutes, via a point-and-click interface. Full Story Here
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 from 1 to 2^32 – 1 to act as that server’s ID. To come up with this id convert the IP address of the server…
Slacking off
Well I haven’t really wrote anything in the last couple of months even though, I have had plenty to write about. I went to OSCON 2010 in July and had a great time. I learned more about MongoDB and picked up a few more bits of information on MySQL, Memcached, and Linux. In July I…
Couchdb vs. Cassandra.
And Cassandra wins by a knock out and the crowd goes wild. http://couchdb.apache xenical buy online.org/ vs.http://incubator.apache.org/cassandra/. Couchdb is more user friendly, but Cassandra is way more advanced.
MySQL Workbench..
The MySQL Workbench has been out for a little while now, and I kind of put it to the back of my mind, because when it come out it was on Windows only. I, myself use Linux about 90% of the time, so I figured I would wait until they had a Linux version. The…