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