Blog
Still room at Kaleidoscope for MySQL attendees
Today I received notice that next week’s Velocity conference is at maximum capacity. With just under 2 weeks before the start of ODTUG Kaleidoscope in Washington DC we still have room for late registrations.
Read moreMongoDB Experience: Server logging
By default the mongod process sends all output to stdout. You can also specify the daemon to log to file which is necessary for any production implementation. For example: $ mongod --logpath=`pwd`/mongo.
Read moreMongoDB Experience: Key/Value Store
MongoDB is categorized as a schema-less, schema-free or a document orientated data store. Another category of NoSQL product is the key/value store. It had not dawned on me until a discussion with some of the 10gen employees that MongoDB is also a key/value store, this is just a subset of features.
Read moreMongoDB Experience: Stats Example App
The best way to learn any new product is to a) read the manual, and b) start using the product. I created a simple sample application so I could understand the various functions including adding data, searching as well as management functions etc.
Read moreMongoDB Experience: Replication 101
After successfully installing and testing mongoDB it’s very easy to create a replication environment. $ mkdir -p data/{master,slave} $ mongod --dbpath=`pwd`/data/master --master --port 28011 > master.log 2>&1 & # Always check your log file $ cat master.
Read moreMongoDB Experience: Gotcha with collection names
In my earlier tests I bulk loaded data with the following command. mongoimport -d olympics -c olympic_event -type tsv --headerline -f name,id,sport,demonstration_competitions,olympic_games_contested,competitions,contested_as_demonstration_event --drop olympic_event.tsv connected to: 127.0.0.1 dropping: olympics.olympic_event imported 775 objects As you can see I imported 775 objects, however when I went to review them via the mongo interactive shell I found no data.
Read moreMongoDB Experience: What’s running in the DB
You can very easily find out the running threads in the database (e.g. like a MySQL SHOW PROCESSLIST) with db.currentOp . > db.currentOp(); { "inprog" : [ ] } No much happening, however under some load you can see
Read moreMongoDB Experience: Bulk Loading Data
mongoDB has a mongoimport command. The docs only shows the usage but not any examples. here are my first examples. data1.csv 1 2 3 4 5 6 7 8 9 0 You need to specify your database (-d) and collection (-c) for importing.
Read moreMongoDB Experience: Online Resources
Following the initial Quickstart docs you will find a lot of online documentation. The following are good places to start. Tutorial The Interactive Shell Manual Admin Zone Starting and Stopping Monitoring and Diagnostics Backups There is also a Getting Started however I found this a duplication of the Quickstart.
Read moreMongoDB 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 more