MongoDB Export cmd
Here’s is a simple MongoDB ‘mongoexport’ command syntax to backup the document/database. This command can be used to backup based on particular conditions (‘where’ clause) Go to MongoDB bin directory and execute as below:./mongoexport –host localhost –port 10000 -d doc_name…
How do we exclude SQL from replicating in MySQL
If you’re using MySQL Replication, in rare cases you may require to skip a particular SQL statement from replicating – which is to be executed on Master and should not be on the Slave. Though, its not a good practice!…
Remote file transfer using Rsync
While we usually deal with huge data, we come across situations where we need to copy such data from one server/host to a remote host. One of the useful command is ‘rsync‘, which is faster than the traditional scp command!…
MySQL Installation
While you have a basic idea about MySQL, I would recommend the real-time trial and error than just reading out. For that, download a latest stable community version of MySQL from the official website. Though MySQL is platform independent, its…
MongoDB vs MySQL
Here is a comparison between MongoDB and Relational database, MySQL: Because of distributed key value store, MapReduce calculation capability and document oriented NoSQL features, MongoDB® is The database for Big Data processing.
[MongoDB]: Clients
While mongo shell provides an excellent non-GUI way to interoperate with the data, there are many GUI tools available to view/modify MongoDB data and also to provide support for administrative tasks in a more graphical manner. Best place to start…
[MongoDB]: How do we create indexes
Let’s say you have a query which takes around 120 ms to execute without indexes i can assure you that with proper indexes you can reduce that time by at least 10 times in MongoDB. Let me show you with…
How do I start MongoDB
If MongoDB installed successfully through RPM installation/any other process, you’ll usually see the below Mongo binaries in the bin (eg. */opt/mongodb/bin*) folder which will be useful to start the Mongo processes (mongod&mongos). [user@hostname bin]$ pwd /opt/mongodb/bin [user@hostname bin]$ ls -lthr…
Introduction to MongoDB world
MongoDB is an opensource , schema less , nosql database. It uses a form of JSON to store and manipulate its data. Datais actully stored in BSON format which is acronym of binary Json. BSON comes with some utilities on…
MongoDB ONLINE FREE COURSES
M101J: MongoDB for Java Developers Introductory Learn basic installation of MongoDB, JSON, schema design, querying, insertion of data, indexing and working with language drivers. The course project involves building a blogging platform with MongoDB. Code examples will be in Java….