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...
Benchmarking databases 101 – part 2
In the previous blog post we have discussed a couple of best practices related to benchmarking. This time we would like to talk about the process itself. What can go wrong, what are the potential...
DBaaS In 2020 Onwards: Things Have Changed?
If you have been following events happening in the world closely, you have heard of COVID. And if you heard of COVID, you probably know how things have changed in the world. Everyone’s in lockdown,...
Need Performance Advice? Turn To ClusterControl!
If you frequently find yourself working with any kind of database, it’s natural that you might need some advice on how to deal with them at least once in a while. At present, you might...
MySQL Security with ClusterControl
If you are an experienced MySQL DBA, you probably already know how important MySQL security is. For you, security comes without any question - you already secured your database instances from the get-go: as soon...
The Common MySQL error: “Got an error reading communication packet”
MySQL is the second famous database in the world according to the DB Engine website behind Oracle. What makes MySQL famous is probably because it is a very fast, reliable and flexible Database Management System....
CCX for Technology Directors: What do You Need to Know?
Database-as-a-service solutions, at least as we know them, are shaking the market right now. However, before implementing one of such solutions into your company, you might wonder: why should I do it? What’s the benefit?...
Database as a Service Options in 2021: What’s Hot?
If you are a frequent reader of this blog, you probably know what database-as-a-service services are and how to best use them to achieve your database performance goals. Database-as-a-service options, as we have previously not...
Benchmarking databases 101 – part 1
Benchmarks are one of the activities that database administrators perform. You run them to see how your hardware behaves, you run them to see how your application and database work together under pressure. You run...
PostgreSQL and TimescaleDB backup restoration using ClusterControl CLI
Data is probably the most valuable asset in a company, so you need to make sure it is safe and can be restored in case of failure. Backups are the basic way to keep it...
Database-as-a-Service (DBaaS) Solutions for Back-end Developers
Back-end developers usually focus on the “deeper” end of an application: while front-end developers focus on design, layouts, and the like, back-end developers are focused on the functionality that is mostly invisible to the end-user,...
Overview of Your Services: DBaaS vs. Manual Approach
If you are a developer or a database administrator, chances are that you need to take care of your databases at least on-and-off. The things related to your databases that need to be taken care...
Redis vs DynamoDB (a comparison)
What is Redis? Redis (which means Remote Dictionary Serve) is an open-source NoSQL database known to be a fast, in-memory key-value data store, cache, message broker, and queue. The project started by Salvatore 'antirez' Sanfilippo,...