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...
Implementing Sovereign DBaaS using ClusterControl and Conductor – Part II
In part I of this blog series, we talked about what a Sovereign DBaaS is and how you can use a software orchestrator such as Netflix Conductor to realize a Sovereign DBaaS in real life....
How to use Cluster-to-Cluster Replication in a Galera Cluster
Previously, we announced a new ClusterControl 1.7.4 feature called Cluster-to-Cluster Replication. It automates the entire process of setting up a disaster recovery cluster off your primary cluster, with replication in between. With this feature: One...
Overview of SQL Server Requirements on Linux and Comparison with Windows SQL Server
In a previous article, Introduction to SQL Server on Linux, we learned about the SQL Server on Linux overview, features, performance, and high-availability concepts at a high level. Traditionally, SQL Server is a Windows-based relational...
Redis vs. Memcached From An Administration and Management Perspective
If you Google around, it is trivial to find the comparison between Redis versus Memcached as shown here, here, here and here. In this blog post, we will do a similar comparison between Redis and...
A Comparison Between ClusterControl and MongoDB OPS Manager
There are various ways to provision MongoDB servers, e.g., manual installation by command line, configuration management tools (eg. ansible, saltstack), or specialized MongoDB deployment tools such as ClusterControl and MongoDB Ops Manager. Manual installation will...
Most Popular NoSQL Databases Supported by ClusterControl
NoSQL ("not only SQL") is an approach to database design that enables the storage and querying of data outside the traditional structures found in relational databases. It was created to primarily deal with unstructured data...
How to Choose a Key-value Store
A key-value database is a type of non-relational database that uses a simple key-value method to store data. A key-value database stores data as a collection of key-value pairs in which a key serves as...
How to Configure PostgreSQL Sharding with ClusterControl
Sometimes it is hard to manage a large amount of data in a company, especially with the exponential increment of Data Analytics and IoT usage. Depending on the size, this amount of data could affect...
Running Vitess and MySQL with ClusterControl
For all who are not familiar with Vitess, it is a MySQL-based database system that is intended to deliver an easy-to-scale, sharded, relational database management system. We will not get into details about the design...
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...
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...