Home » Tag Archives: MySQL

Tag Archives: MySQL

Scaling to 100M: MySQL is a Better NoSQL

software-development-2-logo

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

Read More »

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

devops-logo

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

Read More »

Docker 3-Tier Java App (Nginx, Tomcat, MySQL) Automation on Any Cloud

devops-logo

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

Read More »

How does the MySQL JDBC driver handle prepared statements

mysql-logo

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

Read More »

Benchmarking Aurora vs MySQL: Is Amazon’s New DB Really 5x Faster?

mysql-logo

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

Read More »

MySQL Is a Great NoSQL

mysql-logo

NoSQL is a set of database technologies built to handle massive amounts of data or specific data structures foreign to relational databases. However, the choice to use a NoSQL database is often based on hype, or a wrong assumption that relational databases cannot perform as well as a NoSQL database. Operational cost is often overlooked by engineers when it comes ...

Read More »

Mysql versions prior to 5.7 do not fully support two phase commit

mysql-logo

While doing some tests for the recently released generic JCA adapter which is capable of binding remote calls to microservices (as well as other things) into JTA transactions, I discovered a bug in Mysql 5.6 which has been around for nearly ten years. The test scenario was a crash after the “prepare” phase of the XA transaction, after both the ...

Read More »

MySQL vs. MongoDB: Choosing a Data Management Solution

software-development-2-logo

Table Of Contents 1. Introduction 2. The dominance of RDBM systems 3. A new era of NoSQL movement 4. Tables vs Documents vs Graphs vs Key/Values 5. MySQL and MongoDB: Conscious Decision 5.1. Enforced Schema vs Schemaless 5.2. Normalization vs Duplication 5.3. Relations vs References 5.4. Transactions vs Atomic Updates 5.5. SQL vs JSON 5.6. Stored Procedures vs Scripting 5.7. ...

Read More »

Docker MySQL Persistence

docker-logo

One of the recipes in 9 Docker recipes for Java developers  is using MySQL container with WildFly. Docker containers are ephemeral, and so any state stored in them is gone after they are terminated and removed. So even though MySQL container can be used as explained in the recipe, DDL/DML commands can be used to persist data, but that state is lost, or at least not ...

Read More »

MySQL as Kubernetes Service, Access from WildFly Pod

jboss-wildfly-logo

Java EE 7 and WildFly on Kubernetes using Vagrant (Tech Tip #71) explained how to run a trivial Java EE 7 application on WildFly hosted using Kubernetes and Docker. The Java EE 7 application was the hands-on lab that have been delivered around the world. It uses an in-memory database that is bundled with WildFly and allows to understand the ...

Read More »

Want to take your Java skills to the next level?

Grab our programming books for FREE!

Here are some of the eBooks you will get:

  • Advanced Java Guide
  • Java Design Patterns
  • JMeter Tutorial
  • Java 8 Features Tutorial
  • JUnit Tutorial
  • JSF Programming Cookbook
  • Java Concurrency Essentials