MongoDB Experience: Getting Started
Getting started with MongoDB is relatively straight forward, following the instructions from the Quickstart guide has you operational in a few minutes. I like projects that provide a latest version link for software.
Read moreMongoDB Experience: History
My first exposure to MongoDB was in July 2008 when I was a panelist on “A Panel on Cloud Computing” at the Entrepreneurs Round Table in New York. The panel included a representative from 10gen the company behind the open source database product and at the time Mongo was described as a full stack solution with the database being only one future component.
Read moreOracle resources for the MySQL Community
While I have spent a lot of time recently helping the MySQL community interact with and integrate with various Oracle User Groups including ODTUG, IOUG, NoCOUG, NYOUG, DAOG I thought I’d share some resources for the MySQL Community that wanted to know more about Oracle.
Read moreWhy is MySQL documentation search so wrong?
I just don’t get this I don not know what the technology is behind the search box at MySQL Documentation but it annoys me when I want to see the syntax of a command and Search can’t find the page, when a dedicated page exists and I’m using the exact syntax of both the command the title of the page.
Read moreI’ll have a MySQL shot to go!
Wednesday night of the MySQL track of ODTUG Kaleidoscope will include an evening with Last Comic Standing comedian, John Heffron . It should be great way to unwind after day 3 of the conference.
Read moreWhen SET GLOBAL affects SESSION scope
We have all been caught out with using SET and not realizing that the default GLOBAL Scope (since 5.0.2) does not change the current SESSION scope. I was not aware until today that changing GLOBAL scope has some exceptions that also automatically affect SESSION scope.
Read moreBest Practices: Additional User Security
By default MySQL allows you to create user accounts and privileges with no password. In my earlier MySQL Best Practices: User Security I describe how to address the default installation empty passwords.
Read moreEventually consistent Group Commit
Having just written an interview response about NoSQL concepts for a RDBMS audience it was poetic that an inconspicuous title “(4 of 3)” highlights that both a MySQL read scalable implementation via replication and a NoSQL solution can share a common lack of timely consistency of data.
Read moremk-query-digest Tips – Showing all hosts & users
The Maatkit tools provide a suite of additional MySQL commands. There is one command I use constantly and that is mk-query-digest. Unfortunately the documentation does leave a lot to be desired for usability.
Read moreImageMagick on Mac OS X
Wanting to do some image manipulation I realized my Linux scripts don’t run under Mac OS X, as ImageMagick is not installed via my MacPorts . However installation failed: $ sudo port install imagemagick ---> Computing dependencies for ImageMagick ---> Verifying checksum(s) for xorg-libX11 Error: Checksum (md5) mismatch for libX11-1.
Read moretcpdump errors on FreeBSD for mk-query-digest
While I use this tcpdump command for MySQL query analysis with mk-query-digest , I found recently that it didn’t work on FreeBSD $ tcpdump -i bge0 port 3306 -s 65535 -x -n -q -tttt -c 5 tcpdump: syntax error It left me perplexed and reading the man page seemed to indicate my options were valid.
Read moreThe code word is?
For ODTUG readers, the code word is “Wombat”. Hope to meet many of you next month.
Read moreMySQL Best Practices: User Security
It is critical that you do not use the default MySQL installation security, it’s simply insecure. Default Installation When installed, MySQL enables any user with physical permissions to the server to connect to the MySQL via unauthenticated users.
Read moreMySQL Monitoring – What’s really needed
The implementation of MySQL Monitoring is critical for any organization that uses a database and wants to avoid the inevitable disaster. There are 3 important components that all serve a key purpose to “MySQL Monitoring” in general:
Read more