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

November 17, 2017

How to Fail or Crash Your MySQL Instances for Testing

You can take down a MySQL database in multiple ways. Some obvious ways are to shut down the host, pull out the power cable, or hard kill the mysqld process with SIGKILL to simulate an...

September 1, 2017

Manage and Automate Galera Cluster – Why ClusterControl

Galera Cluster by Codership is a synchronous multi-master replication technology which can be utilized to build highly available MySQL or MariaDB clusters. It has been downloaded over one million times since last year, establishing itself...

June 29, 2017

Automatic Failover of Postgres Replication

Streaming replication setups with Postgres are inevitably related to failovers. The sole writer in the setup would be the primary, it generates XLOG records and continuously ships them to one or more standby servers. If...

April 11, 2017

Full Restore of a MySQL or MariaDB Galera Cluster from Backup

Performing regular backups of your database cluster is imperative for high availability and disaster recovery. If for any reason you lost your entire cluster and had to do a full restore from backup, you would...

March 23, 2017

MySQL Replication and GTID-Based Failover – A Deep Dive Into Errant Transactions

For years, MySQL replication used to be based on binary log events - all a slave knew was the exact event and the exact position it just read from the master. Any single transaction from...

January 30, 2017

Automatic Failover of MySQL Replication – New in ClusterControl 1.4

MySQL replication setups are inevitably related to failovers. Unlike multi-master clusters like Galera, there is one single writer in a whole setup - the master. If the master fails, one of the slaves will have...

September 12, 2016

Recovering your MongoDB Data

In previous posts of our MongoDB DBA series, we have covered Deployment, Configuration, Monitoring (part 1), Monitoring (part 2) and backup. Now it is time to recover MongoDB using a backup we made in the...

April 20, 2016

MySQL Replication Failover – MaxScale vs MHA: Part Four

In the earlier blogs in this series, we concluded that MaxScale with MariaDB Replication Manager still has some way to go as a failover solution. The failover mechanism relied on MariaDB GTID, needed a wrapper...

February 24, 2016

MySQL Replication Failoverv – Maxscale vs MHA: Part Three

In our previous two posts we described in depth how MySQL Master-HA (MHA) and MaxScale + MariaDB Replication Manager (MRM) both perform their so called slave promotions (also known as master failover). MHA has been...

February 22, 2016

MySQL Replication Failover – Maxscale vs MHA: Part Two

In our previous post, we described how MySQL Master-HA (MHA) performs a so called slave promotion (also known as master failover) and ensures all remaining slaves in the topology get attached under the new master...

February 22, 2016

MySQL Replication Failover – Maxscale vs MHA: Part One

In our MySQL replication tutorial we have covered different aspects of replication including master failover by performing a slave promotion using ClusterControl. The slave promotion will turn a slave into the new master, and re-attach...

August 6, 2015

Architecting for Failure – Disaster Recovery of MySQL Galera Cluster

Failure is a fact of life, and cannot be avoided. No IT vendor in their right mind will claim 100% system availability, although some might claim several nines :-) We might have armies of ops...

Subscribe below to be notified of fresh posts