The latest MySQL release has been published on April 18th, 2023. This new version of MySQL brings a new service that I’m excited to play with: Performance Schema Server Telemetry Traces Service. MySQL 8.0.33 contains bug fixes and contributions from our great MySQL community. I would like to thank all contributors on behalf of the […]
Apr
21
2023
Apr
21
2023
MySQL 8.0.33 has been released, thanks to all the developers who contributed to it !
Apr
21
2023
MySQL has InnoDB data encryption, and Galera Cluster has supported it since it appeared in the main server. The one thing that was not covered was the encryption of the Galera Cache (the galera.cache file).
Here is a simple extract from the binlog.000001 files.
strings binlog.* |grep Custom |wc -l 10000 strings galera.cache |grep Custom |wc -l 10000
strings galera.cache|tail -10 Customer9100 Customer9099 Customer9098 Customer9097 Customer9096 Customer9095 Customer9094 Customer9093 Customer9092 Customer9091
You need to edit your /etc/my.cnf to include:
early-plugin-load=keyring_file.so keyring_file_data=/var/lib/mysql-keyring/keyring
Note that in this example we are using the keyring_file plugin, which stores keyring data in a file on the local server host. This is not intended for regulatory compliance. You need to use a key management server that protects encryption keys in key vaults or hardware …
[Read more]
Apr
20
2023
The new JSON/Relational Duality support brings the benefits of both - relational tables and JSON documents - to the MySQL REST Service (MRS).
Apr
20
2023
As we approach end of life for MySQL 5.7 later this year, many businesses are currently working towards upgrading to MySQL 8. Such major version upgrades are rarely simple, but thankfully there are tools that can help smooth the process and ensure a successful upgrade.
It should be noted that while the technical aspects of the upgrade process are beyond the scope of this blog post, it is crucial to create a testing environment to verify the upgrade before proceeding to upgrade your production servers, particularly with MySQL 8.
As there is no procedure for downgrading from MySQL 8 other than restoring a backup, testing and validation are more critical than previous major version …
[Read more]
Apr
20
2023
Everything you need to know about MySQL as an application developer, with a focus on improving query performance. After covering the high-level overview, we’ll put the learnings to the test with some hands-on examples.
Apr
19
2023
According to the Flexera 2023 State of the Cloud Report, 82% of respondents indicated that their top cloud challenge is managing cloud spend, edging out security, which had been the #1 challenge for years. The report states “Seeking to control stubbornly high cloud costs, many organizations have or plan to create a cloud center of […]
Apr
19
2023
When it comes to using MySQL in the cloud, customers have numerous options considering that all major cloud providers offer a MySQL cloud service. Find out who provides the best value.
Apr
19
2023
The KubeCon around the Kubernetes technology was one of the events I dreamed to attend since I’m focusing on the CloudNative solutions. I had the great opportunity to attend the KubeCon & CloundNativeCon in Amsterdam with my colleague Benoît Entzmann.
There is now CNCF-hosted Co-located events adding more topics and interesting sessions. This is community-driven, vendor-neutral events hosted and managed by the CNCF. ArgoCD, Cilium, Linkerd have now their own conference. Here is the list of CNCF-hosted Co-located events.
Unfortunately, all the above events were already sold out when we decided to come at the KubeCon.
During the 1st day Keynote, Chris Aniszczyk CTO of the CNCF mentioned that for this year, the increase of the number of participants was just amazing reaching more than 10’000 people. The number of CNCF projects also increased a lot. I feel that the main message of this Keynote is that …
[Read more]
Apr
19
2023
MySQL released version 8.0.33 on April 18th, featuring some attention-catching features. This blog post is a quick review of the release notes looking for the exciting items, and comments in italics are solely my own.
User-defined collations are now deprecated and will be removed in a future version. This is probably not a show-stopper for most and probably a scary situation for those dependent on them as there may not be an alternative. Hopefully, UTF8MB4 is good enough.
The Performance Shema now has a Server Telemetry Traces service. This interface provides plugins and components a way to retrieve notifications related to SQL statements’ lifetime. We are directed to the Server telemetry traces service section in the MySQL Source Code documentation
The SSL library has been updated to OpenSSL version …
[Read more]