The latest from the MySQL community

Good news ! The MySQL & Friends Devroom has been accepted for Fosdem’s 2018 edition !

This event is a real success story for the MySQL ecosystem, the content, the speakers and the attendees are growing every year.

Fosden 2018’s edition will take place 3rd & 4th February in Brussels and our MySQL & Friends devroom will run on Sunday 4th. FOSDEM & MySQL is a love story started 18 years ago !

The committee selecting the content for our devroom is not yet created and if you want to be part of this experience, just send me an email (candidate at mysqlandfriends dot eu) before Oct 20th .

If you want to join the Committee you have to align with the following conditions:

– planning to be present at FOSDEM
– having a link with …

I periodically do MySQL Troubleshooting tutorials. Every time I run them I have a dilemma on how to make tutorials more interactive. I tried:

1. Just talk. But troubleshooting is about action, not about sitting and listening 
2. Put tasks on my own website which required a lot of coding, not related to the talk and tasks themselves.
3. Put tasks on VirtualBox image. Many attendees do not want to use flash drive or download big image from Internet.
4. Put tasks into Amazon EC2 instance. This is practically good option, but expensive.
5. Use machines, provided by tutorial organizers (conference or training center). This is, probably, the best option, but few do it.

I did not like any of these options as final solution. That's why for my last two tutorials I tried Stepik platform. This is how " …

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community.

This week: a quick roundup of releases, a summary of my thoughts about Percona Live Europe 2017 Dublin, links to look at and upcoming appearances. Oracle OpenWorld happened in San Francisco this past week, and there were lots of MySQL talks there as well (and a good community reception). I have a bit on that as well (from afar).

Look for these updates on Planet MySQL.

Releases

• Red Hat Software Collections 3.0 Beta now has MariaDB 10.2.7, MongoDB …

It was expected for a long time…. here is the fix for bug #199 !!

The bug #199 submitted by PeterZ has been fixed in 8.0. Thank you to Zhang Simon for his contribution that inspired us to implement the fix.

Let’s have a look at the test case described in the bug report, I will reproduce it on MySQL 5.7.19 & MySQL 8.0.3.

The initial steps are exactly the same on both versions:

mysql> create table a(id int unsigned not null primary key auto_increment);
Query OK, 0 rows affected (0.17 sec)

mysql> show create table a\G
*************************** 1. row ***************************
       Table: a
Create Table: CREATE TABLE `a` (
  `id` int(10) unsigned NOT …

We are pleased to announce that MySQL Enterprise Monitor 3.4.4 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.

You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.

Important: MySQL Enterprise Monitor (MEM) 4.0 offers many significant improvements over MEM 3.4 and we highly recommend that you consider upgrading. More information on MEM 4.0 is available here:

• …

The Metrics Monitor of Percona Monitoring and Management 1.3.0 (PMM) provides graph descriptions to display more information about the monitored data without cluttering the interface.

Percona Monitoring and Management 1.3.0 is a free and open-source platform for managing and monitoring MySQL®, MariaDB® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL, MariaDB® and MongoDB servers to ensure that your data works as efficiently as possible.

Each dashboard graph in PMM contains a lot of information. Sometimes, it is not easy to understand what the plotted line represents. The metric labels and the plotted data are limited and have to account for the space they can use in dashboards. It is …

MySQL Cluster Manager 1.4.4 is now available for download from My Oracle Support.

What’s new?
With MCM 1.4.4 we continue to improve on MySQL Cluster Manager, specifically around:

• the collect logs command
• process status reporting
• process command execution in specific scenarios

More details
More details are available in the MCM 1.4.4 Release Notes.…

One for the road…

The social events at Percona Live Europe provide the community with more time to catch up with old friends and make new contacts. The formal sessions provided lots of opportunities for exchanging notes, experiences and ideas. Lunches and coffee breaks proved to be busy too. Even so, what’s better than chilling out over a beer or two (we were in Dublin after all) and enjoying the city nightlife in good company?

Percona Live Europe made it easy for us to get together each evening.  A welcome reception (after tutorials) at Sinnott’s Pub in the heart of the City hosted a lively crowd. The Community Dinner at the Mercantile Bar, another lively city center hostelry, was a sell-out. While our closing reception was held at the conference venue, which had proven to be an excellent base. 

Many delegates took the chance to enjoy the best of Dublin’s hospitality late into the night. It’s …