In one of my latest database restore jobs, I was helping a MySQL client with issues related to mysqlbinlog and I wanted to share it here. In case you didn’t know, MySQL is a simple SQL shell with input line…
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 >Igor Donchovski, Database Consultant at Pythian, explains the MongoDB Operations log. Discover how the replication window compares to MySQL, how to change the oplog size, and what is improved in MongoDB 3.0 wiredTiger engine.
Read More >