When a relational database is not the right tool: document, key-value and graph stores, how they are operated, how to model data for them and when they belong next to a relational engine.
mongorestore –oplogReplay gives you point-in-time recovery for a whole instance, replayed from the captured oplog of a single backup. It has no equivalent for a single database or a single collection. Say you need “restore just this one collection to 4:35pm” instead of the whole instance. The supported tooling has nothing to offer for in-place namespace point-in-time recovery (PITR). The…
When the cloud admin is the threat: how SQL Server and MongoDB let you query encrypted data, and what each approach costs.
The latest MongoDB DMK release (2.3.1) introduces a lot of new features and important changes, which I will describe here. dbi services provides the DMK (Database Management Kit) to its customers for multiple technologies: Oracle, Postgres, MongoDB, etc. This toolkit is provided free of charge to all clients who work with dbi services on a consulting project. The DMK is…
When securing a MongoDB deployment, protecting sensitive data is essential. MongoDB supports encryption throughout the lifecycle of the data, with three primary types of data encryption : Among these, encryption in transit is fundamental : it protects data as it moves between your application and the database. In MongoDB, this is achieved through TLS (Transport Layer Security), which ensures that…
If you’ve ever had to deal with MongoDB after years (or even decades) of working with SQL, you’ve probably realized that querying JSON documents can sometimes be painful, to say the least. In response to this, Oracle (and others) use a not-so-native adaptation of SQL to query JSON documents. And if you’ve ever had to deal with these SQL-based JSON…
Contrary to other DBMS, MongoDB self-managed deployments generate logs in a JSON format, which can be quite intimidating at first. But instead of hoping to never have to look at the logs, you can use some tools and tips to navigate them more easily and not waste time finding the information you’re looking for. Log format overview Inside /var/log/mongodb/mongod.log (or…
Introduction Last time, we have seen how to add a Redis plugin to Grafana in order to monitor and generate graphs and charts for your reports or analysis. During this configuration you may encounter some issues or miss some steps that will end to an error message. Today we will see some typical error message and who to fix it…
Introduction: Monitoring our Redis database is one of the first thing we want to do : Checking the database status , the queries consumption and also make a report on it. For that, we will use Grafana: It is an open source analytics & monitoring solution for every database. Grafana can add some plugins to work on a specific database.I…
Introduction: Redis allows you to use many commands to create and administrate your database. There is especially one useful feature which which allows you to execute a series of commands as a single unit of work: The Redis transactions! In this post will check how it works how it can be useful for your daily work. How do transactions work?…
Introduction Whereas I wanted to perform a quick demo to show some MongoDB useful command to mass update some fields (Increment),I had a MongoDB error: “Cannot increment with a non-numeric argument” I guess the message is explicit: I can’t update this field as it is not a numeric field Identify the field type: As I have created my document with…
Hi everybody Today I will give you a feedback about ab Event organized by MongoDB: The MongoDB.local event Introduction: Last week, I made a trip to Frankfurt to attend a special event made by MongoDB, I learn a lot of things and met a lot of interesting and kind people.It was the occasion to share our knowledge and our working…
Introduction Hi everybody If you work with databases, you will be familiar with the two main philosophies used in this domain: The SQL philosophy (RDBMS) and, of course, NoSQL databases.Some examples of SQL databases are Oracle and Postgres, while Nosql databases are MongoDB and Redis.How do these two philosophies work?Is it possible to switch from one language system to the…
