Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Top Common Issues with MHA and How to Fix Them

MHA (Master High Availability) is a popular failover solution used in MySQL Master-Slave topologies. It is stable and used in production by large companies such as Facebook. In this blog, we outline the most common but important issues that you might encounter when running MHA. We’ll also see how to resolve them.

Performance Monitoring for TimescaleDB

Doing a performance monitoring in TimescaleDB is always a challenging task, especially for a very huge time-series data. ClusterControl offers a way to help a DBA or a developer to make things feasible and productive with the aid of the different features integrated within ClusterControl. Check out this blog as we showcases what are these and how you can leverage ClusterControl to monitor your TimescaleDB cluster.

Monitoring & Ops Management of MySQL 8.0 with ClusterControl

MySQL 8.0 is a big step forward in terms of data consistency, developer features, performance and availability. MySQL 8.0 shortens the gap between proprietary databases and open source world, making the migration decision much easier to take.

But how can you manage it, along with other relational open source databases? In this blog post, we look at the challenges of operating a MySQL 8.0 database, and see how important tasks like monitoring, alerting, backups and failover can be handled in an automated way.

An Introduction to TimescaleDB

Time-series data is becoming more and more present, as we capture and analyze data at a faster rate. This increases the demand for complex queries and scalable database solutions. This blog provides a high-level overview of the new database system “TimescaleDB”, and a quick hands-on to get you going.

An Introduction to Time Series Databases

Time-series databases have emerged as a best-in-class approach for storing and analyzing huge amounts of data generated by users and IoT devices.

But what are time-series databases? Why have they become so important in the database landscape? In this blog post, we try to shed some light on the subject.

Deploying Secure Multicloud MySQL Replication on AWS and GCP with VPN

MySQL Replication is still favored by some organization as it's simple to implement and run. However, in a multi-cloud setup like Google Cloud Platform <–> Amazon Web Services, things can get tedious without proper cluster management, monitoring and observability tools. This blog showcases how to create a secure implementation of cloud <–> cloud replication and how ClusterControl can be used to resolve these impediments.

ClusterControl Tips & Tricks - Dealing with MySQL Long Running Queries

Long running queries are pretty much inevitable in MySQL or MariaDB, and unfortunately, they can lead to disastrous results. But why do queries take long time to execute? How do you deal with them?

This blog post shows how you can use ClusterControl to easily detect them, especially in environments with many database instances.

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.

Pages