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...
Tips and Tricks – How to Shard MySQL With ProxySQL in ClusterControl
Having too large a (write) workload on a master is dangerous. If the master collapses and a failover happens to one of its slave nodes, the slave node could collapse under the write pressure as...
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...
Choosing a MySQL Storage Engine and Its Impact on Backup Procedures
MySQL offers multiple storage engines to store its data, with InnoDB and MyISAM being the most popular ones. Each storage engine implements a more specific set of features required for a type of workload, and...
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...
Deploy a Homogeneous Galera Cluster with etcd
In the previous blog post, we have looked into the multi-host networking capabilities with Docker with native network and Calico. In this blog post, our journey to make Galera Cluster run smoothly on Docker containers...
Answering Eurofunk’s Database SOS Call
Eurofunk replaces Oracle with feature-rich Severalnines ClusterControl Today we’re happy to announce Eurofunk, one of the largest European command centre system specialists, as our latest customer. Severalnines was brought on board to help manage the...
Cloud Lock-in and Open Source Databases
The cloud is no longer a question of if, but of when. Many IT leaders, however, find that one consistent barrier to their adoption of the cloud is vendor lock-in. What do you do when...
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...
Keeping the Tills Ringing at eCommerce Platform vidaXL
ClusterControl helps vidaXL compete with the world's largest e-commerce platforms by managing its MongoDB & MySQL databases. Press Release: everywhere around the world, November 9th 2016 - today we announced vidaXL, an international eCommerce platform where...