MySQL Shell 1.0 (1.0.11 GA, published on Thursday, 30 Nov 2017)

MySQL Workbench 6.3 (6.3.10 GA, published on Wednesday, 15 Nov 2017)

You’re Invited to Oracle MySQL Innovation Day!

Join us to hear directly from MySQL’s lead engineers about MySQL’s latest advances and road map, which were developed with two goals in mind: to help you solve real-world challenges and innovate to get ahead.

You’ll get a view of our strategic direction,into specific capabilities, their use cases, and benefits in our interactive sessions.

Register for this no-cost event to:
Learn about MySQL’s advances and what’s ahead from Oracle MySQL’s leading engineers.
Discover new solutions and ways to sharpen your competitive edge.
Ask questions and engage in discussions with MySQL experts.
We look forward to seeing you there! …

Oracle Open World’s session catalog is online. Here are some of the MySQL centeric highlights!

MySQL Shell: The DevOps Tool for MySQL
Monday, Oct 02, 3:15 p.m. – 4:00 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 15

MySQL Document Store
Monday, Oct 02, 11:00 a.m. – 1:00 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 14

MySQL Performance Tuning 101
Tuesday, Oct 03, 11:30 a.m. – 12:30 p.m. | Hilton San Francisco Union Square (Ballroom Level) – Continental Ballroom 7

Using MySQL Containers
Monday, Oct 02, 2:15 p.m. – 3:00 p.m. | Marriott Marquis (Yerba Buena Level) – Salon 15

MySQL Enterprise Edition: Complete Guide
Monday, Oct 02, 1:15 …

Busy month with PNWPHP at Washington University’s Kane Hall September 7th to the 9th. MySQL is sponsoring and I will be manning the booth. This is an exciting event on the PHP calendar and they have a great speaker lineup. Ticket are still available if you are in the area.

Swanseacon returns for a second year and I will be speaking on making MySQL Agile-ish. MySQL is proud to be sponsoring for a second year and I am looking forward to the wonderful Welsh audience again. Tickets are going quickly.

And do not forget that Oracle Open World is the first five days in October. MySQL will also have some post show events and I will provide more details when I get them.

We are excited to announce that the sneak peek schedule for the Percona Live Open Source Database Conference Europe 2017 is up! The Percona Live Open Source Database Conference Europe 2017 is September 25 – 27, at the Radisson Blu Royal Hotel.

The theme of Percona Live Europe 2017 is Championing Open Source Databases, with sessions on MySQL, MariaDB, MongoDB and other open source database technologies, including time series databases, PostgreSQL and RocksDB. This year’s conference will feature one day of tutorials and two days of keynote talks and breakout sessions …

Percona announces the release of Percona Toolkit 3.0.4 on August 2, 2017.

Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL and MongoDB server and system tasks too difficult or complex for DBAs to perform manually. Percona Toolkit, like all Percona software, is free and open source.

You download Percona Toolkit packages from the web site or install from official repositories.

This release includes the following changes:

New Features

• PT-90: Added collection of information …

MySQL 8 will have Common Table Expressions also known as CTEs.  I have had people asking me when  MySQL would have CTEs for years and I am glad to report they are ready for testing.

What Does a CTE look like?

The keyword WITH is the big hint that the statement is a CTE.  For now think of a CTE as a collections of views or subqueries that you combine together for the desired results. After the WITH clause, one or more comma separated sub-clauses that are subqueries. And CTEs can reference other CTEs.  For a first example, let us combine the world_x example database’s city and country table to produce a list of all cities and their corresponding countries.

WITH
  cte1 as (select Name as CName, CountryCode as CCode from city),
  cte2 as (select Name as Name, Code from country)
SELECT cte1.CName, cte2.Name from …

Connector/C 6.1 (6.1.11 GA, published on Sunday, 23 Jul 2017)

We are extending the Percona Live Open Source Database Conference Europe 2017 call for papers deadline to Monday, July 24, 2017. Get your submissions in now!

Between our Conference Committee working hard to review all the outstanding talk ideas, and the many community requests for more time, we didn’t want to shortchange any of our applicants. If you procrastinated too long, didn’t complete your talk submission or just plain forgot to submit, this is your reprieve! You have one extra week to pull together a proposal for a talk on open source databases at Percona Live Europe 2017.

The theme of Percona Live Europe 2017 is “Championing Open Source Databases.” There …