Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Manage MySQL - for Oracle DBAs

So, you are an Oracle DBA and your manager asked you to migrate a couple of Oracle databases to MySQL. Databases are migrated, and now what? How do you manage these MySQL databases?

In this blog, we show you how Oracle DBAs can best manage MySQL by covering the basic operations of MySQL with reference to similar tasks in your Oracle environment.

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.

Basic Administration Comparison Between Oracle, MSSQL, MySQL, PostgreSQL

Supporting different types of databases in a mixed environment is not an easy task. In this blog post we will compare different types of RDBMS systems from the DBA/DevOps administration perspective.

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.

Top GUI Tools for PostgreSQL

Using a GUI is not a must, but it can be useful in some cases. In this blog, we'll see some advantages and warnings about the use of these tools, as well as do a short review of some of the most commons GUI tools for PostgreSQL.

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.

Monitoring HAProxy Metrics And How They Change With Time

There is a lot information on the traffic that is routed through HAProxy, as well as the state of the backends. This blog post discusses different HAProxy metrics, which ClusterControl collects and presents in the agent-based monitoring mode with Prometheus.

How to Monitor MongoDB with Prometheus & ClusterControl

ClusterControl’s new agent-based monitoring of MongoDB with Prometheus offers dashboards with graphs of high resolution metrics data. In this blog, we will have a look at the different graphs that are available to users.

PostgreSQL Replication for Disaster Recovery

This blog explains how to utilize streaming replication and point in time recovery to achieve high availability using failover.

Database Monitoring - Troubleshooting Prometheus with SCUMM Dashboards

Our SCUMM dashboards rely on Prometheus and exporters to provide high-resolution monitoring data. However, there are cases when dashboards may not load. This blog goes through some troubleshooting guidelines.

Pages