MySQL InnoDB Cluster 8.0 – A Complete Deployment Walk-Through: Part One
MySQL InnoDB Cluster consists of 3 components: MySQL Group Replication (a group of database server which replicates to each other with fault tolerance). MySQL Router (query router to the healthy database nodes) MySQL Shell (helper,...
An Overview of Cluster-to-Cluster Replication
Nowadays, it’s pretty common to have a database replicated in another server/datacenter, and it’s also a must in some cases. There are different reasons to replicate your databases to a totally separate environment. Migrate to...
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...
Tips for Migrating from Proprietary to Open Source Databases
Back in the day proprietary databases were the only acceptable options. “No one ever got fired for buying from Oracle/Microsoft/IBM” was the saying. Huge, monolithic databases used for every single purpose. Paid support - that’s how...
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...
Database Load Balancing in the Cloud – MySQL Master Failover with ProxySQL 2.0: Part One (Deployment)
The cloud provides very flexible environments to work with. You can easily scale it up and down by adding or removing nodes. If there’s a need, you can easily create a clone of your environment....
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....
MySQL Cloud Backup and Restore Scenarios Using Microsoft Azure
Backups are a very important part of your database operations, as your business must be secured when catastrophe strikes. When that time comes (and it will), your Recovery Point Objective (RPO) and Recovery Time Objective...
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...