I love the new shell but the one thing I missed from the old shell was the ability to use a pager like more or less to throttle the output of the screen.  Low and behold the engineers have added paging in MySQL Shell 8.0.13!!

Turn Paging On
Things can scroll off the screen quickly and pagination programs keep the output to small chunks.  To pick the more program as you pagination program, simply enter \pager more or for less enter \pager less

See the first illustration

…

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.…

Tweet

MySQL Shell makes it easy to develop tools you can use for example to generate reports. In a previous blog, I showed how to use external modules in MySQL Shell. In this blog, I will take it one step further and use the curses Python module to create auto-refreshing reports. The first example will be kept very simple to show the idea, then a more realistic example will be shown where the top N files sorted by I/O will be returned.

Note

Out of the box, this does not work on Windows as Python does not ship with the curses library.

Basic Example

As a basic example, consider the query SELECT NOW(). This returns …

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 8". …

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.

DOAG 2018 Conference + Exhibition will be held November 20 - 23, 2018 in Nuremberg. Participants will have the opportunity to attend more than 400 talks and international top speakers, plus a wide choice of workshops and community activities. This is a great opportunity to expand your knowledge and benefit from the know-how of the Oracle community. 
As in the past years we will be present with more than 10+ specific MySQL talks from various MySQL customer and MySQL experts. 
During the 3 conference days, you'll have the chance to meet the MySQL and Cloud experts from 9am-12am at Cloud Café at the Oracle booth (3rd floor, 320) or you arrange a meeting with us: mysql-sales_de@oracle.com.