MySQL

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.

In this blog, we will help you to set database KPI for the Mysql 8.0 monitoring, and things that may cause harm to it. Knowledge of how to use limited resources is essential for anybody managing a production database.

The audit plugin is one of the less known features of the innovative MySQL load balancer ProxySQL. We gave it a try and we want to share how useful it is and what kind of logs it provides.

The new MySQL Clone Plugin can be used to rebuild a replication slave. Currently the go-to tool for that, as well as for backups, is Xtrabackup. In this blog we will compare these two tools and look at how they work and behave.

Installing a standalone MySQL server is a simple straightforward task, but this can be problematic if you have multiple database servers, versions, platforms and environments to support. Thus, having a configuration management tool is the way to go to improve efficiency, remove repetitiveness and reduce human errors. In this blog post, we are going to go walk you through the basics of Ansible's automation for MySQL, as well as configuration management with examples and explanations.

MySQL 8.0 has important performance and security improvements and there are several things to take into account before taking it into production. In this blog, we’ll look at the new MySQL 8.0 features, some deprecations, and what you need to keep in mind before migrating.

MySQL 8.0.17 introduced a new way of provisioning MySQL data - clone plugin. This blog explores this new feature and how you can use it in your database environment.

ClusterControl 1.7.5 introduces a new feature, MySQL Freeze Frame, which can be very helpful for DBA's when troubleshooting database crashes. Freeze Frame takes a snapshot of your database right before a failure, providing you with valuable insight.. This blog will show you how to use this feature.

In this article, we will explain how you can analyze the MySQL database queries workload using pt-query-digest, processlist and more. You will learn how to track database queries and how to find long-running ones.

The internet can be a dangerous place for data that isn’t protected. Using a VPN connection is one way to protect your data in transit by encrypting the traffic over the internet. In this blog, you’ll show how to configure an OpenVPN server in a database node running in the cloud, and how to access it using a VPN client.

In this article, we will explain how you can analyze the workload of your MySQL production systems. Then we’ll evaluate a list of fundamental configuration parameters that can help you improve performance. Performance tuning is not trivial, but you can go a long way with a few basic guidelines.