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,...
Tips for Storing PostgreSQL Backups on Amazon AWS
Data is probably one of the most valuable assets in a company. Because of this we should always have a Disaster Recovery Plan (DRP) to prevent data loss in the event of an accident or...
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...
How to Migrate MySQL from Amazon EC2 to your On-Prem Data Center Without Downtime
Since its inception, there have been an increasing number of migrations to a cloud-based environment. After all, cloud computing can provide many benefits for businesses, especially those working with big data. However, as the demand...
Comparing RDS vs EC2 for Managing MySQL or MariaDB on AWS
RDS is a Database as a Service (DBaaS) that automatically configures and maintains your databases in the AWS cloud. The user has limited power over specific configurations in comparison to running MySQL directly on Elastic...
How to Deploy ClusterControl on AWS to Manage Your Cloud Database
ClusterControl is infrastructure-agnostic - it can be used in your own datacenter on physical hosts, as well as in virtualized cloud environments. All you need is ssh access from the ClusterControl host to the...