MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how to create and manage sandbox instances of MySQL on your local system.

In this blog, we introduce a Quick Start solution for deploying WordPress on Oracle Cloud Infrastructure (OCI). Discover how this solution leverages OCI's automation and MySQL HeatWave Database to effortlessly deploy a fully functional WordPress instance.

Episode #65 of MySQL Shorts in now available!

Some years ago, I wrote an article on connecting to MySQL 8.0 using the default authentication plugin (caching_sha2_password) with Perl. I also provided Perl-DBD-MySQL packages for EL7.

Somebody recently left a comment as he was looking for a perl-DBD-MySQL driver compatible with the caching_sha2_password for Rocky Linux 8 (EL8 or OL8 compatible).

Therefore, I build two new packages supporting the latest perl-DBD-MySQL driver, version 5.005.

The difference is related to the version of libmysql they are linked to.

libmysql.so.21 for MySQL 8.0 and libmysql.so.24 for MySQL 8.4 LTS:

MySQL 8.0

$ rpm -qf …

Replication being slow—replication lag—is a common complaint, but MySQL replication is actually really fast. Let’s run a controlled experiment and peek inside the Performance Schema binary logs to see why.

Replication being slow—replication lag—is a common complaint, but MySQL replication is actually really fast. Let’s run a controlled experiment and peek inside the Performance Schema and binary logs to see why.

Replication being slow—replication lag—is a common complaint, but MySQL replication is actually really fast. Let’s run a controlled experiment and peek inside the Performance Schema and binary logs to see why.

MySQL Shell offer many features to make life easier for DBAs and developers. In this post we talk discuss the comprehensives help system in MySQL Shell.

Episode #64 of MySQL Shorts in now available!

MySQL Meetup