Announcing ClusterControl 1.7.4: Cluster-to-Cluster Replication – Ultimate Disaster Recovery
We’re excited to announce the 1.7.4 release of ClusterControl - the only database management system you’ll ever need to take control of your open source database infrastructure. In this release we launch a new function...
Building a Hot Standby on Amazon AWS Using MariaDB Cluster
Galera Cluster 4.0 was first released as part of the MariaDB 10.4 and there are a lot of significant improvements in this version release. The most impressive feature in this release is the Streaming Replication...
Deploying a Highly Available Nextcloud with MySQL Galera Cluster and GlusterFS
Nextcloud is an open source file sync and share application that offers free, secure, and easily accessible cloud file storage, as well as a number of tools that extend its feature set. It's very similar...
A Guide to MySQL Galera Cluster Streaming Replication: Part Two
In the first part of this blog we provided an overview of the new Streaming Replication feature in MySQL Galera Cluster. In this blog we will show you how to enable it and take a...
A Guide to MySQL Galera Cluster Streaming Replication: Part One
Streaming Replication is a new feature which was introduced with the 4.0 release of Galera Cluster. Galera uses replication synchronously across the entire cluster, but before this release write-sets greater than 2GB were not supported....
Deploying MySQL Galera Cluster 4.0 onto Amazon AWS EC2
Galera Cluster is one of the most popular high availability solutions for MySQL. It is a virtually synchronous cluster, which helps to keep the replication lag under control. Thanks to the flow control, Galera cluster...
Using MySQL Galera Cluster Replication to Create a Geo-Distributed Cluster: Part Two
In the previous blog in the series we discussed the pros and cons of using Galera Cluster to create geo-distributed cluster. In this post we will design a Galera-based geo-distributed cluster and we will show...
Using MySQL Galera Cluster Replication to Create a Geo-Distributed Cluster: Part One
It is quite common to see databases distributed across multiple geographical locations. One scenario for doing this type of setup is for disaster recovery, where your standby data center is located in a separate location...
How to Create a Clone of Your MySQL or PostgreSQL Database Cluster
If you are managing a production database, chances are high that you’ve had to clone your database to a different server other than the production server. The basic method of creating a clone is to...
What’s New in MySQL Galera Cluster 4.0
MySQL Galera Cluster 4.0 is the new kid on the database block with very interesting new features. Currently it is available only as a part of MariaDB 10.4 but in the future it will work...
How to Troubleshoot MySQL Database Issues
As soon as you start running a database server and your usage grows, you are exposed to many types of technical problems, performance degradation, and database malfunctions. Each of these could lead to much bigger...
Database Switchover and Failover for Drupal Websites Using MySQL or PostgreSQL
Drupal is a Content Management System (CMS) designed to create everything from tiny to large corporate websites. Over 1,000,000 websites run on Drupal and it is used to make many of the websites and applications...