May 28, 2024

Simplifying database orchestration anywhere with Terraform and ClusterControl

Infrastructure as Code (IaC) has become key to modern software development. Terraform – one of the most popular IaC tools – won the hearts of DevOps teams by offering a vast ecosystem of providers that...

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

March 19, 2020

How to Restore a Specific Collection in MongoDB Using Logical Backup

Keeping backups of your database is one of the most important tasks in any production environment. It is the process of copying your data to some other place to keep it safe. This can be...

March 18, 2020

How to Replace an Intermediate MySQL or MariaDB Master with a Binlog Server using MaxScale

Binary logs (binlogs) contain records of all changes to the databases. They are necessary for replication and can also be used to restore data after a backup. A binlog server is basically a binary log...

March 11, 2020

How to Fix a Lock Wait Timeout Exceeded Error in MySQL

One of the most common InnoDB errors is InnoDB lock wait timeout exceeded, for example: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction The above simply means the transaction has reached the...

March 9, 2020

How to Rebuild an Inconsistent MySQL Slave?

MySQL slaves may become inconsistent. You can try to avoid it, but it’s really hard. Setting super_read_only and using row-based replication can help a lot, but no matter what you do, it is still possible...

March 4, 2020

Using MariaDB Flashback on a MySQL Server

MariaDB has introduced a very cool feature called Flashback. Flashback is a feature that will allow instances, databases or tables to be rolled back to an old snapshot. Traditionally, to perform a point-in-time recovery (PITR),...

March 2, 2020

How to Rebuild an Inconsistent PostgreSQL Slave

PostgreSQL Streaming Replication is a great way of scaling PostgreSQL clusters and doing it adds high availability to them. As with every replication, the idea is that the slave is a copy of the master...

February 26, 2020

How to Protect Your MySQL & MariaDB Database Against Cyberattacks When on a Public Network

It is sometimes inevitable to run MySQL database servers on a public or exposed network. This is a common setup in a shared hosting environment, where a server is configured with multiple services and often...

February 19, 2020

When Should I Add an Extra Database Node?

The fact that people are not easily convinced to have an additional database node in production due to cost is somewhat absurd and is an idea that should be put aside. While adding a new...

February 13, 2020

Steps to Take if You Have a MySQL Outage

A MySQL outage simply means your MySQL service is not accessible or unresponsive from the other's perspective. Outages can be originated by a bunch of possible causes.. Network issue - Connectivity issue, switch, routing, resolver,...

February 6, 2020

My MySQL Database is Out of Disk Space

When the MySQL server ran out of disk space, you would see one of the following errors in your application (as well as in the MySQL error log): ERROR 3 (HY000) at line 1: Error...

December 10, 2019

Creating a Cold Standby for PostgreSQL Using Amazon AWS

The need to achieve database High Availability is a pretty common task, and often a must. If your company has a limited budget, then maintaining a replication slave (or more than one) that is running...

December 3, 2019

How to Backup an Encrypted Database with Percona Server for MySQL 8.0

Production interruptions are nearly guaranteed to happen at some point in time. We know it so we plan backups, create recovery standby databases, convert single instances into clusters. Admitting the need for a proper recovery...

Subscribe below to be notified of fresh posts