My last blog, Percona Utilities That Make Major MySQL Version Upgrades Easier, detailed the tools available from the Percona toolkit that assists us with major MySQL version upgrades. The pt-upgrade tool aids in testing application queries and generates reports on how each question performs on servers running various versions of MySQL.

MySQL Shell Upgrade Checker is a utility that helps in compatibility tests between MySQL 5.7 instances and MySQL 8.0 upgrades, which is part of the mysql-shell-utilities. The util.checkForServerUpgrade() function checks whether the MySQL 5.7 instance is ready for the MySQL 8.0 upgrade and generates a report with warnings, errors, and notices for preparing the current MySQL 5.7 setup for upgrading to MySQL 8.0.

We can run this Upgrade Checker Utility in the current MySQL 5.7 …

We have another packed issue of OpenLampTech, the newsletter for MySQL and PHP developers, this week. I’m glad to have you here. Thank you!

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

In OpenLampTech issue #41, we are looking at articles covering:

• Is MySQL COUNT(*) slow?
• Symfony Twig UX components
• WordPress vs Drupal
• Top PHP testing tools
• And much much more…

Want Friday’s newsletter delivered to your inbox? Great!

Head over to the …

A few things we have noticed recently when it comes to Galera Manager support requests, that we feel we should address in this blog post.

First and foremost, it is a requirement that you install Galera Manager on a clean host. This means you install the base operating system and nothing else: no Nginx, no Apache, no InfluxDB, etc. The Galera Manager installer (gm-installer) will pull all the requisite packages, set SELinux to permissive during the install, etc. The next release of the gm-installer aims to be less fragile when it comes to this, and will aggressively handle installs on machines that already have software installed on it.

The other common issue is the inability to access ports, generally blocked by a firewall (gm-installer should have fixed this as long as setup is going properly), or some other reason. What gm-installer cannot fix …

 中国加密标准

中国加密标准的SM1、SM2、SM3、SM4、SM7、SM9等。 借助国际加密标准，我们可以利用来自开源的加密库, 例如，最常用和最流行的加密库之一是 OpenSSL。

本文旨在使用有 SMx（中国加密库）的“OpenSSL”库 的 BabaSSL加上 MySQL的TLS设置 来提供一个方法实现 国密的 MySQL。  BabaSSL不是唯一采用 MySQL 的中国加密标准,  来自其他的中国加密供应商/开源的/兼容的/最新的 OpenSSL 库， 也可能会会支持类似的方式来实现MySQL国密TLS加密。

测试环境（用于分享）

1.计算机资源（VM）

2. 操作系统 - 计算 机VM 配备 Oracle Linux 8

3. 通过公用 yum 的存储库安装MySQL 社区版本8.0

4. 使用 BabaSSL 8.3 [ BabaSSL 8.3.2-dev ]。 它基于 2020 年 9 月 22 日的 OpenSSL 1.1.1h 版本

介绍 …

The MySQL Performance Schema is a gold mine of valuable data. Among the many nuggets you can extract from it is an historical report of transactions: how long a transaction took to execute, what queries were executed in it (with query metrics), and idle time between queries. Mining this information is not trivial, but it’s fun and this blog post shows how to start.

The MySQL Performance Schema is a gold mine of valuable data. Among the many nuggets you can extract from it is an historical report of transactions: how long a transaction took to execute, what queries were executed in it (with query metrics), and idle time between queries. Mining this information is not trivial, but it’s fun and this blog post shows how to start.

The MySQL Performance Schema is a gold mine of valuable data. Among the many nuggets you can extract from it is an historical report of transactions: how long a transaction took to execute, what queries were executed in it (with query metrics), and idle time between queries. Mining this information is not trivial, but it’s fun and this blog post shows how to start.

How to inspect and report MySQL transactions using the Performance Schema

How to inspect and report MySQL transactions using the Performance Schema

The training time for MySQL HeatWave ML is on an average 25X faster that competing products such as Redshift ML. Learn how does MySQL HeatWave ML achieve this fast model training performance.