Categories
Products
Technologies
Top Rated docs

October 8, 2019

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...

October 1, 2019

What’s New in MySQL Galera Cluster 4.0

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...

September 30, 2019

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...

September 26, 2019

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...

September 18, 2019

Achieving MySQL Failover & Failback on Google Cloud Platform (GCP)

There are numerous cloud providers these days. They can be small or large, local or with data centers spread across the whole world. Many of these cloud providers offer some kind of a managed relational...

September 16, 2019

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...

September 10, 2019

Comparing Galera Cluster Cloud Offerings: Part Three Microsoft Azure

Microsoft Azure is known to many as an alternative public cloud platform to Amazon AWS. It's not easy to directly compare these two giant companies. Microsoft's cloud business -- dubbed commercial cloud -- includes everything...

August 30, 2019

Comparing Failover Times for Amazon Aurora, Amazon RDS, and ClusterControl

If your IT infrastructure is running on AWS, you have probably heard about Amazon Relational Database Service (RDS), an easy way to set up, operate, and scale a relational database in the cloud. It provides...

August 23, 2019

Comparing Galera Cluster Cloud Offerings: Part One Amazon AWS

Running a MySQL Galera Cluster (either the Percona, MariaDB, or Codership build) is, unfortunately, not a  supported (nor part of) the databases supported by Amazon RDS. Most of the databases supported by RDS use asynchronous...

August 23, 2019

Building a MySQL or MariaDB Database Cold Standby on Amazon AWS

High Availability is a must these days as most organizations can’t allow itself to lose its data. High Availability, however, always comes with a price tag (which can vary a lot.) Any setups which require...

August 19, 2019

A Guide to MySQL Galera Cluster Restoration Using mysqldump

Using logical backup programs like mysqldump is a common practice performed by MySQL admins for backup and restore (the process of moving a database from one server to another) and is also the most efficient...

August 15, 2019

Automated Deployment of MySQL Galera Cluster to Amazon AWS with Puppet

Deployment and management your database environment can be a tedious task. It's very common nowadays to use tools for automating your deployment to make these tasks easier. Automation solutions such as Chef, Puppet, Ansible, or...

Subscribe below to be notified of fresh posts