MySQL

ProxySQL comes with advanced features that allow users to take full control over the database traffic. This blog post will show you how to block certain queries and introduce delays.

A MySQL database index is a data structure that improves the speed of operations in a table. In this post, we discuss the benefits and the drawbacks of using indexes in MySQL.

Load balancers can be deployed into a number of topologies to achieve high availability for the database service with zero single-point-of-failure (SPOF). This blog post covers the pros and cons of distributed or centralized setup for your database load balancers.

MySQL Replication can be used as the database for Moodle implementations. In this blog we will show you how to deploy a highly available Moodle database using a master/slave MySQL setup.

In this blog post we discuss how to optimize one of MySQL’s most widely used storage engines - InnoDB - for high performance.

AWS, Google and Azure all provide public DBaaS services based on MySQL, but which of them is the best? This blog compares the features from each of the main cloud providers.

This past week we debuted a series of videos on database disaster recovery. From basic backup and restore, to switchover & failover, to full cluster-to-cluster replication, these videos show how ClusterControl offers you end-to-end protection in the event of an outage or catastrophe.

In this blog post, we are going to perform an online migration with minimal downtime from MySQL 5.6 standalone setup without GTID to a new replication set running on MySQL 5.7 with GTID, deployed and managed by ClusterControl.

Multi-Cloud deployments are a common part of disaster recovery plans. In this blog we will show you how to setup and optimize a MySQL Replication deployment across multiple clouds.

Split-brain is a serious issue that may affect multi-cloud MySQL database deployments. There are some methods you can use to minimize the risk and ensure your data will stay consistent.

Many SysAdmins & DBAs use MySQL Workbench as a tool to help manage their databases. In this blog post we’re going to take a look at the user experience of the tool and how it compares to ClusterControl.

ProxySQL can sometimes be tricky to configure, but there are tools that can help you do it. In this blog post we will take a look at the proxysql-admin tool from Percona and compare it to how ClusterControl manages ProxySQL

Percona has a tool to analyze queries callled pt-query-digest, part of  the Percona Toolkit. In this blog we will take a look at this tool and how it compares to the Query Management features of ClusterControl.

Point-in-Time Recovery (PITR) is a common part of a disaster recovery plan (DRP). In this blog we’ll take a look at how PITR is performed on Amazon RDS for PostgreSQL, MySQL & MariaDB. We will also look at how ClusterControl does it and see how it compares with RDS.

MySQL Workbench is a popular tool used by SysAdmins and DBAs to manage their MySQL databases. In this blog post, we are going to compare and contrast MySQL database user management features between MySQL Workbench and ClusterControl.

MySQL Workbench is a popular tool used by SysAdmins and DBAs to manage their MySQL databases. In this blog we take a look at how ClusterControl handles configuration management and how it compares to workbench.

Security is always important, especially if you are working from home and need to keep data as secure as when you are at the office. In this blog, we’ll see how to configure SSH Tunneling to access your databases in a secure way, as an alternative to a VPN connection.

Covering for the DBA? In this blog, we’ll share some recommendations to follow in the case that you need to failover your database and don’t have an automatic failover process in place or it failed for some reason.

In the second part of our blog “Preparing a MySQL or MariaDB Server for Production” we continue to share tips to configure and prepare a MySQL server for production usage from a system administrator’s perspective.

It’s safe to say that ProxySQL has become the default database proxy for the MySQL family of databases. But how performant is your ProxySQL setup, and how can you determine that your setup has been tuned correctly? This blog focuses on that and how to monitor it efficiently.

Logical backups, like Mysqldump, are not the fastest nor the most space-efficient way of backing up MySQL databases, but they have a huge advantage over physical backups. In this blog we will show you how to restore a single MySQL table using mysqldump