When performing health checks on a database, I look at how many users are granted SUPER privileges. If you're reading this, you know why. SUPER privileges pose a potential security risk and should be limited to a few users that need this far-reaching access to...
For this example, the following software versions were in use: Ubuntu v20.04.3MySQL server v5.7.35Percona XtraBackup v2.4.24 It is important to note that Percona XtraBackup 8.0 is not compatible with MySQL version 5.7 and was introduced for use with MySQL version 8.0....
This blog article will explain what the SST method choices are and what you need to consider when choosing one over another. To start with, the wsrep_sst_method is a configuration parameter used with Galera Clustering. This parameter tells the database server which...
Encrypted connections for MySQL replication are the default as of 8.0. The following simple example shows a basic setup for encrypted replication using Ubuntu 20.04 and MySQL Community 8.0.27. The steps may be similar for other Linux distributions. The necessary files...
What is a deadlock and what exactly does it mean in regards to databases? In order to fully define what a deadlock is, it's important to note that a 'lock' itself occurs when multiple processes are simultaneously trying to access the same resource. A deadlock occurs...
Understanding thread concurrency can help troubleshoot performance issues by optimizing how InnoDB multitasks between transaction requests simultaneously, but it is not a simple FIFO (first in: first out) process. That would not be efficient or leave much for a DBA to...
Background When running a batch file on MySQL the login credentials must be taken from some file. The file choices are to use a clear-text options file or the more secure obfuscated login-file generated by the MySQL program mysql_config_editor (which comes installed...
In this tutorial, I will go over the steps to clone your MySQL instance on the same server. This tutorial will only cover the steps to accomplish a clone on a Linux server. To ensure you do not cause corruption to the existing MySQL instance you will need to ensure...
There are many reasons to install Windows Guest Additions for Oracle VM VirtualBox: mouse pointer integration, enable shared folders and clipboard, optimal video support, as well as generic host/guest communications. The most notable feature is the ability to resize...
If within a MySQL instance a schema name such as "#mysql#lost+found" or "#lost+found" is listed when the "show schemas" or “show databases” command is run, it's not a true schema but will appear when MySQL is installed in a root directory on a Linux server. At the...