MySQL

Ensuring smooth operations of your production databases is not a trivial task, and there are a number of tools and utilities available to assist operational staff in their work. ClusterControl differs from other products in that it is a complete automation tool that also includes full monitoring. This blog post showcases 9 notable features that you won't find in any other database management and monitoring tools on the market.

Working With MyISAM in MySQL

Jan 16, 2021

Prior to MySQL 5.5, MyISAM was the default storage engine. In this blog post we will cover when, how, and why should you use MyISAM for MySQL.

Tips for Monitoring MySQL for Moodle

Jan 14, 2021

by Pon Suresh Pandian

In this blog, we are going to explain what you need to monitor the MySQL Moodle database and how you can do it easier using ClusterControl.

How to Deploy the Open edX MySQL Database for High Availability

Jan 13, 2021

Open edX is one of most used open source learning management systems. In this blog we will show you how to deploy the Open edX MySQL database for high availability to ensure the performance of uptime of the database cluster.

How to Migrate Standalone Moodle to a Clustered Database Scalable Setup

Jan 12, 2021

by Agus Syafaat

More online users for Moodle means scaling the Moodle servers as well as the database backend. In this blog post we will discuss how to migrate from a standalone database to a highly available Moodle database based on MySQL Replication.

Understanding Character Sets and Collations in MySQL

Jan 09, 2021

Character sets determine what characters are valid in a query string. In this blog, we discuss the importance and performance implications of choosing different character sets in MySQL.

Boosting Performance by Using Read Write Splitting of Database Traffic with Moodle 3.9

Jan 08, 2021

Moodle is the top open source LMS out there but Covid19 has put a strain on many Moodle setups. This blog explains how you can easily scale out a Moodle MySQL database by using additional slave servers.

Improving MySQL Performance with Advanced InnoDB Settings

Dec 31, 2020

In this blog post we discuss how we can make use of advanced InnoDB settings in order to improve the performance of MySQL.

Monitoring MySQL Performance with ClusterControl

Dec 30, 2020

In this blog post we will help you figure out how to monitor the performance of your MySQL databases using ClusterControl.

Database Design 101: Partitions in MySQL

Dec 18, 2020

Partitioning is a database design technique in which a database splits data into multiple tables, but still treats the data as a single table by the SQL layer. In this blog post, we discuss the advantages and disadvantages of partitioning in MySQL.

How to Verify Your MySQL Backups with ClusterControl

Dec 15, 2020

by Sebastian Insausti

Backups are important in all Disaster Recovery Plans, but they don’t have any value if they are not usable. In this blog, we will see how to verify if your MySQL Backup is good to use in an easy way by using ClusterControl.

What is a Query Outlier and How to Fix It

Dec 14, 2020

In this blog post, we are going to highlight the Query Outlier feature available in ClusterControl and see how it can help us improve the database performance.

Performance Testing Using MySQLdump and the MySQL Shell Utility

Dec 11, 2020

by Pon Suresh Pandian

MySQL Shell is one of the most advanced client tools for MySQL servers. In this blog we shall take a look at the speed of the backup and restoration process.

Logical Database Backups Using MySQL Shell

Dec 09, 2020

by Pon Suresh Pandian

MySQL Shell is a one of the most advanced client tools for MySQL servers. In this blog we explain how to use the MySQL shell utilities to take a logical backup.

ALTER TABLE in MySQL: Friend or Foe?

Dec 04, 2020

The MySQL ALTER TABLE statement is used to add, delete, or modify columns in an existing table as well as to add and drop various constraints on an existing table. In this blog post we discuss the advantages and disadvantages of using the ALTER TABLE in MySQL.

How to Deploy Percona XtraDB Cluster 8 for High Availability

Dec 02, 2020

Percona XtraDB Cluster 8.0 is based on Percona Server for MySQL 8.0 embedded with Galera write set replication API and Galera replication library, to form a highly available multi-master replication for MySQL-based database server. In this blog post, we are going to look into how to deploy a Percona XtraDB Cluster 8.0 for high availability using the manual and automated way.

An Overview of ProxySQL Clustering in ClusterControl

Dec 01, 2020

ProxySQL clustering allows you to keep the configuration of multiple ProxySQL instances in sync. The recent version of the ClusterControl comes with support for deploying ProxySQL nodes as part of a cluster. We are going to show you how you can do that.

How to Secure MySQL: Part Two

Nov 27, 2020

In part two of our mini-series on MySQL Security we take a look at several security features like user management as well as the plugins that are available to help keep your data safe.

Monitoring Percona XtraDB Cluster - Key Metrics

Nov 24, 2020

Percona XtraDB Cluster comes with multiple metrics that are strictly related to this particular cluster (and Galera clusters in general). Let’s take a look at them and see what are the most important bits to watch for.

How to Secure MySQL: Part One

Nov 20, 2020

Protecting the data stored in your database is essential. In this blog post, we discuss what we can do to make MySQL more secure. Part one focuses on general security settings and managing user privileges.

Monitoring Percona Server for MySQL - Key Metrics

Nov 17, 2020

In this blog post, we are going to look into some key metrics and status when monitoring a Percona Server for MySQL to help us fine-tune the MySQL server configuration for a long run.

Full-Text Searches in MySQL: The Good, the Bad and the Ugly

Nov 13, 2020