Manual Testing, Technology

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...

by Rachit Sethi
Tag: Database
25-Jul-2016

AWS, DevOps

Python Borrowing Resources using Fabric

In my previous blog post, I wrote about Cost Optimizations for the various AWS resources. The script consisted of six methods and the overall time required for the script to execute was roughly about 15-20 mins. While the script is running, it used to slow down my system. Also, there was a time consumption due to many reasons like...

by Aman Jain
Tag: Database
18-Jul-2016

Technology

Understanding syntax and creating patterns | Cypher Query Language

Cypher Query Language or CQL is the language to traverse and update graph structures in Neo4J. The language is similar to SQL and provides a declarative syntax for querying. However, it is worth mentioning that unlike SQL in which one needs to provide the complete procedure how to get records by defining joins etc. CQL's language...

by Shivam Khandelwal
Tag: Database
16-Jul-2016

AWS, DevOps

6 Tips for AWS Cost Optimization

As we know AWS provides a good edge in terms of cost over the on-premises data center or in a co-location environment with its On Demand and Reserved pricing. As it is rightly said "Reducing the overall cost is a high priority" and it is true for any organization whether big or small. By using AWS we can lower the IT costs, compute...

by Aman Jain
Tag: Database
30-Jun-2016

Technology

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...

by Shivam Khandelwal
Tag: Database
24-Jun-2016

Manual Testing, 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...

by Rachit Sethi
Tag: Database
20-Jun-2016

AWS, DevOps

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...

by Navjot Singh
Tag: Database
25-May-2016

AWS, DevOps

Elasticsearch Migration : Found to AWS EC2

Our DevOps team was using Found for one of our projects in the production environment. We have been facing a problem with found where it’s memory pressure frequently goes up and does not drop down so easily and until the time it remains up the Found was not able to serve the requests. Then, we decided to move to self-hosted...

by Navjot Singh
Tag: Database
04-May-2016

DevOps

MongoDB Replica set using Docker Networking and Docker Compose

Recently, I got a chance to dockerize a traditional MongoDB replica set. Currently, I am doing it for QA and UAT environment where MongoDB replica set is setup on a single host. So, in this blog, we will do it on a single host using Docker Networking and Docker Compose. Scenario: Set up a MongoDB replica using version 3.0.5 set...

by Navjot Singh
Tag: Database
16-Dec-2015

Application Security, Technology

Is your MongoDB publicly accessible?

MongoDB is a NoSQL database that delivers a performance oriented, highly available and scalable database system. Recently, a large number of MongoDB instances were found to be publicly accessible over the Internet. A large amount of data was leaked due to the fact that these instances were running an outdated and unpatched version of...

by Ankit Giri
Tag: Database
28-Jul-2015

AWS

Mongo Monitoring Service to ensure uptime of MongoDB

Mongo Monitoring Service(MMS) is a service that ensures that the MongoDB is up and running and can alert us when the service is stopped/restarted.It can be run on an on-premise architecture or in the cloud like AWS. Use Case We have multiple servers running MongoDB service and they are present in different environments as Production,...

by Ankit Giri
Tag: Database
30-Jun-2015

Grails

Adding field to hasMany, got MySql error ??

It's a common practice to add fields to Grails domain's hasMany block while in database a foreign key relationship is maintained for every such entry. In other words, for each foreign key, we have a column in parent table (or domain) and a reference column in other table. I was adding a field into hasMany block recently when I got this...

by Ankit Agrawal
Tag: Database
25-May-2015