March 20, 2024

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...

August 16, 2023

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)...

October 6, 2023

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...

December 8, 2023

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...

Categories
Products
Technologies
Top Rated docs

August 4, 2020

Press Release: Severalnines Cluster-to-Cluster Replication Provides Peace of Mind With Multi-Cloud Disaster Recovery

Organizations around the world were unprepared for COVID-19's impact. Severalnines helps companies stay prepared when crisis strikes with their end-to-end disaster recovery solutions. If the COVID-19 pandemic has shown us anything, it’s that it is...

July 6, 2020

What Are MariaDB Temporal Tables?

Starting from 10.3.4, MariaDB comes with temporal tables. It is still quite an uncommon feature and we would like to discuss a bit what those tables are and what they can be useful for. First...

June 25, 2020

Fixing Page Faults in MongoDB

Page faults are a prevalent error that mostly occurs in a large application involving large data. It takes place when MongoDB database reads data from physical memory rather than from virtual memory. Page fault errors...

June 15, 2020

Multi-Cloud Full Database Cluster Failover Options for PostgreSQL

Failover is the ability of a system to continue working even if some failure occurs. It suggests that the functions of the system are assumed by secondary components if the primary components fail or if...

June 10, 2020

Eliminating PostgreSQL Split-Brain in Multi-Cloud Databases

Using a multi-cloud or multi-datacenter environment is useful for geo-distributed topologies or even for a disaster recovery plan, and actually, it is becoming more popular nowadays, therefore the concept of split-brain is also becoming more...

May 27, 2020

pghoard Alternatives – PostgreSQL Backup Management with ClusterControl

Managing backups could be a complex and risky task to do in a manual way. You must know that the backup is working according to your backup policy as you don’t want to be in...

May 20, 2020

pg_restore Alternatives – PostgreSQL Backup and Automatic Recovery with ClusterControl

While there are various ways to recover your PostgreSQL database, one of the most convenient approaches to restore your data from a logical backup. Logical backups play a significant role for Disaster and Recovery Planning...

May 13, 2020

Comparing Amazon RDS Point-in-Time Recovery to ClusterControl

The Amazon Relational Database Service (AWS RDS) is a fully-managed database service which can support multiple database engines. Among those supported are PostgreSQL, MySQL, and MariaDB. ClusterControl, on the other hand, is a database management...

April 14, 2020

My DBA is Sick – Database Failover Tips for SysAdmins

In case of a database failure, the best case scenario is that you have a good Disaster Recovery Plan (DRP) and a highly available environment with an automatic failover process in place. But what happens...

April 8, 2020

My DBA is Sick – Disaster Planning & Backup Tips for SysAdmins

The alarming nature of COVID-19 is being felt globally. Many companies have closed or filed bankruptcy because of the global pandemic.  Most organizations did not see this coming. Large companies have a better chance of...

March 30, 2020

How to Restore a Single MySQL Table Using mysqldump?

Mysqldump is the most popular logical backup tool for MySQL. It is included in the MySQL distribution, so it’s ready for use on all of the MySQL instances.  Logical backups are not, however, the fastest...

March 24, 2020

How to Restore a Single Table Using Percona Xtrabackup?

Backups are the means of protecting from data loss - should something happen, you can easily restore it from the backup. You cannot predict what part of the data will have to be restored -...

Subscribe below to be notified of fresh posts