Exploring Synchronous Commit Mode for SQL Server Always On
SQL Server Always On is a database availability solution that provides automated database replication and failover across standalone servers and SQL Server instances. It allows database administrators and developers to build solutions that guarantee database...
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...
Installing Redis Cluster (cluster mode enabled) with auto failover
Redis is an open-source in-memory datastore used as a database or cache. It has built-in replication and provides high availability via Redis Sentinel and automatic partitioning with Redis Cluster. In this blog, we will see...
Redis High Availability Architecture with Sentinel
Redis Sentinel is a dedicated process to automate and simplify the Redis replication failover and switchover. Without Sentinel, you could also manage your Redis replication manually, by using the SLAVEOF or REPLICAOF command. Sentinel requires...
CMON High Availability and Failover
High availability is a must these days and ClusterControl performs a key role in ensuring that your database clusters will stay up and running. On the other hand, how can we ensure that ClusterControl itself...
Automatic Failover of the Moodle PostgreSQL Database
One of the key aspects of high availability is the ability to quickly react to failures. It is not uncommon to manually manage databases, and have monitoring software keep an eye on database health. In...
How to Automatically Manage Failover of the MySQL Database for Moodle
In our previous blogs, we made justification for why you need a database failover and have explained how a failover mechanism works. I’m sharing this in case you have questions on why you should set...
Asynchronous Replication Automatic Failover in MySQL 8.0.22
Oracle recently released MySQL 8.0.22, and this new version came with a new asynchronous connection failover mechanism. It allows a replica to automatically establish an asynchronous replication connection to a new source, in case...
Multi-Cloud Full Database Cluster Failover Options for PostgreSQL
Failover is the ability of a system to continue working even if some failure occurs. It suggests that the functions of the system are assumed by secondary components if the primary components fail or if...
Multi-Cloud Full Database Cluster Failover Options for MariaDB Cluster
High availability is paramount in today's business reality. But every service provider comes with an inherited risk of disruption -- and cloud service providers are no different. If they go down, even temporarily, then so...
Tips for Managing PostgreSQL Remotely
A wide range of resources are available for you when managing your PostgreSQL database clusters remotely. With the right tools managing it remotely is not a difficult task. Using fully-managed services for PostgreSQL offers an...