MySQL

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

We are sometimes asked, how can you deploy ClusterControl and make it highly available from the application layer to the database layer? This blog will show you how to deploy a MySQL Replication as the CMON database storage engine with automatic failover and recovery in case of disaster.

In this two-part blog series, we are going to show you 9 tips and tricks on how to configure and prepare a MySQL server for production usage from a system administrator perspective.

This blog post shows how to replace an intermediate MySQL or MariaDB master (a slave host relay to other slaves in a replication chain) with a binlog server running on MaxScale for better scalability and performance.

This blog post covers the implications of a MySQL InnoDB lock wait timeout error, how to deal with it, and how to track what was going one with the blocking transaction that caused the timeout to happen for the other transaction.

MySQL slaves may become inconsistent. You can try to avoid it, but it’s really hard. No matter what you try, it is still possible that your slave will become inconsistent. What can be done to rebuild an inconsistent MySQL slave? In this blog post we’ll take a look at this problem.

Operational Reporting for Version Upgrades and Patches is an area that requires constant attention. This blog shows you how to automate the process for open source databases like MySQL, MariaDB, MongoDB, & PostgreSQL

Using Geo-Location is not new. It has been a desired setup for companies and organizations avoiding SPOF who want resilience and a lower RPO. The challenge comes in setting up database environments. In this blog we will show you how to setup a geo-located MySQL Replication setup using ClusterControl.

Flashback is a feature available in MariaDB that allows instances, databases, or tables to be rolled back to an older snapshot. This blog post showcases how we can use MariaDB flashback on a MySQL server.

This blog post explains ways to protect your MySQL or MariaDB database servers against cyberattacks when they are exposed to a public network.

Diagnosing MySQL high memory utilization can be tricky without knowing what procedures or runbooks it needs to do. Without the right tools, it can take you longer to determine the cause of the issue. This blog delivers you the solution when encountering this type of problem or how to deal mysteries when dealing with high memory utilization.

In this second part of “How to Protect your MySQL or MariaDB Database From SQL Injection” we describe how you can use the upcoming ProxySQL whitelist feature to add even more security to your database tier.

In this blog post, we are looking into steps to take if you think you are having a MySQL outage in a Linux-based environment.