Database Management is designed to help you prevent potential outages in your key applications by providing performance diagnostics capabilities that simplify diagnosing performance issues for administrators and ensure quicker resolution of performance bottlenecks. The service also provides advanced performance management capabilities to proactively detect and identify the root cause of SQL performance issues. 

The latest release of MySQL (October 25th, 2023) is the second Innovation Release of the most popular Open Source database.

This new evolution release brings us ever closer to the very first MySQL LTS Release!

This new Innovation Release already contains contributions from our great Community. MySQL 8.2.0 contains patches from Meta, Nikolai Kostrigin, Meng-Hsiu Chiang (Amazon), Richard Dang, Shaohua Wang, Hao Lu, Wen He (Tencent), Yin Peng (Tencent) and Daniël van Eeden.

Let’s have a look at all these contributions:

Server Compiling

• #111549 – Made additional improvements to WITH_ZLIB functionality – Nikolai Kostrigin
• #111467 – Building with WITH_ZLIB=”system” would break the MySQL build as it failed to find …

This blog post explains changes done around cipher support in MySQL 8.2.0 release.

This blog post describes how authentication_webauthn works.

PHP dev tools | OLT developer interview | WooCommerce product data management | Drop SQL columns | Laravel stack trace. OpenLampTech is a media and content source for MySQL, PHP, and the LAMP stack.

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.

If you’re not yet subscribed, grab your free subscription today and join the OpenLampTech community.

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

…

OpenLiteSpeed is a lightweight and open-source version of the LiteSpeed Server developed by LiteSpeed Technologies. It supports Apache Rewrite rules, HTTP/2 and HTTP/3 along with TLS v1.3 and QUIC protocols. In this tutorial, we will learn how to install an OpenLiteSpeed Server on a Debian 12 machine.

In MySQL 8.2, a significant enhancement has been introduced to MySQL Router. This improvement enables MySQL Router to intelligently differentiate between read and write queries and efficiently route them based on their nature.

MySQL Server 8.2.0, 8.0.35 and 5.7.44 are now available for download.  These are the latest General Availability (GA) releases as of October 24, 2023.

Welcome to this amazing SQL programming test that will help anyone deeply interested in working with databases. This test will help you assess your strengths and find gaps in your SQL skills. Ultimately, you’ll know which part of the SQL you should focus on. Test Your SQL Programming Skills Before you delve into the questions […]

Source

Have you heard about MySQL replication but aren’t sure exactly why you should care? Having multiple servers for any workload is typically considered best practice. After all, a workload split across multiple servers helps balance out the performance of any application. When it comes to working with your database, though, the benefits may not be as clear. In this article, you’ll learn about five real-world use cases for implementing MySQL replication. What is MySQL replication? Before we get into its use cases, let us briefly describe what MySQL replication is. MySQL replication is a process that is used to keep multiple MySQL servers in sync. When you first set up a MySQL environment, it is typically with a single server to run your databases. One approach to scaling your database environment is to configure additional servers to contain copies of your database (replicas) that match the primary MySQL server (source). As data is updated, written …