The latest from the MySQL community

Welcome to MySQL 8.0.13.   If you haven’t already read about all the great new updates please take a minute and read the announcement.  Along with all the new updates in the server we have a full complement of connectors t hat are now available and I wanted to take a moment to share our updates.

First I want to go over the changes related to the X DevAPI, our new API that merges the great relational power of MySQL with our new Document Store.  Unless specified, all of our MySQL 8.0 series connectors includes all the DevAPI updates.

DevAPI

Connection Pooling – One of the most expensive operations that a connector can do is to simply connect to the server.  This is especially true if you are using SSL/TLS (and  you should be!).  So we wanted to make …

As we already informed you on another blog posted on Oct 16, 2018, MySQL is going to have a MySQL talk at JavaScript (JSFoo) this year. This is our first time we are attending JSFoo, Bangalore, India and we hope our attendance will be very well welcomed! Do not miss the opportunity to come to listen the MySQL talk as follows:

• "MySQL 8 loves JavaScript" given by Sanjay Manwani, MySQL India Sr Director & Developer Evangelism at Oracle, talk is scheduled for Saturday, Oct 27, 2018 @13:40-14:10.

More information and logistics can be found here.

We are looking forward to meeting & talking to you at JSFoo 2018!

As it was already announced on another blog posted on Oct 16, 2018, MySQL is a Bronze sponsor of Forum PHP show this year.

We are going to have a MySQL talk on "MySQL 8.0: What's new" given by Olivier Dasini, the Principal Sales Consultant. His talk is scheduled for October 26th @9:30-10:10am. You are very welcome to come to listen Olivier's talk & discuss MySQL topics with our staff at Forum PHP in Paris, France.

More information & logistics available at Forum PHP website.

We are looking forward to talking to you there!

In February I added a new feature to my Sysbench version that I use in
my MySQL Cluster testing. This new feature adds a new column in the
table called filter. It contains the same value as the primary key.

With this new column I can easily change the range scan queries in
sysbench from returning 100 rows to instead scan 100 rows and
return 1 row. This means that sysbench can benchmark the filtering
performance of the underlying database engine.

Next I ran tests where set the number of rows in the range to
10.000 rows. This new test was a perfect vehicle to improve performance
in NDB for scan filtering.

Filtering one row in 7.6.7 in this sysbench tests costs about 750 ns.

When I started out optimising these 750 ns of time I didn't expect so
much improvement, but using perf it was possible to get very
fine-grained …

With the release of MySQL 8.0.13 yesterday, we added support in MySQL 8 for SUSE Linux Enterprise (SLE) 15, the brand new version of one of the key enterprise Linux distros out there. At the same time, we also introduced support for SLE 15’s community twin, openSUSE Leap 15. So as of yesterday, all MySQL […]

On our job schedule system. Using osc-tool cause deadlock problem.
We investigated the root cause in detail and published this PDF doc.

OSC_DDL_PROBLEM

The latest release of the MySQL Shell 8.0.13 (GA) introduced some interesting improvements and features, for more information see the full changelog here: https://dev.mysql.com/doc/relnotes/mysql-shell/8.0/en/mysql-shell-news-8-0-13.html. One of those features was the introduction of a convenient and easy way to import JSON documents to a MySQL Server database.…

One important way to protect your data is to keep your Tungsten Clustering software up-to-date.

A standard cluster deployment uses three nodes, which allows for no-downtime upgrades along with the ability to have a fully available cluster during maintenance.

Please note that with only two database cluster nodes, there is a window of vulnerability created by leaving zero failover candidates available when the lone slave is taken down for service.

The Best Practices: Staging Performing a No-Downtime Upgrade for a Staging Deployment

When upgrading a Staging-style deployment, all nodes are upgraded at once in parallel via the tools/tpm update command run from inside the staging directory on the staging host.

No Master switch happens, and all layers are restarted to use the new code. …

Recently we had a customer that had issues with a filled disk on the server hosting their Docker pmm-server environment. They were not able to access the web UI, or even stop the pmm-server container because they had filled the /var/ mount point.

Setting correct expectations

The best way to avoid these kinds of issues in the first place is to plan ahead, and to know exactly with what you are dealing with in terms of disk space requirements. Michael Coburn has written a great blogpost on this matter:

https://www.percona.com/blog/2017/05/04/how-much-disk-space-should-i-allocate-for-percona-monitoring-and-management/

We are now using …

One of the most common questions about privileges in MySQL and MariaDB is how would a user revoke access to a particular table, in a large database with hundreds or thousands of tables, while keeping the rest available. Currently, there is no easy solution. Just grant access to everything else, individually. Not only does this reduce server performance, but is a nightmare to maintain. Reverse privileges solve this and more. And they are simple to explain to new admins too! So I look forward to sharing the knowledge during my presentation at PLE18.

DBAs would benefit from this talk the most. As it is a feature still under development, we are open for input from the community. Tell us what you think we should do to make this feature the best it can be.

What I’m looking forward to…

It will be quite …