Database, Grails

SQL Your Application Safe?

We all have search functionality in our applications. It is one of the most core features you would find ranging from searching for users, products, companies, etc.  But are you sure your search functionality is doing exactly what it is supposed to do? You might have written test cases for it as well. But still, there are things...


Database, DevOps

How to Set up PhpPgAdmin for PostgreSQL?

PostgreSQL is a powerful, open source object-relational database system (ORDBMS). The version 8.0 and above also comes with the native Windows compatibility. Compared to other RDBMSs, PostgreSQL differs itself with its object-oriented and/or relational database functionality, such as the complete support for reliable transactions,...


Database, Druid

How to Reduce the Number of Druid Segments?

We have been using Druid in our project for a while and had shared our experiences during GIDS. It has given us great results as it powers our real-time dashboards, reports on running Ad campaigns and provides real-time data to make quick decisions. But like any other databases there will be times when it needs to be optimized. This is...


AWS, Database

10 Things To Keep In Mind While Migrating The Applications Between Two Cloud Platforms

Applications’ infrastructure migrations are a vital area of DevOps field. So many times, we need to migrate the applications from one cloud platform to the other. In order to carry out the migrations in an appropriate way, we should have some set of standards defined which make migrations smooth. In this blog, I’ll be discussing...


Database, MongoDB

Too Many Indexes May kill your DB performance

Everyone thinks of creating index, but nobody pays attention towards removing them once they are created and not required .Too many indexes or unnecessary index can degrade your DB performance. To Optimize indexes in mongo we need to understand following things : How indexes works in mongoDB: Let’s say we have created compound...


Database, Manual Testing

How to Perform Database Testing?

In the previous blogs, Overview of Database Testing and What should we test in a Database we got a fair idea about database testing concepts and types of database testing. Now with this blog, we are moving a step ahead to enhance our knowledge by defining the keys steps that will help in performing “Database Testing” DBMS vs RDBMS ...


Database, Manual Testing

What Should We Test in Database?

In the previous blog on Overview of Database Testing, we had discussed the basic concepts like database, database testing, the need for database testing and how to perform database testing. In this blog, we will be diving deep into the world of database testing and throw some light on what we need to test in a database? Types of Database...


AWS, Database

Troubleshooting MongoDB Replication Cluster

MongoDB is an efficient, reliable and fast processing database for the applications which generate the data in a schema-free manner. For high-availability of data in MongoDB, we use MongoDB replicas. We generally face some issues in managing and syncing the cluster, which doesn’t let us achieve the full flavour of Mongo...



Up and Running with Neo4J

 Neo4J is a NoSQL database that stores information in the form of a huge property graphs where tuples/rows (nodes) are connected to each other with relationships (edges) both of which can have variable number of properties associated with them. Traversing data in the form of graphs implies that we can explore highly connected...


Database, Manual Testing

Overview of Database Testing

With a mushrooming number of internet users, the data creation, storage, and retrieval has reached new heights and so has the number of issues arising due to these activities. The major source of origin of these failures/defects lies in minimal attention paid towards database handling and testing. So what do we understand by Database and...


Database, DevOps

Running Curator in Docker container to remove old Elasticsearch indexes

We have been using ELK as a centralized logs management system. ELK stands for Elasticsearch, Logstash, and Kibana. Each of the three services is running inside its own docker container in one docker-network (say elk-net) on a single server. A separate block storage device is mapped from the host into Elasticsearch container (named es)...


AWS, Database

Elasticsearch: Shard Filterting

Our cloud DevOps engineers have been using Elasticsearch on production environment for an e-commerce website for quite a while. The website has one admin server to manage activities such as adding new production, managing discounts on various items, fetching reports etc. We came across a requirement where downloading reports from admin...