MySQL Replication Tutorial

1. Introduction to MySQL replication In a large scale enterprise system, data consistency and backup is of prime importance. It…

Read More »

Exact Matching of a String Containing a Wild Card in QueryDSL

On one of our recent projects, our client asked for a single search field that would be able to search…

Read More »

MySQL Command Line Tutorial

1. Introduction to MySQL In my previous tutorial, I discussed about installation of MySQL server and getting started with the…

Read More »

MySQL Server Tutorial

1. Introduction to MySQL Server MySQL is an open source relational database management system developed by a Swedish company in…

Read More »

MySQL Workbench Tutorial

1. About MySQL Workbench MySQL Workbench, as the name indicates, is a desktop tool to manage MySQL database servers and…

Read More »

Using MySQL JDBC Driver With Spring Boot

In this article, I will show you how to connect a MySQL database with your Spring Boot application. Tools used…

Read More »

MySQL Partition Pruning

Recently, we learned an expensive lesson about MySQL partition pruning. There, it is better to share it here so that…

Read More »

Scaling to 100M: MySQL is a Better NoSQL

MySQL is a better NoSQL. When considering a NoSQL use case, such as key/value storage, MySQL makes more sense in…

Read More »

End-to-End Automation for Docker-based 3-Tier Java Apps (Niginx, Tomcat and MySQL) on AWS

The geographical distribution & the continuously growing number of cloud services of Amazon Web Service has driven many startups &…

Read More »