Severalnines | Open Source Database Blog & News
1,944 FOLLOWERS
Severalnines provides open-source database automation & management systems for highly available MySQL, MongoDB, and PostgreSQL database environments. On the blog, We share news and how-to's to get the most out of your open source database deployments. Whether you are working with MySQL-based technologies like MySQL Replication, MariaDB, NDB Cluster, or Galera Cluster we've got you covered.
Severalnines | Open Source Database Blog & News
2w ago
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
Severalnines | Open Source Database Blog & News
2w ago
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
Severalnines | Open Source Database Blog & News
3w ago
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
Severalnines | Open Source Database Blog & News
1M ago
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
Severalnines | Open Source Database Blog & News
1M ago
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
Severalnines | Open Source Database Blog & News
1M ago
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
Severalnines | Open Source Database Blog & News
1M ago
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
Severalnines | Open Source Database Blog & News
3M ago
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
Severalnines | Open Source Database Blog & News
4M ago
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
Severalnines | Open Source Database Blog & News
4M ago
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