Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Apply (1) filters
268 blog posts in 1 category

High Availability on a Shoestring Budget - Deploying a Minimal Two Node MySQL Galera Cluster

Learn how to set up a Galera cluster with just 2 nodes and use Garbd to retain high availability.

Hybrid OLTP/Analytics Database Workloads in Galera Cluster Using Asynchronous Slaves

Reporting and analytics is a common requirement, but should you run it on your production database? For Galera Cluster, heavy OLAP queries may interfere with the performance of regular OLTP operations. In this blog post, we’ll describe an easy way to offload OLAP workload from Galera Cluster to asynchronous replication slave.

How to Migrate MySQL from Amazon EC2 to your On-Prem Data Center Without Downtime

Database migrations are a pain. They often require maintenance windows and can be a cause of downtime. In this blog, we will see how we can migrate a MySQL database from Amazon EC2 to an on-premise datacenter without any downtime whatsoever.

Monitoring Your Databases with MySQL Enterprise Monitor

Keeping track of the state of your production databases is crucial for performance and availability. There are a number of database monitoring tools on the market, and MySQL Enterprise Monitor is probably one of the older ones. Let’s take a look at what MySQL Enterprise Monitor can do for us.

ClusterControl Tips and Tricks: Running ClusterControl on PHP 7

PHP 5 is deprecated since early this year, which may cause some concerns when running ClusterControl. This blog post shows you how to run ClusterControl on PHP 7.

SCUMM: the agent-based database monitoring infrastructure in ClusterControl

Please meet SCUMM - Severalnines CMON Unified Monitoring and Management - our agent-based monitoring infrastructure, which is the cornerstone of our latest ClusterControl release.

Automate Deployment of your MySQL or Postgres Cluster from Backup

Restoring backups on newly deployed clusters can be time consuming. There are a number of procedures and checks to go through, and it is a task that lends itself to automation. This blog post shows you how to automate the entire process and deliver improvements in terms of speed, efficiency and cost.

How to Manage Your PostgreSQL Databases from the ClusterControl CLI

What if you could deploy a 3-node streaming replication setup in one command? Or orchestrate a master failover with reslaving of nodes in one command? Welcome to ClusterControl’s command line interface to manage your PostgreSQL setups. This blog post shows you how to manage your PostgreSQL streaming replication cluster using s9s, the ClusterControl CLI.

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.

Monitoring & Ops Management of MongoDB 4.0 with ClusterControl

MongoDB 4.0 added support for multi-document ACID transactions, which brings it closer to the relational world. But how can you manage it, along with other relational open source databases like MySQL, MariaDB and PostgreSQL? In this blog post, we look at the challenges of operating a MongoDB database, and see how important tasks like monitoring, alerting, backups and failover can be handled with ClusterControl.