A Guide to MySQL Galera Cluster Streaming Replication: Part Two
In the first part of this blog we provided an overview of the new Streaming Replication feature in MySQL Galera Cluster. In this blog we will show you how to enable it and take a...
Using MySQL Galera Cluster Replication to Create a Geo-Distributed Cluster: Part Two
In the previous blog in the series we discussed the pros and cons of using Galera Cluster to create geo-distributed cluster. In this post we will design a Galera-based geo-distributed cluster and we will show...
How to Create a Clone of Your MySQL or PostgreSQL Database Cluster
If you are managing a production database, chances are high that you’ve had to clone your database to a different server other than the production server. The basic method of creating a clone is to...
Tips for Storing MongoDB Backups in the Cloud
When it comes to backups and data archiving, IT departments are under pressure to meet stricter service level agreements, deliver more custom reports, and adhere to expanding compliance requirements while continuing to manage daily archive...
How to Troubleshoot MySQL Database Issues
As soon as you start running a database server and your usage grows, you are exposed to many types of technical problems, performance degradation, and database malfunctions. Each of these could lead to much bigger...
Failover & Failback for PostgreSQL on Microsoft Azure
It’s pretty common to use the cloud to store your data or as a failover option in the case of master failure. There are several cloud providers which allow you to store, manage, retrieve, and...
Comparing DBaaS Failover Solutions to Manual Recovery Setups
We have recently written several blogs covering how different cloud providers handle database failover. We compared failover performance in Amazon Aurora, Amazon RDS and ClusterControl, tested the failover behavior in Amazon RDS, and also on...
Using Backups to Fix Common Failure Scenarios for MongoDB
Production outages are almost guaranteed to occur at some point. Accepting this fact and analyzing the timeline and failure scenario of your database outage can help better prepare, diagnose, and recover from the next one....
The Most Common PostgreSQL Failure Scenarios
There is not a perfect system, hardware, or topology to avoid all the possible issues that could happen in a production environment. Overcoming these challenges requires an effective DRP (Disaster Recovery Plan), configured according to...
Database Switchover and Failover for Drupal Websites Using MySQL or PostgreSQL
Drupal is a Content Management System (CMS) designed to create everything from tiny to large corporate websites. Over 1,000,000 websites run on Drupal and it is used to make many of the websites and applications...
Database Load Balancing Using HAProxy on Amazon AWS
When traffic to your database increases day-after-day it can start to become hard to manage. When this situation happens it’s useful to distribute the traffic across multiple servers, thus improving performance. Depending on the application,...
Database Failover for WordPress Websites
Every profitable enterprise requires high availability. Websites & Blogs are no different as even smaller companies and individuals require their sites to stay live to keep their reputation. WordPress is, by far, the most popular...