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...
Upgrading to PostgreSQL13
In a recent blog about what is new in PostgreSQL 13, we reviewed some of the new features of this version, but now, let’s see how to upgrade to be able to take advantage of...
Database as a Service Concepts: Load Balancing
Load balancing is a very important concept in the world of cloud solutions. Load balancing is especially important when using or choosing to use a Database as a Service (DBaaS) provider - in this blog...
Performance Tuning for Redis
In any database setup, performance is always a challenge and is most of the time database administrators and developers always deals with especially for a production and large environment. It's worth noting that a simple...
Database as a Service Concepts: High Availability
High availability is one of the most important aspects when choosing a cloud service provider. High availability is especially important when choosing a Database as a Service (DBaaS) provider in the sea of DBaaS providers....
Digging Deeper into ClusterControl’s Performance Advisors
If you are a frequent reader of the Severalnines’ database blog, you have probably noticed that Severalnines’ crew talks about performance of databases pretty frequently. Part of that is because of ClusterControl - the flagship...
ACL using s9s CLI
Starting with ClusterControl 1.8.2, we have introduced new user management, permissions as well as access controls. From this version onwards, all of the features we mentioned earlier will be controlled by a set of Access...
ClusterControl – Advanced Backup Management – mariabackup Part II
In the previous part we have tested backup time and effectiveness of the compression for different backup compression levels and methods. In this blog we will continue our efforts and we will talk about more...
Choosing a DBaaS: What to Consider?
As already previously mentioned, Database-as-a-Service (DBaaS) solutions refers to such software that enables users to perform administrative tasks on their database without needing to setup or configure software or hardware allowing you to streamline your...
ClusterControl runtime configuration options
When you install ClusterControl, it has a default configuration that maybe doesn’t fit your requirements so probably you will need to customize this installation. For this, you can modify the configuration files, but you can...
ClusterControl – Advanced Backup Management – mariabackup Part I
ClusterControl can, among others, act as a great tool to help you design and execute the backup schedule. Numerous features are available including backup verification, transparent backup encryption and many others. What is quite commonly...
Performance Monitoring of Redis
Just like any database activity, monitoring is a constant practice to make sure an optimal performance of databases is always assured and guaranteed to the limit that it is expected to provide. Redis is not...
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...