A Guide to MongoDB Deployment & Maintenance Using Puppet: Part 1
Database clustering often involves configuring and maintaining a number of servers and instances, all with a collective purpose. By this we mean you can have different database servers at different hosts which are serving the...
PostgreSQL Deployment and Maintenance with Ansible
Ansible is one of the most well-known and widely-used IT automation tools, it helps us in automating IT operational tasks such as... Bootstrapping the host (VM or bare-metal machine) from scratch Configuring hosts and services...
Common Errors When Migrating PostgreSQL Databases From On-Prem to AWS RDS
In part one, Migrating PostgreSQL Databases From On-Prem to the Cloud Using AWS RDS, we showed you how to perform the migration. In this blog, we will explore some common errors that might pop up...
Migrating PostgreSQL Databases From On-Prem to the Cloud Using AWS RDS
The following is a step-by-step guide to migrating your PostgreSQL on-premise databases to the cloud using Amazon RDS. For this tutorial, you will need to be running PostgreSQL 10 or later on a Centos/RHEL Linux...
How to Deploy MariaDB Server to a Docker Container
Nowadays, terms like Docker, Images or Containers are pretty common in all database environments, so it’s normal to see a MariaDB server running on Docker in both production and non-production setups. It is possible, however,...
Benchmarking Manual Database Deployments vs Automated Deployments
There are multiple ways of deploying a database. You can install it by hand, you can rely on the widely available infrastructure orchestration tools like Ansible, Chef, Puppet or Salt. Those tools are very popular...
Automate Deployment of Your MySQL or Postgres Cluster From Backup
ClusterControl 1.7.1 introduces a new feature called Create Cluster from Backup, which allows you to deploy a new MySQL or Postgres-based cluster and restore data on it from a backup. This blog post shows how...
How to Deploy MongoDB for High Availability
Introduction MongoDB has great support for high availability through ReplicaSets. However, deploying a ReplicaSet is not enough for a production-ready system. The latter requires a bit of planning. Deployment is just the initial step, we...
Deploy MySQL Replication and ProxySQL With Automatic Failover
MySQL replication is a very popular choice to build highly available setups. It is fairly predictable, robust and efficient. It is also quite easy to setup - install MySQL software, create replication users and configure...
Using Kubernetes to Deploy PostgreSQL
Introduction Kubernetes is an open source container orchestration system for automating deployment, scaling and management of containerized applications. Running a PostgreSQL database on Kubernetes is a topic of discussion nowadays as Kubernetes provides ways to...
Integrating Tools to Manage PostgreSQL in Production
Managing a PostgreSQL installation involves inspection and control over a wide range of aspects in the software/infrastructure stack on which PostgreSQL runs. This must cover: Application tuning regarding database usage/transactions/connections Database code (queries, functions) Database...
Deploying Cloud Databases with ClusterControl 1.6
ClusterControl 1.6 comes with tighter integration with AWS, Azure and Google Cloud, so it is now possible to launch new instances and deploy MySQL, MariaDB, MongoDB and PostgreSQL directly from the ClusterControl user interface. In...