At Oracle Cloud World 2023, we'll cover the architecture of the fully-managed Oracle MySQL HeatWave database service and the most important features for transactional applications.

How about seeing live how the performance of MySQL HeatWave Lakehouse compares to Snowflake, Amazon Redshift, Google BigQuery, and Databricks? Don’t miss the demos at the AMD booth at Oracle CloudWorld - Tuesday, Sept 19, and Wednesday, Sept 20. Plus, you can win a great prize!

In the recent past, I shared in a Reddit post that I was searching for developers who were interested in participating in a text-based interview for the OpenLampTech publication.

I am super-excited that Will Earp agreed to participate in this developer interview for the OpenLampTech readers.

Read more >>>: Developer Interview with Will Earp – Substack Repost

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For …

Interested in machine learning? Check out those MySQL HeatWave sessions at Oracle CloudWorld to learn how you can benefit from and make the most of in-database ML. They include talks featuring customers such as NVIDIA, hands-on labs, demos, and more.

Are you looking to build secure applications and secure your data with MySQL Enterprise Edition (EE)? If so, you're in luck!

According to the Online Trust Alliance, 93% of security breaches are preventable! I hope that alone will movitate many to come attend my talk.

Please come and check out my talk at Oracle CloudWorld on September 21, LRN2387.

Are you planning an upgrade for your Percona XtraDB Cluster (PXC)? Upgrading to PXC 8.0 can be a smooth process, but sometimes challenges arise that require careful troubleshooting. In this…

The post How to fix Percona XtraDB Cluster 8.0 Upgrade issues first appeared on Change Is Inevitable.

The content keeps dropping and I keep publishing OpenLampTech each and every week. We are nearing the 100-issue milestone. Thanks to you, the OpenLampTech publication is already a success.

Continue reading >>>: OpenLampTech issue #94 – Substack Repost

Custom WooCommerce and Shopify Solutions

Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!

Learn More

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.

…

This blog was originally published in February 2019 and was updated in September 2023.

Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. MySQL is one of the most popular database management systems, playing a pivotal role in the functionality and performance of web applications.

In today’s blog, I’ll take a look at MySQL collation and charset settings to shed light on how they impact the performance of web applications and how to use them to effectively communicate with your users.

Understanding Character Sets and Encoding in MySQL

Character sets and encoding in MySQL play a vital role in how data is stored and retrieved in a database. A character set is a collection of characters with unique representations for each character, such as letters, numbers, and symbols, that define how data is …

This blog was originally published in November 2021 and was updated in September 2023.

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly.

Here, we first cover the basics of MySQL Triggers, and then we take a deeper dive, exploring their impact on memory usage and providing strategies to optimize MySQL server performance.

What is a Trigger in MySQL?

A Trigger in MySQL is a database object that plays a pivotal role in database management. It is essentially a set of instructions or a program that is executed automatically in response to specific events or actions occurring within the …

For developers building out an application, a transactional datastore is the obvious and proven choice, but with success comes scale limitations. A monolithic database works well initially, but as an application sees growth, the size of its data will eventually grow beyond what is optimal for a single server. Implementing read replicas can improve your performance but will likely add lag between your primary and your replicas, leading to performance or correctness issues for your application. These complexities can sometimes require major architectural changes, leading to a suboptimal user experience and difficult compromises, having to choose between application performance or data consistency. Scaling write traffic is even more challenging; for example, even the largest MySQL database will see performance issues at a certain point. Horizontal sharding This is not a new challenge; organizations have faced it for years, and horizontal sharding is one …