MySQL Archives - DistributedDBA

Infrastructure as Code For Database Workloads

July 14, 2021Database Administration1 Comment

Infrastructure as Codefor Database Workloads As a database administrator, you may be used to manually installing and managing your database infrastructure. Perhaps you have heard of a concept called Infrastructure…

MySQL on Kubernetes

June 23, 2021Database Administration

MySQL on Kubernetes There is a rising interest in running stateful workloads on Kubernetes. You may not be ready to run your database there. But if your organization is exploring…

Automate MySQL Configuration with Ansible

June 9, 2021Database Administration

Automate MySQL Configuration with Ansible Database configuration is one of those things that you can easily automate with Ansible. I discussed this in my presentation at PerconaLive 2021 on Practical…

User roles in MySQL

May 12, 2021Data Security

User Roles in MySQL User management is one of the key tasks around securing your database. It provides the rules for who can connect, and what they can do after…

Basic MySQL Optimizer Tracing

April 28, 2021Data Performance

Basic MySQL Optimizer Tracing Have you investigated a query that is performing poorly? If so, you likely are familiar with the concept of EXPLAINing the query to see how the…

MySQL schema change options

March 31, 2021Data Availability

MySQL online schema change options There are two truths that collide in this post: Schema changes are a fact of life.Many schema changes are blocking in MySQL, which reduces data…

3 Reasons to Use Open Source Databases

February 24, 2021Database Administration

3 Reasons to Use Open Source Databases I believe data is the single most important commodity of your company. That means choosing the right way to store it is extremely…

Sysbench for Data Performance

January 6, 2021Data Guardian Toolbox

Sysbench for Data Performance When you look at the performance of your databases, it's good to have an understanding of baseline performance. Benchmarking will help you here. For open-source databases,…

MySQL Semi-Synchronous Replication Basics

December 23, 2020MySQL High Availability

MySQL Semi-Synchronous Replication Basics Replication in MySQL is an important feature for achieving High Availability of your data. Asynchronous replication is the default in MySQL. It is easy to configure…

Snooping MySQL passwords with eBPF

December 3, 2020Data Security

Snooping MySQL passwords with eBPF Common sense and Data Security best practices dictate that you should not provide cleartext passwords. However, I often see this exact thing when connecting to…