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

July 11, 2018

Galera Cluster Recovery 101 – A Deep Dive Into Network Partitioning

One of the cool features in Galera is automatic node provisioning and membership control. If a node fails or loses communication, it will be automatically evicted from the cluster and remain unoperational. As long as...

July 10, 2018

How to Recover MySQL Galera Cluster From an Asynchronous Slave

Introduction When running Galera Cluster, it is a common practice to add one or more asynchronous slaves in the same or in a different datacenter. This provides us with a contingency plan with low RTO,...

July 2, 2018

Disaster Recovery Planning for MySQL & MariaDB

We’re happy to announce that our new whitepaper Disaster Recovery Planning for MySQL & MariaDB is now available to download for free! Database outages are almost inevitable and understanding the timeline of an outage can...

May 18, 2018

Cloud Disaster Recovery for MariaDB and MySQL

MySQL has a long tradition in geographic replication. Distributing clusters to remote data centers reduces the effects of geographic latency by pushing data closer to the user. It also provides a capability for disaster recovery....

May 11, 2018

My MySQL Database is Corrupted… What Do I Do Now?

How do MySQL tables get corrupted? There are many ways to spoil data files. Often, corruption is due to defects in the underlying platform, which MySQL relies on to store and retrieve data - disk...

May 2, 2018

How to Overcome Accidental Data Deletion in MySQL & MariaDB

Someone accidently deleted part of the database. Someone forgot to include a WHERE clause in a DELETE query, or they dropped the wrong table. Things like that may and will happen, it is inevitable and...

April 26, 2018

How to do Point-in-Time Recovery of MySQL & MariaDB Data Using ClusterControl

Backups are crucial when it comes to safety of data. They are the ultimate disaster recovery solution - you have no database nodes reachable and your datacenter could literally have gone up in smoke, but...

March 27, 2018

Comparing Database Proxy Failover Times – ProxySQL, MaxScale and HAProxy

ClusterControl can be used to deploy highly available replication setups. It supports switchover and failover for GTID-based MySQL or MariaDB replication setups. ClusterControl can deploy different types of proxies for traffic routing: ProxySQL, HAProxy and...

March 8, 2018

Transparent Database Failover for Your Applications

ClusterControl is a great tool to deploy and manage databases clusters - if you are into MySQL, you can easily deploy clusters based on both traditional MySQL master-slave replication, Galera Cluster or MySQL NDB Cluster....

March 7, 2018

How ClusterControl Configures Virtual IP and What to Expect During Failover

Virtual IP address is an IP address that does not correspond to an actual physical network interface. It floats between multiple network interfaces and only one active interface will be holding the IP address for...

March 2, 2018

Failover for MySQL Replication (and others) – Should it be Automated?

Automatic failover for MySQL Replication has been subject to debate for many years. Is it a good thing or a bad thing? For those with long memory in the MySQL world, they might remember the...

December 8, 2017

Point-in-Time PostgreSQL Database Restoration

The ability to perform backup and restore of your data is one of the fundamental requirements of any DBMS. In a previous post, we discussed Postgres backups in general. In this blog post, we’ll look...

Subscribe below to be notified of fresh posts