March 20, 2024

Vector Similarity Search with PostgreSQL’s pgvector – A Deep Dive

As the AI revolution surges forward, promising significant innovations, it also introduced new types of vector databases. A vector database stores data as high-dimensional vectors called embeddings, which are mathematical representations of features or attributes...

August 16, 2023

10 Considerations for Architecting a Multi-Cloud Database

Thinking about architecting a multi-cloud database? It’s an increasingly common topology nowadays. The adoption rate of a multi-cloud approach has been growing fast for years. It’s a solid option for a disaster recovery plan (DRP)...

October 6, 2023

Best Practices for Scaling A Multi-Cloud Database Infrastructure

Scaling a multi-cloud database infrastructure can be a complex and challenging task, but it's essential for businesses that require high scalability, availability, and reliability. With multi-cloud becoming increasingly popular, organizations are leveraging the benefits of...

December 8, 2023

What’s new in SQL Server 2022

SQL Server 2022 is the latest database version released by Microsoft in November 2022. The release builds upon previous versions to add more choice for SQL Server users when it comes to development languages, data...

Categories
Products
Technologies
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