71 blog posts in 1 category
Asynchronous replication places no low latency demands on the network, so it is possible to keep Galera Clusters in sync even when they are thousands of miles apart and utilise low-cost connections. We effectively can achieve a global system of loosely-coupled clusters. However, managing the global state translates into managing failover and failback operations at both node and cluster level.
Database failures can happen at different levels, from schema corruption on an individual server to hardware or even an entire datacenter going down. So how do we troubleshoot and fix these? In this blogpost, we will walk through 6 different failure scenarios and see how we recovery from them.
This blog provides an overview of the new Backup Management and Security & Compliance features for MySQL & PostgreSQL in the ClusterControl 1.6.2 release.
This blog describes best practices to make your database schema changes in MySQL and MariaDB flawless. We will walk you through different scenarios and recomment some approaches for each.
Galera automatic node provisioning and membership control simplifies database cluster operation and improves the reliability of its replication technology. In this blog post, we are diving into the Galera recovery process in events where network partitioning happens.
What do you do if you lose your Galera Cluster? A simple solution is to failover to an asynchronous slave. The slave would immediately serve up-to-date data to applications, with minimal downtime. But then, with the slave being the new source of truth, how do you recover your Galera Cluster?
Galera Cluster comes with many cool features and advantages over traditional asynchronous replication, but these do not automatically translate into higher performance. In this blog post, we will look at what drives MySQL/MariaDB Galera performance, and see how we can get the most out of the cluster.
So you’ve deployed MariaDB cluster on Docker, what next? What do you do when containers fail or are rescheduled, and IP addresses change? How do you ensure that the database adapts to changes to the underlying container configurations? In this follow-up blog post, we’ll look into cluster management and orchestration of Galera cluster on Docker.
How can you quickly evaluate performance of a database under intensive load? Welcome to sysbench. This blog gives you a good background of sysbench, and how you can use it to benchmark MySQL and MariaDB.
Container orchestration tools do not always play nicely with database clusters. In this blog post, we are going to look into how to run a MariaDB Galera Cluster on Docker containers using the standard Docker image on multiple Docker hosts without the help of orchestration tools like Swarm or Kubernetes.
