Utility mongorestore allows you to load data into the database. It requires a file (dump) that contains a BSON . Such a file can be created using different tools mongodump . The second utility mongoimport allows you to import data…
Inception MySQL was created by a Swedish company MySQL AB in 1995. The developers of the platform were Michael Widenius (Monty), David Axmark and Allan Larsson. The foremost purpose was to provide efficient and reliable data management options to…
mtools mtools is a collection of helper scripts to parse and filter MongoDB log files (mongod, mongos), visualize log files and quickly set up complex MongoDB test environments on a local machine. Installation procedure :- Step 1:…
MongoDB as an pure in-memory database, meaning that the data is not stored on disk at all. This can be super useful for applications like: A write-heavy cache in front of a slower RDBMS system Embedded systems PCI compliant systems…
mdiag is a shell script which will gather a wide variety of system and hardware diagnostic information of the MongoDB server. Please see below for how it works. mdiag shell script: [Lab root @ hostname /tmp]# cat mdiag.sh #!/bin/sh…
This is a very basic technique, but that’s how I like to start. I will also show a couple tricks when working with large data files. Editing large files Let’s assume you have a large data file, approximately 60MB with…
Hadoop provides two web interfaces that you should become familiar with, one for HDFS and the other for MapReduce. Both are useful in pseudo-distributed mode and are critical tools when you have a fully distributed setup. The HDFS web UI…
For people coming from RDBMS you must be remembering the alter table command for dropping/adding columns in a table. In MongoDB it is possible to do this operation on some of the documents (rows) or all documents together. There is…
Replication gives you hot backups, read scaling, and all sorts of other goodness. If you know how it works you can get a lot more out of it, from how it should be configured to what you should monitor to…
Do you have issues with you SSH in your lab/test VMs which has no proper builds and thus it’s effecting SSH Tectia functionality. No issues, below works for me – please have a try. Not sure how far this is…