This is the third and final post in the series of blog posts for MongoDB replica set backups with Point In Time Recovery (PITR). This will be focused on restores, particularly details on PITR using the full and incremental backups….
Read More >This is the second post in the series of blog posts for MongoDB replica set backups. I’ll try to show you how to properly run incremental backups using the oplog.rs collection. Restores with PITR using the full and incremental backups…
Read More >In this series of blog posts for MongoDB replica sets, I will show you how to properly run full backups using lvm snapshot followed by incremental backups using the oplog. I will also cover restores with point in time recovery…
Read More >Indexes increase read performance and allow queries to access data faster. But they also need to be updated when the indexed keys are created or modified, which consumes additional time to complete C*UD operations. In this blog post, we will…
Read More >Indexing plays a quintessential role in database query performance and MongoDB is no exception. Choosing the best index for a query will improve its performance, while a bad one could lead to huge execution times and high memory utilization. In…
Read More >Recently a client came to me asking “How do we verify if a full text search index is being used on MongoDB?” The db.showIndexes() command shows an index on a text field, but explain() shows COLLSCAN and the query is…
Read More >I had interesting use case with a MongoDB replica set I’d like to share. When the replica set consists of four nodes and the Primary goes down, no new node is elected to become the new Primary. The replica set…
Read More >It’s November, time for MongoDB Europe event. For the second consecutive year, London hosted all the MongoDB experts to share what is new and exciting about the most popular NoSQL database in the world. After I missed the event last…
Read More >MongoDB’s database profiler lets us collect some performance data about operations happening on a MongoDB instance. In this post, I will show you how we can enable the profiler, what kind of information it can store for us, how to query this…
Read More >Valeriy Kravchuk’s great recent post on using oprofile to profile MySQL mentioned how pt-stalk, the script from Percona Toolkit to capture diagnostics data based on a detected condition, currently does not support the new operf comand, and relies instead on the deprecated and soon…
Read More >