The most popular and widely-used database in the world, MySQL is a proven relational database technology. Our MySQL technology blog takes a look at the entire MySQL world, be in standalone, replicated, or clustered.
Vendor lock-in, or proprietary lock-in, occurs when a customer becomes dependent on a vendor for products and services. In this blog, we will see how to avoid it using open source tools.
Replicating your database cluster to a remote datacenter is key in achieving Disaster Recovery with minimal RTO and RPO, but there are other reasons like datacenter migration or geo distribution. However, if managing a cluster was not hard enough, setting up and managing replicated clusters takes complexity to another level. In this blog, we will have a peek at a new ClusterControl 1.7.4 feature that allows you to set up replication between clusters.
ClusterControl 1.7.4 introduces a new function that could be the ultimate way to minimize RTO as part of your disaster recovery strategy. Cluster-to-Cluster Replication for MySQL and PostgreSQL lets you build-out a clone of your entire database infrastructure and deploy it to a secondary area, ensuring you always have an available up-to-date database setup ready to switch-over to should disaster strike.
Migrating from proprietary to open source databases poses challenges. In this blog we share some tips on what you should keep in mind while planning the transition.
A hot standby is a common term in computing, especially on highly distributed systems. It's a method for redundancy in which one system runs simultaneously with an identical primary system. In this blog how you can create a Hot Standby Node on Amazon AWS for Galera Cluster 4.0 using MariaDB.
Master switches are very common operations in replication setups. They are part of every migration - from one environment to another, from older version of MySQL to more recent one. In a live production environment, you may want to reduce the impact they have on the application. If you wonder how to do it, we are here to help. In this first part we will go over the initial setup of the environment. In the upcoming next part we will explain the process of transparent master switch with ProxySQL.
In this blog post, we are going to deploy a high-available setup for our private "Dropbox" infrastructure using Nextcloud, GlusterFS, Percona XtraDB Cluster (Galera Cluster), ProxySQL with ClusterControl as the automation tool to manage and monitor the database and load balancer tiers.
New in MySQL Galera Cluster 4.0, Streaming Replication allows you to now replicate large write-sets, which is perfect for bulk inserts or loading data to your database. In the second part we will show you how to enable Streaming Replication and what the results could look like when you use it.
New in MySQL Galera Cluster 4.0, Streaming Replication allows you to now replicate large write-sets, which is perfect for bulk inserts or loading data to your database. In the first part of this blog we will tell you about this new feature and how you can use it.
Amazon EC2 is a very popular environment to deploy your infrastructure on and MySQL Galera is a very popular high availability solution for MySQL. How do they work together? In this blog post we will show how one can deploy the latest version of Galera Cluster on Amazon EC2.
Hosting your database with a cloud provider, such as Microsoft Azure, still requires you to prepare and define your disaster recovery policy. In this blog, we will cover all of the backup and restore methods Azure offers for MySQL.
This is the second part of a two-part series. Here we look into designing a geo-distributed MySQL Galera Cluster and explain how it can be easily deployed using ClusterControl
What is the best way to create a geo-distributed cluster? Can Galera Cluster be used for such scenario? What are the cons of Galera compared to regular MySQL replication? This blog attempts to answer those questions.
Cloning a database cluster can be a common way to duplicate your deployment environment for example, from dev to staging to production or vice versa. In this blog post, we showcase some of the features in ClusterControl that can help users duplicate their database infrastructure with little effort.
MySQL Galera Cluster 4.0 is the new kid on the database block with very interesting new features. Currently it is available only as a part of MariaDB 10.4 but in the future it will work as well with MySQL 5.6, 5.7 and 8.0. In this blog post we would like to go over some of the new features that came along with Galera Cluster 4.0.
ClusterControl as a proactive monitoring tool also comes with a troubleshooting toolset to help users troubleshoot and fix the database issues as they happen. This blog post looks into each of the troubleshooting tools in greater details.
Cloud Providers provide great options when it comes to failover, but they may not be right for every application. In this blog post we will spend a bit of time analysing the pros and cons of using the DBaaS solutions compared with designing an environment manually or by using a database management platform, like ClusterControl.
Designing a large system that is fault-tolerant, highly-available, with no Single-Point-Of-Failure (SPOF) requires proper testing to determine how it would react when things go wrong. In this blog we will explore the failover and failback operations of Amazon RDS using Aurora.
Almost all cloud vendors provide some sort of high availability options in their managed relational databases. In this blog we are going to explore the failover handling for MySQL SQL nodes on Google Cloud Platform
Drupal is a CMS designed to create everything from tiny to large corporate websites. Failover comes in handy for any admin as it can eliminate long hours of downtime caused by corruption the need for maintenance. In this blog we’ll discuss how you can implement database failover for your MySQL or PostgreSQL databases.
Amazon Aurora Serverless provides an on demand, auto-scaling, high-availability relational database that only charges you when it’s in use. Almost all aspects of MySQL are handled automatically by Aurora Serverless including scaling. This blog post documents our way to understand the automatic scaling behaviour of this database technology.