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...
Advanced Failover Using Post/pre Script Hooks
The Importance of Failover Failover is one of the most important database practices for database governance. It’s useful not only when managing large databases in production, but also if you want to be sure that...
Dealing With MySQL Replication Issues Using ClusterControl
One of the most popular ways in achieving high availability for MySQL is replication. Replication has been around for many years, and became much more stable with the introduction of GTIDs. But even with these...
MySQL Replication Best Practices
MySQL Replication has been the most common and widely used solution for high availability by huge organizations such as Github, Twitter, and Facebook. Although easy to set up, there are challenges faced when using...
Keeping Databases Up and Running in an Outage or Slowdown
Once you see that your database environment has issues, you are in trouble. Maybe one of your replicas is out or maybe you are experiencing a significant increase in the load across your databases that...
MongoDB Replication Best Practices
Production database systems often require high availability architectures. This is to ensure the availability of the data through redundancy across multiple instances. However, it is important to understand how to deploy and configure the database...
PostgreSQL Replication Best Practices – Part 1
Using replication for your PostgreSQL databases could be useful not only to have a high availability and fault tolerant environment but also to improve the performance on your system by balancing the traffic between the...
Managing Multiple Database Technologies with ClusterControl
Managing multiple open source database technologies in any environment can be a daunting task, especially if you have fewer resources. The scenario could be worse if deployment, monitoring, and other database management tasks are done manually....
Using PgBouncer Connection Pooler for PostgreSQL with ClusterControl 1.8.2
Modern apps like microservices typically require a lot of database connections, they also use and release those connections very quickly. When PostgreSQL was developed almost 25 years ago, its developers decided not to use threads...
How to Measure Database Performance
Running production environments, you may be wondering how your database is performing? Does it deliver a proper level of performance? How can we measure it? Database performance is a very vast topic, but we would...
6 Critical Components of Successful Data Governance
Properly established data governance means that you can make faster and smarter decisions. It sounds simple, but it requires you to build a set of processes and a culture that respects certain key principles. If...
Integrating ClusterControl with SNMP : Part Two
This blog post is a continuation of the previous part 1, where we have covered the basics of SNMP integration with ClusterControl. In this blog post, we are going to focus on SNMP traps and...
What is new in PostgreSQL 13?
PostgreSQL, also known as the world's most advanced open source database, has a new release version since last September 24 2020, and now it is mature, we can check what is new there to start...