Top Rated docs

May 1, 2023

Failover Modes for SQL Server cluster on Linux

In a previous article, we explored two different high-availability and disaster recovery solutions for SQL Server on Linux—log shipping and SQL Server Always On Availability Groups. If you’re using Availability Groups (AG), it’s essential to...

July 14, 2022

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...

July 12, 2022

How to set up Log Shipping as HA or DR solution for SQL Server on Linux

Log Shipping is a convenient disaster recovery method without complex infrastructure requirements. Log shipping allows you to sync a warm standby replica of your database with the Primary instance. It is available in the Enterprise,...

April 26, 2022

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...

April 11, 2022

When and How to Use Asynchronous Commit Mode for MS SQL Server Always On

The SQL Server Always On feature provides high availability (HA) and disaster recovery (DR) solutions for Windows and Linux-based SQL Server instances. Once you’ve defined the availability group, you can choose the required availability mode....

March 17, 2022

How to Set Up SQL Server Always On Availability Groups on Linux

High availability is a critical component of database operations – It protects companies from lost revenue when access to their data resources and critical business applications is disrupted. There are various high availability options available...

March 3, 2022

How to Deploy Teamcity with PostgreSQL for High Availability

TeamCity is a continuous integration and continuous delivery server built in Java. It's available as a cloud service and on-premises. As you can imagine, continuous integration and delivery tools are crucial to software development, and their availability...

July 12, 2021

Deploying MariaDB Sharding with Spider using ClusterControl

MariaDB offers built-in multi-host sharding capabilities with the Spider storage engine. Spider supports partitioning and XA transactions and allows remote tables of different MariaDB instances to be handled as if they were on the same...

July 9, 2021

Importance of Append-only File in Redis

While looking around Redis data directory you may have noticed several files, among them a file with .aof extension.  root@vagrant:~# ls -alh /var/lib/redis/ total 54M drwxr-x--- 2 redis redis 4.0K Jul 1 10:40 . drwxr-xr-x...

July 7, 2021

Hash Slot Resharding and Rebalancing for Redis Cluster

Redis Cluster with automatic partitioning uses a cool approach in organizing and storing the data, where the keys are stored in a hash slot and the keyspace is split into 16384 slots. Each master node...

June 21, 2021

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...

June 11, 2021

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...

Subscribe below to be notified of fresh posts