Summary – Mydbops Database Meetup (Apr-2019)

Conglomeration, Collaboration and Celebration of Database Administrators Founders of Mydbops envisioned contributing knowledge back to the community. This vision is shaping up in its 3rd edition of the Meetup held on Saturday the 27th of April, 2019. This meetup edition had drawn a good amount of members from the Open Source Database Administrative Community, to … Continue reading Summary – Mydbops Database Meetup (Apr-2019)

Advertisements

MongoDB Aggregation Framework an Overview

          The MongoDB Aggregation Framework is a way to query the data from MongoDB. It helps us to break the complex logics into a simple set of sequential operations. Just like a waterfall model, Output from one stage is fed as an input for the next stage until the desired result … Continue reading MongoDB Aggregation Framework an Overview

Summary – Mydbops Database meetup 2

Mydbops database meetup was held on 26-01-2019 and 48 members from open source database community has attended this event. We had talks on MySQL and MongoDB databases. Open source database enthusiastic from companies like OLA Cabs, Searce Inc, PayTm, Quikr, Zensar, Grab, SAP labs, Travel Yarri, Meddiff and a few has travelled from other cities … Continue reading Summary – Mydbops Database meetup 2

Mongodb sharded cluster – basics

To scale any databases beyond a limit it data has to be sharded ( Distributed ). MongoDB as a document store has inbuilt sharding. 1. Sharding: Sharding is a method for distributing data across multiple machines. MongoDB uses sharding to support deployments with very large data sets and high throughput on read and write operations. … Continue reading Mongodb sharded cluster – basics

MongoDB Process List In MySQL Way

MongoDB Processlist: As a DBA from MySQL background. I always wanted to quickly visualise what process / queries running inside my MongoDB server just like i do “show processlist” in MySQL. db.currentOp(): https://docs.mongodb.com/manual/reference/method/db.currentOp/ MongoDB command “db.currentOp()” can be used for this purpose. But the command returns a lengthy JSON which is hard to quickly grasp … Continue reading MongoDB Process List In MySQL Way

MongoDB Index Usage Analysis

At MYDBOPS we have ventured into MongoDB recently. We have been exploring it deeply from Jan-2017. In most cases we see MongoDB and MySQL exists together as a part of DB Infra. We have been engaged as part of open source migration for a biggest retail in US.It involves MongoDB and MySQL as a datastore. … Continue reading MongoDB Index Usage Analysis