Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
18 blog posts in 13 categories

Automating PostgreSQL Daily Tasks Using Jenkins

This blog details how to automate several daily tasks you need to run a successful PostgreSQL setup using Jenkins.

Database Automation with Puppet: Deploying MySQL & MariaDB Galera Cluster

This post walks you through deployment of MySQL/MariaDB Galera Cluster using Puppet module. We’ll also look at how ClusterControl can be used to automate the management aspects of the environment once it’s set up.

Database Automation with Puppet: Deploying MySQL & MariaDB Replication

This post walks you through deployment of MySQL/MariaDB replication using Puppet module. We’ll also look at how ClusterControl can be used to automate the management aspects of the environment once it’s set up.

How to Automate Migration from Standalone MySQL to Galera Cluster using Ansible

Database migrations are painful, as they involve a lot of steps - from creation of the target infrastructure to migrating schema and data, and oh.. a lot of testing. Some of the steps can be automated though, you can rely on Ansible. This blog post presents a playbook that can be used to assist in the process of migrating to Galera Cluster.

Benchmarking Manual Database Deployments vs Automated Deployments

Good system administrators and devops hate performing mundane tasks and constantly look for ways at automating themselves out of the job. There are plenty of automation tools out there to help the cause. But if automation is a no brainer, why aren’t more people doing it? In this blog post we compare three ways of deploying a MySQL Galera cluster - manual, Ansible playbook and ClusterControl.

Webinar Replay: How to Automate & Manage PostgreSQL with ClusterControl

Watch the replay of our webinar on how to automate and manage PostgreSQL with ClusterControl. Sebastian Insausti, Support Engineer at Severalnines, will introduce us to the world of PostgreSQL ops automation: from the ‘old ways’ to the modern way of managing PostgreSQL; including a look at ClusterControl’s integrated approach to deployment, monitoring, performance management, scaling, upgrades and backup, delivered as an integrated suite that plugs into your favourite tools.

Failover for MySQL Replication (and others) - Should it be Automated?

This blog discusses whether automated failover should be used in a MySQL Replication environment setup.

Posted in:

How to Get Started with ClusterControl

In this blog we show you how to become a modern DBA and achieve your goals with ClusterControl, the ready-made solution that will help you automate your database system lifecycle in no time.

Posted in:

How MongoDB Database Automation Improves Security

The growing number of cyberattacks on open source database deployments highlights the industry’s poor administrative and operational practices. This blog explores how database automation is the key to keeping your MongoDB database secure.

Database Cluster Management - Manual vs Automation via ClusterControl

Database Cluster management tasks include restart/recovery of services that fail, topology changes, reconfiguration, rolling upgrades, backups and performing security procedures. Since the tasks usually involve multiple servers, these can be repetitive and error-prone. This blog looks at efficiency gains when using ClusterControl to manage a MySQL Galera cluster as compared to manual ways.

Pages