With so much content online today, how do you find the ‘good stuff’ for a certain topic? While I can’t answer for other niches, if you’re interested in MySQL, PHP, and the LAMP stack, well, you already know the answer. Thank you for reading OpenLampTech!

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 #63, we are looking at great content covering:

• WordPress robots.txt file
• Preventing SQL injections
• 10 books for PHP developers
• Large MySQL tables
• And much much more

I …

Announcing MySQL Shell 8.0.32

An overview of some common MySQL error codes you may run into, what they mean, and how to solve them.

Read the full story

Most of us are lucky that software bugs are a small part of our lives. The ‘things just work’ attitude works for most situations, but occasionally something appears that may seem trivial at first glance may be catastrophic.

A bug appeared in MySQL’s recently released 8.0.32 that really caught my attention. This is a prime example of how a minor bug could have a significant impact on your life and a detrimental impact on your company or project.

The title Wrong result for AVG() OVER(ROWS BETWEEN 1 FOLLOWING AND UNBOUNDED FOLLOWING) is the first thing that caught my eye. A lot of developers heavily use the AVG() function. My first thought was, ‘ut-oh, AVG() being broken is a terrible thing,’ but then I realized it was thankfully not that drastic.

The OVER() clause indicates this is a problem in a Window Function. And odds are, if you are using OVER() for …

We released MySQL 8.0.32 and we would like to thanks all those contributing to MySQL: thank you !

The latest MySQL release has been published on January 17th, 2023. MySQL 8.0.32 contains some new features and bug fixes. As usual, it also contains contributions from our great MySQL Community.

I would like to thank all contributors on behalf of the entire Oracle MySQL team !

MySQL 8.0.32 contains patches from Facebook/Meta, Alexander Reinert, Luke Weber, Vilnis Termanis, Naoki Someya, Maxim Masiutin, Casa Zhang from Tencent, Jared Lundell, Zhe Huang, Rahul Malik from Percona, Andrey Turbanov, Dimitry Kudryavtsev, Marcelo Altmann from Percona, Sander van de Graaf, Kamil Holubicki from Percona, Laurynas Biveinis, Seongman Yang, Yamasaki Tadashi, Octavio Valle, Zhao Rong, Henning Pöttker, Gabrielle Gervasi and Nico Pay.

Here is the …

Announcing MySQL Operator for Kubernetes 8.0.32-2.0.8

Recently Jack asked me for a Sysbench package for OL9.

In this post, you can find the RPM packages of Sysbench 1.1.0 build for Oracle Linux 9, RedHat Enterprise 9 and any RPM compatible system.

Sysbench’s binary is linked with libmysqlclient.so.21 and libssl.so.3.

Here are the two files, one for x86_64 and one for aarch64 (ARM):

sysbench-1.1.0-2.el9.x86_64Download

…

We have produced two new step-by-step videos for installing Galera Clusters either on premise and at Amazon EC2 environments.

The videos can be replayed from links below.

A step-by-step video on how to install Galera Cluster in an Amazon EC2 environment using Galera Manager

A step-by-step video on how to install Galera Cluster in an Amazon EC2 environment using Galera Manager in 15 minutes. With Galera Manager you can manage and monitor your Galera Clusters in Amazon EC2. Galera Cluster in Amazon EC2 is more cost effective and comes with stronger high availability and control in comparison to using Amazon RDS.

WATCH THE VIDEO

A step-by-step video on how to install Galera Cluster on premise using Galera Manager

A step-by-step video on how to install Galera Cluster on premise, on user provided hosts using Galera …

SQL is foundational in web and application programming. There are many websites and resources online to learn SQL. I like these 5 websites and think you will too…

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.

Read the article: 5 Websites To Learn More SQL

Support the OpenLampTech publication with your free subscription. Thank you!

Thank you for reading this post. Please share it …