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...
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...
Database Automation Best Practices in the Healthcare Industry
Database management at scale can’t be done without proper automation techniques. Long gone are the days when database administrators were naming their database servers, spend days tuning and tweaking the configuration, ensuring that everything works...
Disaster Recovery for Galera Cluster Deployed to a Hybrid Cloud
Running a Galera Cluster in a hybrid cloud should consist of at least two different geographical sites, connecting hosts in the on-premises or private cloud with the ones in the public cloud. Whether you use...
Automatic Failover of the Moodle PostgreSQL Database
One of the key aspects of high availability is the ability to quickly react to failures. It is not uncommon to manually manage databases, and have monitoring software keep an eye on database health. In...
How to Setup Automatic Failover for the Moodle MySQL Database
In a previous blog, we had discussed how to migrate a standalone Moodle setup to scalable setup based on a clustered database. The next step you will need to think about is the failover mechanism...
How to Verify Your MySQL Backups with ClusterControl
Backups are a basic point in all Disaster Recovery Plans, but only having a backup is not enough to guarantee correct data recovery. You must need to make sure that the backup is usable, and...
Asynchronous Replication Automatic Failover in MySQL 8.0.22
Oracle recently released MySQL 8.0.22, and this new version came with a new asynchronous connection failover mechanism. It allows a replica to automatically establish an asynchronous replication connection to a new source, in case...
Top Open Source Tools for MySQL & MariaDB Migrations
Large organizations that are using MySQL or MariaDB database platforms are often faced with a need to perform a database migration from one place to another. Regardless of the platform, type of database software (such...
Using Barman for PostgreSQL Disaster Recovery
There must be many powerful tools available as a backup and restore option for PostgreSQL in general; Barman, PgBackRest, BART are to name a few in this context. What caught our attention was that Barman...
Database Load Balancing: Distributed vs Centralized Setups
A database load balancer, or database reverse proxy, distributes the incoming database workload across multiple database servers running behind it. The goals of having database load balancers are to provide a single database endpoint to...
How to Prevent Rollbacks in MongoDB
Replication in MongoDB involves replica sets by members with an architecture of a primary and secondary members but at times with a non data bearing member called an arbiter. The replication process is that, whenever...
Video: Database Disaster Recovery with ClusterControl
This past week we debuted a series of videos on database disaster recovery. From basic backup and restore, to switchover & failover, to full cluster-to-cluster replication, these videos show how ClusterControl offers you end-to-end protection...