MySQL

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.

A replication lag is the cost of delay for transaction(s) or operation(s) calculated by its time difference of execution between the primary/master against the standby/slave node. This blog shows you how to diagnose and correct this problem.

SQL Injections are a common way that hackers attempt to compromise your system. This blog explains how to implement a SQL firewall for protection using ProxySQL.

Tracing and identifying slow query performances is not too difficult with MySQL. This blog provides you the overview and overlook on how to deal with slow performing queries and how to identify them.

In this blog post, we look into ways to solve the full disk space issue for MySQL running in a Linux-based environment.

With an increase of the usage of solid state drives I/O performance has significantly increased allowing users to push their databases even faster but even then I/O may become a bottleneck and a limiting factor of the performance of the whole database. In this blog post we will take a look at the things you want to check if you notice your I/O performance is high on your MySQL instance.