Vector Similarity Search with PostgreSQL’s pgvector – A Deep Dive
Severalnines | Open Source Database Blog & News
by Divine Odazie
1w 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
Visit website
ClusterControl adds in-place major PostgreSQL upgrade and pgvector extension in latest release
Severalnines | Open Source Database Blog & News
by Dean Maree
2w 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
Visit website
The what, why, and how of Elasticsearch failover
Severalnines | Open Source Database Blog & News
by Krzysztof Ksiazek
2w 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
Visit website
The most noteworthy improvements in MariaDB 10.11
Severalnines | Open Source Database Blog & News
by Duncan Mwangi
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
Visit website
What is Data Sovereignty & how to achieve it
Severalnines | Open Source Database Blog & News
by John Demian
2M 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
Visit website
Importance of a cloud exit strategy and how to plan one
Severalnines | Open Source Database Blog & News
by Sebastian Insausti
3M 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
Visit website
What’s new in SQL Server 2022
Severalnines | Open Source Database Blog & News
by Rajendra Gupta
3M 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
Visit website
3 principles of Sovereign DBaaS and how ClusterControl supports them
Severalnines | Open Source Database Blog & News
by Krzysztof Ksiazek
4M ago
In today’s era, where decision making has to be rapid and data-driven, the data that your business aggregates is increasingly critical. And as more and more regulation is passed, data sovereignty is now a significant area to address. The concept of data sovereignty is important to incorporate into any organization’s data architecture design. Concerns over data privacy, regulatory requirements, and the ever increasing threats of cybercrime means you need to properly safeguard your data. However, development speed is also considered essential to gain, or maintain, a competitive advantage. This ..read more
Visit website
What’s new in MongoDB 6
Severalnines | Open Source Database Blog & News
by Zamani Rahman
5M ago
MongoDB 6.0 is a major release by MongoDB launched in July 2022. In the release, MongoDB introduced a bunch of new features and improvements aimed at removing complexity – so that users don’t have to troubleshoot as often, and can ultimately build at a faster pace. You will find full support for the release in ClusterControl, as of version 1.9.7. Here, we will highlight seven new features in MongoDB 6.0 that add value for anyone using this particular database flavor. Let’s dive in. 1. Extra support for time series data Time series data is used across diverse industries, including finance, IoT ..read more
Visit website
Best Practices for Scaling A Multi-Cloud Database Infrastructure
Severalnines | Open Source Database Blog & News
by Ashraf Sharif
6M ago
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 cloud providers to achieve better performance, flexibility, and cost savings.  However, scaling a multi-cloud database infrastructure requires careful planning, execution, and monitoring to ensure optimal resource utilization, data privacy, and security.  Before you get started, it’s important to understand the mai ..read more
Visit website

Follow Severalnines | Open Source Database Blog & News on FeedSpot

Continue with Google
Continue with Apple
OR