Improving LLM Fidelity with Retrieval Augmented Generation using pgvector
Large language models (LLMs) have taken the world by storm, wowing us with their ability to generate remarkably human-like text. But for all their prowess, these AI marvels still face major roadblocks – especially when...
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...
High Availability Galera Clusters for Indonesia’s leading eCommerce Payment Gateway
Indonesia, the fourth most populous country in the world, is emerging as an economic powerhouse in Asia Pacific. With 60% of a population of 250 million being under 30 years of age, growing internet penetration...
Deep Dive SQL Workload Analysis using pt-query-digest
In our previous post, we showed you how to interpret reports generated by pt-query-digest. Today we’d like to cover some of its more advanced features, as it is a pretty extensive tool with lots of...
ClusterControl Enables MySQL HA for the European Broadcasting Union and Its 200 Million Viewers
The home of Eurovision and Euroradio choses Severalnines to tune its MySQL databases Stockholm, Sweden and anywhere else in the world – Severalnines, the provider of database infrastructure management software, recently announced its latest customer,...
Webinar Replay: Schema Changes for MySQL Replication & Galera Cluster
Thanks to everyone who joined us for our recent live webinar on ‘Schema Changes for MySQL Replication & Galera Cluster’ led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the...
Analyzing Your SQL Workload Using pt-query-digest
In our previous post, we discussed the different ways to collect data about slow queries - MySQL offers slow log, general log and binary log. Using tcpdump, you can grab network traffic data - a...
How to Preform an Online Upgrade of MariaDB Galera Cluster 5.5 to MariaDB 10
The MariaDB team released a GA version of MariaDB Galera Cluster 10 in June 2014. MariaDB 10 is the equivalent of MySQL 5.6, and therefore, packed with lots of great features. In this blog post,...
How to Perform an Online Upgrade of Galera Cluster to MySQL 5.6
Oracle released a GA version of MySQL 5.6 in February 2013, Codership released the first GA in their patched 5.6 series in November 2013. Galera Cluster for MySQL 5.6 has been around for almost 2...
Understanding the MySQL Query Tuning Process
Query tuning is something that a DBA does on a daily basis - analyse queries and updates, how these interact with the data and schema, and optimize for performance. This is an extremely important task...
MySQL Configuration: Tuning for Performance
A database server needs CPU, memory, disk and network in order to function. Understanding these resources is important for a DBA, as any resource that is weak or overloaded can become a limiting factor and...
Architecting for Failure – Disaster Recovery of MySQL Galera Cluster
Failure is a fact of life, and cannot be avoided. No IT vendor in their right mind will claim 100% system availability, although some might claim several nines :-) We might have armies of ops...
Webinar Replay: Designing for High Availability for MySQL
Thanks to everyone who joined us yesterday for this live session on designing HA for MySQL led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the webinar are now available...
An Overview of MySQL Database Upgrades
Database vendors typically release patches with bug/security fixes on a monthly basis, why should we care? The news is full of reports of security breaches and hacked systems, so unless security is not a concern,...