Elasticsearch Ability To Scale We scale database clusters for many reasons; primarily, we do so to spread the load amongst the cluster peers. Scaling can be done up or out. Scaling up is what is commonly also known as vertical scaling. This approach is where you add more hardware resources such as CPU, RAM, or disk to your existing hardware — either a physical or virtual machine. Scaling out, also known as horizontal scaling, is where you add more database nodes, such as shards, replicas, or pods, to spread out the load by passing it to a newer node. Certain specifications and skills are requi ..read more

We’re pleased to announce that ClusterControl (CC) now integrates with the widely-used Infrastructure as Code (IaC) tool – Terraform. With our Terraform Provider, users can build provisioning workflows into the deployment sequences of their ClusterControl-managed databases. For DevOps teams using ClusterControl and Terraform, this will further reduce the daily operational load and complexity by helping to streamline processes. Terraform users gain several advantages, including: Faster deployment: Automate the provisioning of database clusters across public and private clouds tied to your appl ..read more

PostgreSQL releases major versions relatively often, about once a year. This is because the PostgreSQL Global Development Group (PGDG) is committed to providing new features and improvements to the database on a regular basis. Of course, there are some drawbacks to releasing major versions so often. One is that it can be difficult for users to keep up with the latest changes. Another is that it can be more challenging to upgrade to a new major version, as the internal data storage format may change. However, the benefits of releasing major versions often outweigh the drawbacks. By releasing n ..read more

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 of the data. These vectors are generated by applying an embedding function to the raw data, such as text, images, audio, video, etc. The embedding function can be machine learning models, feature extraction algorithms, etc. We all know PostgreSQL as a relational database for transactional workloads. But, at the same time, with the pgv ..read more

We’re thrilled to announce that ClusterControl (CC) version 1.9.8 is now available! This latest release brings a range of exciting features to ClusterControl users, including an in-place major version upgrade for PostgreSQL, the addition of the pgvector extension, and a minor version upgrade for MongoDB users. Let’s dive into the details to help you get up and running with these latest enhancements. Update your PostgreSQL server to the latest version in-place An in-place PostgreSQL major upgrade involves upgrading your current PostgreSQL instance to a newer major version directly on the same s ..read more

Elasticsearch failover – what is it? Why did it happen? Why would you bother? Failover is a common situation in a database world. Some failovers are planned upfront, tested in detail and executed by following a detailed runbook. Other failovers may happen in your Elasticsearch cluster out of the blue, catching you by surprise. Why is it important to configure your Elasticsearch database to be able to run automated failovers? Let’s do a dive into the world of Elasticsearch failover by starting with what it really means and what are the common causes that may trigger a failover. Common causes of ..read more

Improving on its predecessor, MariaDB 10.6, MariaDB 10.11 is the latest long-term stable series. It was released in February 2023 with ClusterControl support introduced in August of the same year. So what’s new? We’ll take a look at updates in 5 key areas: security, the InnoDB engine, temporal tables, general performance optimizations, and system variables. 3 key MariaDB 10.11 security updates Addition of PUBLIC pseudo-role The PUBLIC pseudo-role allows the following SQL statements to be implemented: GRANT TO PUBLIC – Grants some privileges to all users. REVOKE FROM PUBLIC – Revokes privilege ..read more

Data privacy and security are not new themes for businesses, especially those that take advantage of cloud-based solutions. However, as data privacy concerns continue to rise, many countries (and some states) are clamping down on how and where consumer data can be collected and stored. If you’re operating across borders, the term ‘data sovereignty’ is likely on your radar. If not, now’s the time to reevaluate your privacy and security practices for collecting, storing, and managing consumer data across the countries where you do business. In this post, we will discuss the concept of data sover ..read more

Nowadays, cloud computing has become an integral part of many companies. It offers flexibility, scalability, and cost-effectiveness. However, despite the numerous benefits, it is crucial for businesses to have a cloud exit strategy in place. This strategy ensures a smooth transition from the cloud environment to another provider or even to an on-prem infrastructure if circumstances demand it. In this blog post, we will explore the significance of a cloud exit strategy and how to plan one. What is a cloud exit strategy? A cloud exit strategy is a set of actions put in place by an organization t ..read more

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 types, replication to and from Azure, and more. You will find full support for the release in ClusterControl, as of version 1.9.7. Here, we will highlight the new features, functionalities, and improvements introduced in SQL Server 2022 that add value for anyone interested in using this particular version. Let’s dive in. New features and functionalities in SQL Server 2022 SQL Se ..read more