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 …

MySQL HeatWave Lakehouse has been praised by leading industry analysts as “an unprecedented innovation in cloud data services.” Yet, you may be wondering “why should this matter to me and my organization?” This blog aims to answer that question.

On any software project, one important piece is managing database changes. Tools such as Knex can make this process less daunting. This post talks about using Knex CLI to manage MySQL database migrations and how to seed your database with data.

With the rise and widespread use of low-code tools, Australian-based Five has created an IDE that enables developers to rapidly build out and deploy web applications on a MySQL database.

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.

I’m publishing more and more developer and founder text-based interviews in the OpenLampTech publication. I recently …