In our previous blog on SCUMM dashboards, we looked at the MySQL overview dashboard. The new version of ClusterControl (ver. 1.7) offers a number of high resolution graphs of useful metrics, and we went through the meaning of each of the metrics, and how they help you troubleshoot your database. In this blog, we will look at the MySQL Replication dashboard. Let’s proceed on the details of this dashboard on what has to offer.

MySQL Replication Dashboard

The MySQL Replication Dashboard offers a very straightforward sets of graph that makes it easier to monitor your MySQL master and replica(s). Starting from the top, it shows the most important variables and information to determine the health of the replica(s) or even the master. This dashboard offers a very useful part when inspecting the health of the slaves or a …

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 …