Grails, Java

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

by Sachin Gulati
Tag: MySql

AWS, DevOps

Database Migration using AWS Database Migration Service (DMS)

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 database may be in same VPC or in...

by Shivam Agrawal
Tag: MySql

AWS, DevOps

AWS RDS Aurora Replication with Mysql

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 the migration was completed I came...

by Rajdeep Singh
Tag: MySql

Grails, Technology

One step ahead in mysql search: full-text search

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

by Sanchit
Tag: MySql


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: MySql


Building MySql Database Test Plan Using Jmeter

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

by Prashant Sharma
Tag: MySql


log_output TABLE vs FILE inside Amazon RDS

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 Slowquery Log [js] ...

by Vikash Jha
Tag: MySql


MySQL to MongoDB Migration

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

by Deepak Kumar Mittal
Tag: MySql


Migrate from External MySQL to AWS RDS

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 running either MySQL...

by Tejprakash Sharma
Tag: MySql


NodeJs with MySql using Sequelize

This time I am going to explain a very basic CRUD operation on MySql database via NodeJs using Sequelize. Here Sequelize become's a bridge between NodeJs and MySql database, it is a Object Relational Mapping Library written on javascript. Let us quickly learn the things with the help of Examples and we will use Item Table to perform...

by Kashish Gupta
Tag: MySql

AWS, Grails

Change MySQL Timezone on Amazon RDS

Amazon RDS doesn't allow you to change timezone, It keeps same UTC time zone across all regions. time_zone variable in the parameter group is read only.You can change the time zone on each connection or session by making a procedure in default mysql database and call this function on each init connection.1.    Create a procedure for...

by Tejprakash Sharma
Tag: MySql


Show status of MySQL imports using PipeViewer

While working on my current application, I had to import a large database using mysql from a sql dump. The size of the sql dump was around 1.5 GB and hence the import was taking long time. I just felt the need of some tool that could help me check the progress of the import. The command I used was: [sql] mysql --user=username...

by Nikhil Bhandari
Tag: MySql