Tag: MySQL 8.0

Feed: Planet MySQL; Author: Marcelo Altmann; Earlier last week, Oracle released their Q2 releases series. Unlike previous releases, backward compatibility has now been broken with previous versions of MySQL. MySQL 8.0.29 extended the support for the online DDL algorithm INSTANT. Prior to 8.0.29 only adding columns to the end of the table was supported. In 8.0.29, this functionality was extended to allow the INSTANT algorithm the ability to add columns in any position of the table as well to drop columns. This new functionality required the redo log version to increase and new redo log types to be added, thus ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; When it’s time for a new MySQL release, it’s also time to thank our contributors ! Released on April 26th, MySQL 8.0.29 contains several contributions from our awesome Community and on behalf of the entire MySQL Team, I would like to thank you all ! This new releases contains patches from Vilnis Termanis, Luke Weber, Meik Milevczik, Song Zhibai, Zheng Lai, Øystein Grøvlen, Facebook, Biran Yue, Hope Lee, Rahul Malik, Christopher Chavez, Chen Yi, Ning PeiPei, Jianjian Song, Jack Wotherspon and Bing Wang. Once again, thank you all for your great contributions and to ... Read More

Feed: Planet MySQL; Author: David Stokes; Oracle released MySQL Server 8.0.29 on April 26th and this is a quick review of the release notes.  I have put my own comments in italics. So what is in the ’29 release of MySQL Server?  Does it come festooned with new, neat features or is it a big bug-fix bonanza? The TL;DR While this server release has some interesting stuff, there is no compelling feature that will necessitate an immediate upgrade.  Read through the release notes to see if anything in there that is a must for you but for most of us, ... Read More

Feed: Planet MySQL; Author: David Stokes; Oracle released MySQL 8.0.28 on January 18th with little fanfare, as part of their four times a year release cycle.  So what is included in the new release? Over the past few years, there have been some cool new features included in these ‘dot’ releases that some in the community say would have been better off being labeled as a major release. But what is in .28? Below are the more interesting changes in the database server and the shell, as there was not a whole lot changed in the other products such as ... Read More

Feed: Planet MySQL; Author: MySQL Performance Blog; KMIP (Key Management Interoperability Protocol) is an open standard developed by OASIS (Organization for Advancement of Structured Information Standards) for the encryption of stored data and cryptographic key management. Percona Server for MySQL 8.0.27 and Percona XtraBackup 8.0.27 now include a KMIP keyring plugin to enable the exchange of cryptographic keys between a key management server and the database for encryption purposes. The procedure to use them with HashiCorp Vault Enterprise is described below. Install Hashicorp Vault Enterprise We will first install Hashicorp Vault Enterprise on Ubuntu Linux “Bionic” and then enable the ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; Last week, Jan 18th, we started 2022 with a new release of the MySQL Server suite (Router, Shell, Connectors, …). MySQL is Open Source and each release contains contributions from our great Community. Let me thanks all the contributors on behalf of the entire MySQL Team: Thank you ! As Dave already mentioned already in his MySQL 8.0.28 Release Note Commentary post, this new version of MySQL includes contributions from Song Zhibai, Venkatesh Prasad Venugopal, Zheng Lai, Tingu Wei, Casa Zhang, Kevin Michel, our Øystein Grøvlen before his comeback, Tsubasa Tanaka, Brian Yue, Murakami ... Read More

Feed: Planet MySQL; Author: Chandan Kumar;  MySQL 8.0.28 version is GA!!! , ready to use in production.Below is high level overview , more can be viewed from the weblink.[1] Disabling Audit Logging for all connecting and connected sessionsSET GLOBAL audit_log_disable = true;Setting audit_log_disable to true disables the audit log plugin. The plugin is re-enabled when audit_log_disable is set back to false, which is the default setting.[2]- [Under Performance Schema] A new statement metric, CPU_TIME, is now available, enabling you to measure the CPU time spent on a query.This is helpful to troubleshoot performance of SQL statements specially hardware resource utilize by the SQL statement , below is the there table ... Read More

Feed: Planet MySQL; Author: Dave Stokes;  MySQL Server version  8.0.28 was launched a few days ago and without a lot a fanfare. Which is a shame and I wish we had more of a splash for every release.  The release notes are available here. I would like to highlight some of the changes.There are over a hundred bug fixes and big thanks to Hope Lee, Casa Zhang, Øystein Grøvlen, Song Zhibai, Facebook, Hobert Lu, Brian Yue, Zhai Weixiang, Murakami Kohei,  Venkatesh Prasad Venugopal, and the Tencent team.The HighlightsThis release does not have a lot of 'wow' new features but shows a lot of solid work in evolving the product. The new audit_log_disable system ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; For my presentation for the next FOSDEM MySQL Devroom, I needed to create some load. As usual, for this task, what better than sysbench ? The “problem” was that my system was already setup and I used OL7 on the always free Ampere compute instance on OCI. As you may know, this is an ARM architecture (aarch64) and there was not sysbench rpm package available for this OS and architecture. I also wanted to have sysbench compiled and linked with MySQL 8.0 libraries [], []. And this is why I built this package that ... Read More

Feed: Planet MySQL; Author: Marco Tusa; Last April 2021 I wrote an article about Online DDL and Group Replication. At that time we were dealing with MySQL 8.0.23 and also opened a bug report which did not have the right answer to the case presented.  Anyhow, in that article I have shown how an online DDL was de facto locking the whole cluster for a very long time even when using the consistency level set to EVENTUAL. This article is to give justice to the work done by the MySQL/Oracle engineers to correct that annoying inconvenience.  Before going ahead, let ... Read More