Worldwide meetups - Recap/Report

Oracle Academy, Oracle’s global philanthropic educational program, is open to educators around the world to advance technology education, skills, innovation, and diversity and inclusion. In this post, we highlight some of the MySQL resources that are available for Oracle Academy Members.

Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the system’s stability and performance. MySQL 8 introduces Error Log Filtering as a mechanism to fine-tune the error log, allowing administrators to focus on the most critical issues. By assigning priorities to different error types, administrators […]

Long-time web developer Christian Olear shares an insightful developer interview with the OpenLampTech newsletter readers.

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.

Spanning two-plus decades, Christian Olear has programmed using Laravel, the Zend framework, and Symfony to name just a few, in addition to vanilla PHP.

Head on over and grab your free subscription to OpenLampTech to read this developer interview and more.

Thank you for reading this post. Please share it with someone else …

In this blog post, discover how to deploy WordPress on OCI using MySQL HeatWave Dabase Service with multiple replicas to spread the read traffic without having to change anything in WordPress and using MySQL Router 8.2.0's transparent R/W splitting feature.

Some time ago, we saw how we could deploy WordPress on OCI using MySQL HeatWave Database Service with Read Replicas. We had to modify WordPress to use a specific plugin that configures the Read/Write Splitting on the application (WordPress): LudicrousDB.

Today, we will not modify WordPress to split the Read and Write operations, but we will use MySQL Router 8.2.0 (see [1], [2], [3]).

Architecture

The …

MySQL in Dec-Feb24

MySQL HeatWave is a fully managed database service, powered by the HeatWave in-memory query accelerator. It’s the only cloud service that combines transactions, real-time analytics across data warehouses and data lakes, and machine learning in one MySQL Database—without the complexity, latency, risks, and cost of ETL duplication.

In this Blog provides an overview, how to migrate from GCP Cloud SQL for MySQL into OCI MySQL Heatwave using MySQL Shell.

In Percona Managed Services, we manage Percona for MySQL, Community MySQL, and MariaDB. Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’s pt-table-checksum and pt-table-sync to check the data drift between primary and replica servers and make […]

To mitigate SQL injection attacks, queries that use user-provided input should be parameterized. In this post, we will discuss how to use named and unnamed parameters in a Node application. Finally, we show how to use the SQL Template Tag module to create unnamed placeholders and the related values in a single statement.