Converting from Asynchronous to Synchronous Replication in PostgreSQL
High Availability is a requirement for just about every company around the world using PostgreSQL It is well known that PostgreSQL uses Streaming Replication as the replication method. PostgreSQL Streaming Replication is asynchronous by default,...
Database Load Balancing in the Cloud – MySQL Master Failover with ProxySQL 2.0: Part Two (Seamless Failover)
In the previous blog we showed you how to set up an environment in Amazon AWS EC2 that consists of a Percona Server 8.0 Replication Cluster (in Master - Slave topology). We deployed ProxySQL and...
Tips for Migrating from MySQL Replication to MySQL Galera Cluster 4.0
We have previously blogged about What’s New in MySQL Galera Cluster 4.0, Handling Large Transactions with Streaming Replication and MariaDB 10.4 and presented some guides about using the new Streaming Replication feature in a part...
How to Configure Cluster-to-Cluster Replication for PostgreSQL
As we recently announced, ClusterControl 1.7.4 has a new feature called Cluster-to-Cluster Replication. It allows you to have a replication running between two autonomous clusters. For more detailed information please refer to the above mentioned...
Avoiding Database Vendor Lock-In for MySQL or MariaDB
Vendor lock-in is defined as "Proprietary lock-in or customer lock-in, which makes a customer dependent on a vendor for their products and services; unable to use another vendor without substantial cost" (wikipedia). Undeniably for many...
9 ClusterControl Features You Won't Find in Other Database Management Tools
Ensuring smooth operations of your production databases is not a trivial task, and there are a number of tools and utilities to help with the job. There are tools available for monitoring health, server performance,...
How to Configure a Cluster-to-Cluster Replication for Percona XtraDB Cluster or MariaDB Cluster
In a previous blog, we announced a new ClusterControl 1.7.4 feature called Cluster-to-Cluster Replication. It automates the entire process of setting up a DR cluster off your primary cluster, with replication in between. For more...
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...
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...