Another MySQL DBA

One question that surfaces regularly in the Percona forums: Does every node in a Percona XtraDB Cluster (PXC) need to have XtraBackup installed?

So I figured it was about time I documented how to build persistent memory for AI agents using the databases you already know.

This post covers a hands-on walkthrough of MySQL 8.0's JSON functions.

The Question We're Finally Asking For years we've debated: Can AI replace software engineers?

Keith, You asked me to be brutally honest about why I failed you.

MySQL Analysis: With an AI-Powered CLI Tool As DBAs with MySQL we often live on a Linux terminal window.

Just for fun...

Here is a simple example showing a couple options for MariaDB Encryption.

This is a topic that overall you never should have to do...

This is just a note to help out anyone that might want to use the mysql_config_editor command in their automation tools. the mysql_config_editor does not take a password argument so automation tools that might have before set your password in the .my.cnf…

MySQL & Dockers... are not new concepts, people have been moving to Dockers for some time now.

MySQL How do you restore tablespace?

So I realized I had not made a post about this after this situation that recently came up.

So MySQL's group replication came out with MySQL 5.7.

So the issue of max_connections dropping from the value set in your my.cnf file down to 214 has been around for a little while on Ubuntu.

Just a simple post here to give support to the slack community channels.

So keepalived has been around for quite a while now .... however it is still a mystery to many.

So I was recently asked to look into why the updated MySQL 5,.6 was slower than the older 5.5 So I started by poking around looking over the standard variables and caches and etc.

So over the years, we all learn more and more about what we like and use often in MySQL.

So when it comes to routing your MySQL traffic several options exist.

Happy Birthday MySQL !

MySQL 8.0.4rc was just released as "Pre-General Availability Draft: 2018-03-19". https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html https://dev.mysql.com/doc/relnotes/mysql/8.0/en/ I decided to take a quick peek and note my impressions here.

So first I have posted in sometime as felt I should be.

MySQL Tablespace Encryption is relatively simple to set up.

I thought I posted this long ago... oh well....