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.

As all developers know, one of the most critical parts of any project is tracking database changes (or migrations). These changes will likely need to be applied in a particular order, and they need to be applied to every environment in the development workflow. We should also be able to roll back these changes should […]

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 …

Oracle CloudWord is just around the corner…if you haven’t registered yet, you can still join us September 18-21, in Las Vegas. In my previous blog, I highlighted “The Future of Scale-out Data Processing with HeatWave Lakehouse” keynote. If you have an interest in MySQL, in machine learning, or in processing data in object storage, I […]

Oracle Cloudworld 2023 includes many MySQL HeatWave sessions that you may not want to miss, such as use cases from Toyota, Aiwifi, Efisys, and Credit Guarantee Fund Trust for Micro and Small Enterprises (CGTMSE).