If you are using Galera Cluster in multi-master mode, you will most likely run into transaction conflicts if two clients attempt to modify the same row at the same time. Such conflicts are reported a deadlock errors to the application. Legacy applications are frequently unable to handle transaction conflicts properly and may not provide sufficient […]

Some applications, particularly those written with a single-node database server in mind, attempt to immediately read a value they have just inserted into the database, without making those those operations part of a single transaction. A read/write splitting proxy or a connection pool combined with a load-balancer can direct each operation to a different database […]

Introduction The Galera Cluster Juju Charm was recently released, and it is now possible to start scalable Galera Clusters using the Juju deployment framework on the public or private cloud (OpenStack, Amazon, Azure and bare metal are all supported). All the logic required to fire up Galera is encapsulated in the Charm, which is a […]

By Erkan Yanar In the previous article of this series, we described how to run a multi-node Galera Cluster on a single Docker host. In this article, we will describe how to deploy Galera Cluster over multiple Docker hosts. By design, Docker containers are reachable using port-forwarded TCP ports only, even if the containers have […]

by Erkan Yanar Docker is an open platform for developers and sysadmins to build, ship, and run distributed applications. Consisting of Docker Engine, a portable, lightweight runtime and packaging tool, and Docker Hub, a cloud service for sharing applications and automating workflows, Docker enables apps to be quickly assembled from components and eliminates the friction […]