Category: Databases Administration
-
Quick Start To Using MongoDB with Python on Linux
Written by
on
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…
-
Connecting Python to Oracle.
Written by
on
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…
-
Calculating The Percentage of Max Connections in with MySQL 5.1.9 and higher
Written by
on
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…
-
MySQL Functions for Converting IP Address to an Integer and Back Again
Written by
on
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;…
-
Amazon Cloud Sends in the MySQL Clones
Written by
on
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…
-
Coming up with a unique MySQL server-id
Written by
on
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…
-
Slacking off
Written by
on
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…
-
Couchdb vs. Cassandra.
Written by
on
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..
Written by
on
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…
-
SchemaSpy
Written by
on
“Do you hate starting on a new project and having to try to figure out someone else’s idea of a database? Or are you in QA and the developers expect…