Back in April I was preparing for vacations that my wife and I
planned to spend in UK. Among other things planned I wanted to
visit a customer's office in London and discuss few MySQL and MariaDB
related topics, let's call them "stories". I tried to prepare
myself for the discussion and collected a list of known active
bugs (what else could I do as MySQL entomologist) for each of
them. Surely live discussion was not suitable to share lists of
bugs (and for some "stories" they were long), so I promised to
share them later, in my blog. Time to do what I promised had
finally come!
One of the stories we briefly discussed was "partitioning story".
Right now I can immediately identify at least 47 active MySQL
bugs in the related …
Recently during my several talks and trips to meet the MySQL Community and MySQL InnoDB Cluster, I realized that some important message was missing. I got a lot of questions about which version of Router or Shell people should use. There is some confusion about which version to use, it seems that people thinks they should use MySQL Shell 1.0.x and MySQL Router 2.1.x with MySQL 5.7 and use the 8.0.x version having the same version as MySQL 8.0. This is wrong !
In fact, whatever the version of MySQL InnoDB Cluster you are using, you should ALWAYS use the latest version of Router and Shell. Currently it’s 8.0.11. So yes, even if you use MySQL 5.7.22, you MUST use MySQL Router 8.0.11 and …
[Read more]Percona announces the GA release of Percona Server for MySQL 5.7.22-22 on on May 31, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.
Based on MySQL 5.7.22, including all the bug fixes in it, Percona Server for MySQL 5.7.22-22 is the current GA release in the Percona Server for MySQL 5.7 series. Percona …
[Read more]Percona announces the GA release of Percona Server for MySQL 5.7.21-21 on on April 24, 2018. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the images in the Docker Hub repository.
This version of Percona Server for MySQL 5.7.21 includes three new encryption features – Vault keyring plug-in, encryption for InnoDB general tablespaces, and encryption for binary log files.
These new capabilities, which allow companies to immediately …
[Read more]
I have some free time today, but I am still lazy enough to work
on numerous planned and pending "ToDo" kind of posts, so why not
to continue review of older MySQL bugs I am
subscribed to. Today I am going to list 15 more bugs reported
more than a year ago and still not fixed:
- Bug #85805 - "Incorrect ER_BAD_NULL_ERROR after LOAD DATA LOCAL INFILE". This detailed bug report by Tsubasa Tanaka stays "Verified" for more than a year already. It's a great example of gdb use for MySQL troubleshooting. Setting a couple of breakpoints may really help to understand how MySQL works and why some …
I think it's time to review some bugs I've subscribed to several
months ago, those older than in the first post from this series. There are
several really serious bugs in the list of 15 below:
- Bug #87560 - "XA PREPARE log order error in replication and binlog recovery". This bug was reported by Wei Zhao, who also provided patches.
- Bug #87526 - "The output of 'XA recover convert xid' is not useful". This bug reported by Sveta Smirnova is well known and is a real pain for DBAs who have to deal with incomplete XA transactions after some crash or unexpected restart. Check …
Recently I blogged about the new default authentication plugin in MySQL 8.0 and I got some comments complaining that this new authentication plugin is breaking half of applications.
So first of all, if you are using an old connector or a
connector (like the one for Go) not yet supporting
caching_sha2_passwordas authentication plugin, you
are still able to
use the old
one. If you have created a new
user for your application not supporting the new authentication
method, you just have to run the …
The latest release of dbdeployer is possibly the last one with a leading 0. If no serious bugs are found in the next two weeks, the next release will bear a glorious 1.0.
Latest news
The decision to get out of the stream of pre-releases that were published until now comes because I have implemented all the features that I wanted to add: mainly, all the ones that I wished to add to MySQL-Sandbox but it would have been too hard:
- …
Version 0.3.0 of dbdeployer has gained the ability of deploying
multiple sandboxes concurrently. Whenever we deploy a group of
sandboxes (replication, multiple) we can use
the --concurrent flag, telling dbdeployer that it
should run operations concurrently.
What happens when a single sandbox gets deployed? There are six sets of operations:
- Create the sandbox directory and write down its scripts;
- Run the initialisation script;
- Start the database server;
- Run the pre-grants SQL commands (if any;)
- Load the grants;
- Run the post-grants SQL commands (if any;)
When several …
[Read more]
In one of my gdb-related posts last year I noted
that there is no more simple global list of user threads in MySQL
5.7+:
"I had highlighted Global_THD_manager singleton also as
during my next gdb sessions I had found out that simple global
list of threads is also gone and in 5.7 everything is done via
that Global_THD_manager. This is a topic for some other
post, though."In that post and many times later when I had to
deal with MySQL 5.7+ I just checked OS threads one by one in
gdb using thread 1 ... thread N
commands. This is not efficient at best, as I also hit numerous
background threads that I often do not care about. So, a couple
of weeks ago I finally decided to get back to this topic and find
out how to check just user threads one by one in recent MySQL
versions. I had a nice …