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...
Tweaking MySQL Galera Cluster to Handle Large Databases – open_files_limit
Galera Cluster is a popular choice for achieving high availability using synchronous replication. Though if you are planning to run huge sites with many DB objects (tables), a few tweaks are necessary. Yes, you...
ClusterControl 1.2.8 Released
The Severalnines team is pleased to announce the release of ClusterControl 1.2.8. This release contains key new features along with performance improvements and bug fixes. We have outlined some of the key new features below. Highlights...
Webinar Replay: Performance Tuning of HAProxy for Database Load Balancing
Thanks to everyone who attended and participated in this week’s webinar on ‘Performance Tuning of HAProxy for Database Load Balancing’. And special thanks to our guest speaker, Baptiste Assmann of HAProxy Technologies. If you missed...
Puppet Module for ClusterControl – Adding Management and Monitoring to Your Existing Database Clusters
If you are automating your infrastructure using Puppet, then this blog is for you. We are glad to announce the availability of a Puppet module for ClusterControl. For those using Chef, we already published Chef cookbooks for...
Announcing ClusterControl Package Repository from Severalnines
We are excited to announce the availability of YUM/APT repositories for ClusterControl, making new releases of ClusterControl easily accessible using YUM or APT package managers. The repo is found at http://repo.severalnines.com, with instructions provided on the...
How to Change AWS Instance Sizes for Your Galera Cluster and Optimize Performance
Running your database cluster on AWS is a great way to adapt to changing workloads by adding/removing instances, or by scaling up/down each instance. At Severalnines, we talk much more about scale-out than scale up,...
How to Manage All Your MySQL or MariaDB Databases
According to Forrester, a DBA in a large enterprise manages between 8 and 275 databases, with the industry average being 40 databases to a DBA. Larger databases usually require extra effort around tuning, backup,...
9 Tips for Going in Production with Galera Cluster for MySQL
Are you going in production with Galera Cluster for MySQL? Here are 9 tips to consider before going live. These are applicable to all 3 Galera versions (Codership, Percona XtraDB Cluster and MariaDB Galera Cluster)....
How-To and Performance Impacts of SSL-Encrypted Replication Traffic in Galera Cluster for MySQL
Deploying Galera Clusters across WAN environments might lead to concerns around data privacy and security - especially as more organisations are having to comply with national and international regulations. You would not want hackers eavesdropping...
Announcing ClusterControl Support for MariaDB 10
We just wanted to make it official: Severalnines ClusterControl now supports MariaDB 10! As most of you know will know by now, MariaDB 10 is the newest and most advanced version of the popular MariaDB relational database...
Webinar Replay: How To Set Up SQL Load Balancing with HAProxy
Thanks to everyone who attended and participated in last week’s webinar on ‘How To Set Up SQL Load Balancing With HAProxy’! If you missed the sessions or would like to watch the webinar again &...
Big Data Integration & ETL – Moving Live Clickstream Data from MongoDB to Hadoop for Analytics
MongoDB is great at storing clickstream data, but using it to analyze millions of documents can be challenging. Hadoop provides a way of processing and analyzing data at large scale. Since it is a...