Welcome back to this week’s OpenLampTech developer newsletter. I appreciate your interest and reading. Thank you! Get ready for more PHP, MySQL, and LAMP stack content.

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 #62, we have content covering:

• WordPress certification
• SQL constraints
• WooCommerce customizations
• Contact form 7 blocks
• And much much more

Your continued support for the OpenLampTech publication means so much. Show your support with a …

On a busy MySQL server, some key metrics that should be actively monitored include:

Just before FOSDEM, the MySQL Team is organizing a 2 days conferences for and with the MySQL Community. Here is the agenda.

How can we fix a nasty out-of-space issue leveraging the flexibility of Percona Operator for MySQL?

When planning a database deployment, one of the most challenging factors to consider is the amount of space we need to dedicate to data on disk.

This is even more cumbersome when working on bare metal, as it is more difficult to add space when using this kind of solution with respect to the cloud.

When using cloud storage like EBS or similar, it is normally easy(er) to extend volumes, which gives us the luxury to plan the space to allocate for data with a good grade of relaxation. 

Is this also true when using a solution based on Kubernetes like Percona Operator for MySQL? Well, it depends on where you run it. However, if the platform you choose supports the option to extend volumes, K8s per se gives you the …

List of conferences with MySQL during January-May 2023

Using ORACLE APEX to Build and Visualize and Analyse MySQL Database

 Main objective of this blog is to connect MDS with APEX tool and visualize and get insights of MySQL data with low code solution called Oracle APEX. 

Below is the glimpse of topic to be covered in this blog 

1. What is all about Oracle Apex 

2. What are benefit of using Oracle Apex 

3. Installation and Configure Oracle APEX with MDS 

4. Conclusion 

Let’s get started… 

What is all about Oracle Apex ? 

It is database centric web application development framework which you can use to Develop desktop & mobile web apps ,visualize and maintain data, leverage SQL skills and database capabilities. 
Basically,Oracle APEX (APEX) is a low-code development platform that enables you …

How we could  fix a nasty out of space issue leveraging the flexibility of Percona MySQL operator (PMO)  

When planning a database deployment, one of the most challenging factors to consider is the amount of space we need to dedicate for Data on disk.

This is even more cumbersome when working on bare metal. Given it is definitely more difficult to add space when using this kind of solution in respect to the cloud. 

This is it, when using cloud storage like EBS or similar it is normally easy(er) to extend volumes, which gives us the luxury to plan the space to allocate for data with a good grade of relaxation. 

Is this also true when using a solution based on Kubernetes like Percona Operator for MySQL? Well it depends on where you run it, however if the platform you choose supports the option to extend volumes K8s per se is giving you the possibility to do so as well.

…

Recently Oracle released new versions of their software and there are some things of note. MySQL 8.032 is not a major change but you do need to be aware of some changes just in case they have the potential to send you into the court of Murphy’s Law. So let’s look through the release notes to see what is new, changed, and deprecated.

My own comments are in italics and reflect the views of neither Percona nor anyone else. Percona’s release of ‘32 is in the works as we have to add the features Percona provides such as enterprise features (data masking, connection pooling, RocksDB, and much more).

The following items caught my eye as either interesting or ‘I need to add this to my to-do list’.

No more leading dollar signs for table names

> CREATE TABLE $Dollar (i int);
Query OK, 0 rows affected, 1 warning (0.0192 sec)
Warning (code 1681): '$ as the first character of an unquoted identifier' is …

OCI GoldenGate is a fully managed service providing a real-time data mesh platform, which uses replication to keep data highly available and enable real-time analysis. OCI GoldenGate supports several sources and targets, including MySQL and OCI MySQL HeatWave Database Service. In this article, we will find out how the MySQL deployment and connection types make it easier than ever to integrate with MySQL databases.

Fast query performance with MySQL Hypergraph Optimizer for HeatWave