Load Balanced MySQL Galera Setup: Manual Deployment vs ClusterControl
If you have deployed databases with high availability before, you will know that a deployment does not always go your way, even though you’ve done it a zillion times. You could spend a full day...
MongoDB Features – Sharded Deployments, Cluster-Consistent Backups, Advisors in ClusterControl 1.3.2 Release
The Severalnines team is pleased to announce the release of ClusterControl 1.3.2. This release contains new features, such as deploying MongoDB sharded clusters and scheduling cluster-consistent backups, MongoDB Advisors, a new alarm viewer and new...
How to Set up Read-Write Split in Galera Cluster Using ProxySQL
Edited on Sep 12, 2016 to correct the description of how ProxySQL handles session variables. Many thanks to Francisco Miguel for pointing this out. ProxySQL is becoming more and more popular as SQL-aware load balancer...
Introduction to Docker Swarm Mode and Multi-Host Networking
In the previous blog post, we looked into Docker’s single-host networking for MySQL containers. This time, we are going to look into the basics of multi-host networking and Docker swarm mode, a built-in orchestration...
Infrastructure Automation – Deploying ClusterControl and MySQL-Based Systems on AWS using Ansible
We recently made a number of enhancements to the ClusterControl Ansible Role, so it now also supports automatic deployment of MySQL-based systems (MySQL Replication, Galera Cluster, NDB Cluster). The updated role uses the awesome ClusterControl...
Adding Existing Databases and Clusters (Updated)
In our previous blog post we covered the deployment of four types of clustering/replication: MySQL Galera, MySQL master-slave replication, PostgreSQL replication set and MongoDB replication set. This should enable you to create new clusters with...
Single Host Networking for MySQL Containers on Docker
Networking is critical in MySQL, it is a fundamental resource to manage access to the server from client applications and other replication peers. The behaviour of a containerized MySQL service is determined by how the...
How to Setup Streaming Replication for High Availability with PostgresSQL 9.0
Master - slave replication PostgreSQL historically did not have support for replication - replication was provided using external tools like Pgpool and Slony. Since these solutions did not come out of the box, most of...
MySQL on Docker: Building the Container Image
Building a docker image for MySQL is essential if you’d like to customize MySQL to suit your needs. The image can then be used to quickly start running MySQL containers, which can be operated...
MySQL Docker Containers: Understanding the Basics
Docker is quickly becoming mainstream, as a method to package and deploy self-sufficient applications in primarily stateless Linux containers. But for a stateful service like a database, this might be bit of a headache. How...
PostgreSQL Provisioning and Deployment
MySQL and PostgreSQL - two open source relational database management systems, each with their own set of fans. For years, MySQL has been a source of fun and amusement in the PostgreSQL community - default,...
MySQL Slave Promotion With and Without Using GTID
MySQL Replication can be fragile: whenever it encounters a connectivity error, it will retry and if it is a serious error, it will simply stop. Obviously in the latter case, you will need to repair...