Types of Replication in SQL Server on Linux
SQL Server Replication enables you to copy and distribute database objects and data to multiple databases distributed across different locations. It allows you to select data or objects and only send the relevant data to...
Comparing SQL Server HA Solutions: Always On Availability Groups vs. Log Shipping
Information Technology is the cornerstone of all our businesses in the modern, technology-driven world we live in today. For databases that need to be continuously available to applications, it all comes down to Recovery Time...
High Availability Options for SQL Server Linux
Database high availability (HA) and disaster recovery (DR) are critical for any organization. There is essential work to be done to ensure that online services and applications always have access to data in order to...
Upgrading to PostgreSQL13
In a recent blog about what is new in PostgreSQL 13, we reviewed some of the new features of this version, but now, let’s see how to upgrade to be able to take advantage of...
PostgreSQL Replication Best Practices – Part 2
In the first part of this blog, we mentioned some important concepts related to a good PostgreSQL replication environment. Now, let’s see how to combine all these things together in an easy way using ClusterControl....
Dealing With MySQL Replication Issues Using ClusterControl
One of the most popular ways in achieving high availability for MySQL is replication. Replication has been around for many years, and became much more stable with the introduction of GTIDs. But even with these...
MySQL Replication Best Practices
MySQL Replication has been the most common and widely used solution for high availability by huge organizations such as Github, Twitter, and Facebook. Although easy to set up, there are challenges faced when using...
MongoDB Replication Best Practices
Production database systems often require high availability architectures. This is to ensure the availability of the data through redundancy across multiple instances. However, it is important to understand how to deploy and configure the database...
PostgreSQL Replication Best Practices – Part 1
Using replication for your PostgreSQL databases could be useful not only to have a high availability and fault tolerant environment but also to improve the performance on your system by balancing the traffic between the...
Creating a PostgreSQL Replication Setup on Debian / Ubuntu
PostgreSQL can work separately on multiple machines with the same data structure, making the persistence layer of the application more resilient and prepared for some unexpected event that might compromise the continuity of the service....
PostgreSQL Replication Setup & Maintenance Using Ansible
Replication is a key feature for most setups and it is supported by most database technologies on the market. The PostgreSQL community introduced replication in version 9.0 (called Streaming Replication or SR), since then the...
MySQL Replication with ProxySQL on WHM/cPanel Servers: Part Two
In the first part of the series, we showed you how to deploy a MySQL Replication setup with ProxySQL with WHM and cPanel. In this part, we are going to show some post-deployment operations for...