Categories
Products
Technologies
Top Rated docs

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 4, 2019

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

September 3, 2019

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

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

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 22, 2019

The Easy Way to Deploy a MySQL Galera Cluster on AWS

ClusterControl 1.7.3 comes with a notable improvement in cloud integration. It is possible to deploy a MySQL and PostgreSQL replication cluster to the cloud, as well as automatically launch a cloud instance and scale out...

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

August 14, 2019

A Guide to Automated Cloud Database Deployments

Complex, inflexible architectures, redundancy and out-of-date technology, are common problems for companies facing data to cloud migration.  We look to the “clouds,” hoping that we will find there a magic solution to improve operational speed...

August 7, 2019

MySQL Load Balancing: Migrating ProxySQL from On-Prem to AWS EC2

Migrations between different environments are uncommon in database world. Migrations from one provider to another one. Moving from one datacenter to another. All of this happens on a regular basis. Organisations search for expense reduction,...

July 31, 2019

Running Big Data Analytics Queries Using SQL and Presto

Presto is an open-source, parallel distributed, SQL engine for big data processing. It was developed from the ground-up by Facebook. The first internal release took place in 2013 and was quite a revolutionary solution for...

July 22, 2019

How to Monitor PostgreSQL Running Inside a Docker Container: Part Two

This is the second part of the multi-series How to Monitor PostgreSQL Running Inside a Docker Container. In Part 1, I presented an overview of docker containers, policies and networking. In this part we will...

July 19, 2019

How to Manage MariaDB 10.3 with ClusterControl

MariaDB Server is no longer a straight imitate of MySQL. It grew into a mature fork, which implements new functionalities similar to what proprietary database systems offer in the upstream. MariaDB 10.3 greatly extends the...

Subscribe below to be notified of fresh posts