MySQL

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.

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

This blog provides a quick reference for DBAs and SysAdmins who are either new to MySQL or MongoDB with regards to the terms and commands available within the database and how they compare with one another.

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.

Making sure the right people have access to your MySQL data is very important. This blog shares what has changed with user management in MySQL 8.0.

MySQL 8.0 features a lot of great improvements, comprehensive support for technologies, and most importantly, its enhanced performance under high read/write workloads. In this blog, we’ll have a look at how MySQL 8.0 performs as compared to its predecessor MySQL 5.7.

Migrating ClusterControl to new hardware used to be a pain - you had to reinstall it on the new server, restore configuration/metadata from the old one and redo database grants so the new server can access your managed databases. Not any more! Starting with 1.7.1, it is possible to backup the ClusterControl server in one command and restore it on a new server, with data, grants and all.  This blog shows you how to do this using the s9s CLI.

This blog post explains a number of ways to improve performance of ClusterControl and its components.

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.

This blog provides an overview of the next iteration of the agent-based monitoring features for MySQL, Galera Cluster, PostgreSQL and ProxySQL in ClusterControl with its 1.7.1 release, support for PostgreSQL 11 and MongoDB 4.0, as well as a whole range of new monitoring and backup management features for PostgreSQL … and more.

You would be surprised by the number of MySQL installations running default configurations, regardless of the workload. However, what works well for a read-intensive workload might not work as well for a write-intensive one. Configuration parameters also need to take into account the underlying hardware. This cheat sheet provides some quick tips on how to tune some of the key MySQL variables in order to improve performance.

Read about 2018 at Severalnines: from our top achievements of the year via our year-end video all the way through to our most read and watched content for MySQL, MariaDB, PostgreSQL & MongoDB users.

This blog details MySQL’s accomplishments in 2018, including the release of MySQL 8.0 which includes changes to roles and the integration of NoSQL.

This blog compares MySQL replication vs Oracle Data Guard solution for High Availability.

The database industry has completely changed in the past two decades - from closed source to open source first, single instances to distributed clusters, polyglot environments and increasingly automated operational systems that are slowly but surely taking over the common core tasks of the DBA.

This blog discusses this industry shift.

Watch the replay of this webinar for a detailed overview of what failover processes may look like in MySQL, MariaDB and PostgreSQL replication setups. We’ll cover the dangers related to the failover process and look at how ClusterControl manages it as well as how it can be configured for both assisted and automated failover.

A query cache can greatly improve database performance, and there are various types of mechanisms available - from the inbuilt MySQL query cache to external key value stores like memcached or Redis. In this blog, we’ll show you how to cache your queries via ProxySQL, and avoid the overhead of an additional dedicated caching layer.

A delayed replication slave is useful in recovering from accidental data deletion. But how long should the delay be? Too short delay might not be enough for you to get to a terminal and stop an offending query. Too long delay means a long recovery time when catching up.

This blog post shows how to deploy multiple MySQL delayed slaves on one single physical host with Docker, and shows some of the recovery scenarios.

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.

Backups that contain critical data are stored offsite as part of a disaster recovery solution. Encryption is a basic requirement, but how do you ensure you have the right encryption? How do you manage the encryption keys? And once everything is encrypted, how do you ensure you have the right data in your backups? This blog will discuss some of the best practices related to backup encryption.

Cloud storage is a scalable and reliable way of archiving backups. There are some design considerations when building cloud-enabled backup solutions for MySQL or MariaDB in order to meet security and recovery objectives.

In this blog post, we will discuss encryption, compression, and network traffic throttling. We’ll also see how you can upload your backups to Amazon S3, Google Cloud Storage and Azure Storage.