Tag Archives: MySQL

1. Introduction to MySQL Server MySQL is an open source relational database management system developed by a Swedish company in 1995. MySQL being an open source system, it has been used by numerous famous companies like Facebook, Google, Twitter, Flickr as well as Youtube. MySQL server is also a central component in LAMP, an open source web application framework. MySQL ...

1. About MySQL Workbench MySQL Workbench, as the name indicates, is a desktop tool to manage MySQL database servers and the databases too. MySQL Workbench comes integrated with a whole bunch of tools to help make the task of working with the database easier. It is mainly a visual database design tool that integrates variety of facilities as listed below: ...

In this article, I will show you how to connect a MySQL database with your Spring Boot application. Tools used in this article include: Spring Boot 1.5.6 Release MySQL 5.7.X Maven Java 8 Spring Data JPA 1 – Project Structure The project structure is a typical Maven structure. 2 – Project Dependencies Please note that the parent needs to declared. ...

Recently, we learned an expensive lesson about MySQL partition pruning. There, it is better to share it here so that others will not repeat our mistake. Background In our system, there is a big stats table that does not have primary key and indexes. This table is partitioned, but the lack of indexes often causes the full partition or even ...

MySQL is a better NoSQL. When considering a NoSQL use case, such as key/value storage, MySQL makes more sense in terms of performance, ease of use, and stability. MySQL is a solid engine with lots of online material, ranging from operations and failure cases, to replication and different patterns of usage. For this reason, it has an advantage over newer ...

The geographical distribution & the continuously growing number of cloud services of Amazon Web Service has driven many startups & enterprises to host their applications on Amazon Instances distributed across different regions. However as development teams start to grow or as enterprises embark on new development projects, replicating consistent DEV/TEST environments for the quickly growing teams becomes a struggle on ...

DCHQ simplifies the containerization of enterprise applications and makes it possible to replicate very complex application environments on multiple hosts through a one-click deploy button. DCHQ does not just automate the application deployments, but it also integrates with 12 different cloud providers to automate the provisioning and auto-scaling of Weave-enabled clusters consisting of distributed virtual machines. In this blog, we ...

Prepared statement types While researching for the Statement Caching chapter in my High-Performance Java Persistence book, I got the chance to compare how Oracle, SQL Server, PostgreSQL and MySQL handle prepare statements. Thanks to Jess Balint (MySQL JDBC driver contributor), who gave a wonderful answer on StackOverflow, I managed to get a better understanding of how MySQL handles prepared statements ...

Amazon Aurora: The next generation of hosted database services put to the test In this post we’re taking a closer look at Amazon Aurora to see how it fares against MySQL and if it delivers on the promise of a 5x performance boost. Recently reaching general availability, Aurora is Amazon’s home grown MySQL compatible database. Currently available on three AWS regions ...