MySQL & MariaDB Load Balancing with ProxySQL
Proxies are building blocks of high availability setups for MySQL and MariaDB. They can detect failed nodes and route queries to hosts which are still available. If your master failed and you had to promote...
ClusterControl 1.4 – the MySQL Replication & MongoDB Edition
Today we are pleased to announce the 1.4 release of ClusterControl - the all-inclusive database management system that lets you easily deploy, monitor, manage and scale highly available open source databases in any environment; on-premise...
Online Schema Change With gh-ost – Throttling and Changing Configuration at runtime
(this post was edited on 13/01/2017 after comments from Shlomi N.) In previous posts, we gave an overview of gh-ost and showed you how to test your schema changes before executing them. One important feature...
How to use the ClusterControl Query Monitor for MySQL, MariaDB and Percona Server
The MySQL database workload is determined by the number of queries that it processes. There are several situations in which MySQL slowness can originate. The first possibility is if there is any queries that are...
How to Perform Online Schema Changes on MySQL Using gh-ost
In the previous blog post, we discussed how gh-ost works internally and how it compares to Percona’s pt-online-schema-change. Today we’d like to focus on operations - how can we test a schema change with...
How to Perform Efficient Backup for MySQL and MariaDB
All backup methods have their pros and cons. They also affect database workloads differently. Your backup strategy will depend upon the business requirements, the environment you operate in and resources at your disposal. Backups...
Online Schema Change for MySQL & MariaDB – Comparing GitHub’s gh-ost vs pt-online-schema-change
Database schema change is one of the most common activities that a MySQL DBA has to tackle. No matter if you use MySQL Replication or Galera Cluster, direct DDL’s are troublesome and, sometimes, not...
The DevOps Guide to Database Backups for MySQL and MariaDB
This week we’re happy to announce that our new DevOps Guide to Database Backups for MySQL & MariaDB is now available for download (free)! This guide discusses in detail the two most popular backup...
Deploying and Monitoring MySQL and MongoDB clusters in the cloud with NinesControl
NinesControl is a new service from Severalnines which helps you deploy MySQL, Galera, and MongoDB clusters in the cloud. In this blog post we will show you how you can easily deploy and monitor your...
Schema Upgrades in Galera Cluster for MySQL and MariaDB – How to Avoid RSU Locks
Working as MySQL DBA, you will often have to deal with schema changes. Changes to production databases are not popular among DBAs, but they are necessary when applications add new requirements on the databases. If...
Webinar Replay: 9 DevOps Tips for Going in Production With MySQL / MariaDB Galera Cluster
Many thanks to everyone who participated in this week’s webinar on ‘9 DevOps Tips for going in production with MySQL / MariaDB Galera Cluster’. The replay and slides are now available to watch and read...
MySQL Database Security Upgrade Instructions for Zero-day Exploit
You must have heard about the CVE-2016-6662, the recent zero-day exploit exposed in most of MySQL and its variants. The vulnerability flaw can be exploited by a remote attacker to inject malicious settings into your...