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 […]
AWS DMS is a web service that is used to migrate the databases to and from an Amazon RDS DB instance, or a database on an Amazon EC2 instance, or on-premises. We can migrate data between homogenous or heterogeneous database engines. One of the two endpoints must always be in AWS. The source and target […]
In my previous post, we learnt about how to launch RDS Aurora instance. The storage space of RDS Aurora is automatically scalable up to 64 TB and the read scaling can be achieved by creating up to 15 replicas in the cluster. I had migrated database into RDS Aurora to avail fault tolerance feature. Once […]
Full Text Search is searching a string among multiple coulmns of a table to fetch the more relevant records. In this blog we will demostrate how to implement full text search to fetch relavent responses. There are few simple steps to implement full text search in mysql- 1. Create table with full text schema [java] […]
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 […]
In this blog we will setup the jmeter and we will see how to create a simple test plan to test the database server.We will use MySql database server for our test purpose or you can use any-other database. Setup requirement Download the latest jmeter from here and untar jmeter in you home directory. Download JDBC driver […]
Amazon RDS provides us with three different types of logs : 1) General Logs 2) Slow Query Logs 3) Error Logs You can enable these logs by modifying the DB Parameter Group. 1) Enable General Log [js] Parameter Name : general_log Value : set the value to 1. Default is 0. [/js] 2) Enable […]
MySQL and MongoDB are a very popular open-source databases these days. Through this blog, I wanted to share a use case of migrating MySQL database to MongoDB database and perhaps want to share few lessons during the migration process which would be helpful. There are three steps to the migration process: Suppose you have a user table […]
To import data from a MySQL database that is running external to Amazon RDS, you can configure replication from that database to a MySQL RDS instance. The external MySQL database you are importing from can be running either on-premises in your data center, or in an Amazon EC2 instance. The MySQL RDS instance must be […]
