ProxySQL 1.4.12, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Percona’s proxysql-admin tool.

ProxySQL is a high-performance proxy, currently for MySQL and its forks (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the database. René Cannaò created ProxySQL for DBAs as a means of solving complex replication topology issues.

The ProxySQL 1.4.12 source and binary packages available at https://percona.com/downloads/proxysql …

In the last few months, I had to install Percona Server 5.7 (PS5.7) on Debian a few times.  I was regularly annoyed by apt-get -y install percona-server-server-5.7 prompting me for a password.  But that annoyance did not push me to investigate the subject in detail: it was always a quick manual fix and Googling did not lead to a straightforward solution.  However in the last days, I had to

MySQL Shell 8.0.13 (GA) introduced a new feature to import JSON documents to MySQL in an easy way. The basics of this new feature were described in a previous blog post. Here, we provide more details about this feature, focusing on a practical use case that may be of interest for some readers: How to import JSON data from MongoDB to MySQL.…

Recently, I did some maintenance on Innotop and I merged several pull requests including one to support MySQL 8.0 (thank you yoku0825 for the contribution).

As you know, Innotop is written in Perl and to be able to use it with MySQL 8.0, you need to have Perl DBD for MySQL compatible with MySQL 8.0 too (a driver that support the new default authentication plugin, caching_sha2_password).

If you are using Fedora 29, I created such package and you can download it here: …

Percona announces the release of Percona Server for MySQL 5.7.23-24 on November 12, 2018 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.23, including all the bug fixes in it. Percona Server for MySQL 5.7.23-24 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free.

This release introduces InnoDB encryption improvements and merges upstream MyRocks changes. Also, we’ve improved the usage of column families in MyRocks. The InnoDB encryption …

We are happy to confirm that we are ready for another two shows which will take place this week. One in the US second in Europe. Please find details below:

• PHP[World]

  • Place: Washington DC, US
  • Date: November 14-15, 2018
  • MySQL Community team is a Workshop sponsor here with David Stokes, the MySQL Community Manager as MySQL representative on site. 
• BGOUG
  • Place: Pravets, Bulgaria
  • Date: November 16, 2018
  • MySQL sponsors & attends this show for years. This year Georgi Kodinov, the Senior Software Developer Manager for MySQL will have a talk on "Data Masking in MySQL Enterprise 5.7 and …

We are happy to announce that this Thursday, November 15 at 7:00 p.m., there will be a MySQL meetup in Madrid, Spain. Please find more details below:  

• Date: Nov 15, 2018
• Time: 7:00-9:00pm
• Place: booking.com @ Torre Europa Paseo de la Castellana 95, Planta 11 · Madrid
• Agenda:
  • Morgan Tocker: "TiDB: Distributed, horizontally scalable, MySQL compatible”
  • Simon Mudd: "Vitess and MySQL Cluster" More information & registration can be found on the Meetup website: https://www.meetup.com/Madrid-MySQL-users-group/events/255291731/  

Do not forget to register on the page if you are coming.

We have sent requests and also received candidatures for the MySQL, MariaDB & Friends Devroom Committee. Now we are happy to announce you the name of the people who will rate your submissions:

• Daniël van Eeden (for the Community)
• Art van Scheppingen (for the Community)
• Giuseppe Maxia (for the Community)
• Aurélien Lequoy (for the Community)
• Tom de Cooman (for Percona)
• …

JSON has proven to be a very import data format with immense popularity. A good part of my time for the last two or so years has been dedicated to this area and I even wrote a book on the subject.  This is a comparison of the implementations of handling JSON data in MySQL and MariaDB. I had requests from the community and customers for this evaluation.


JSON Data Types Are Not All Equal
MySQL added a JSON data type in version 5.7 and it has proven to be very popular.  MariaDB has  JSON support  version 10.0.16 but is actually an alias to a longtext data type so that statement based replication from MySQL to MariaDB is possible.

MySQL stores  JSON documents are …

Somebody on Freenode wanted this:

   Source            Result
+----+------+    +----+------+
| id | x    |    | id | c    |
+----+------+    +----+------+
|  1 |    1 |    |  1 |    2 |
|  2 |    1 |    |  2 |    2 |
|  3 | NULL |    |  3 | NULL |
|  4 | NULL | -> |  4 | NULL |
|  5 |    1 |    |  5 |    1 |
|  6 | NULL |    |  6 | NULL |
|  7 |    1 |    |  7 |    3 |
|  9 |    1 |    |  9 |    3 |
| 10 |    1 |    | 10 |    3 |
+----+------+    +----+------+

The result uses the NULL values in x as boundaries of windows, and counts the number of rows within each window. I don't know why anyone wants such a thing; it is not ours to reason why...

Anyway, the point is that you can use arbitrary expressions, even subqueries, to define your window partitions.

SELECT 
    id, 
    -- Count of rows in windows bound by NULL values in x
    IF(
      x IS NULL, 
      NULL, 
      COUNT(*) OVER (PARTITION BY (
        -- …