I wrote this post on MyRocks because I believe it is the most interesting new MySQL storage engine to have appeared over the last few years. Although MyRocks is very efficient for writes, I chose a more generic workload that will provide a different MyRocks use case.

The use case is the TPC-C benchmark but executed not on a high-end server but on a lower-spec virtual machine that is I/O limited like for example, with AWS EBS volumes. I decided to use a virtual machine with two CPU cores, four GB of memory, and storage limited to a maximum of 1000 IOPs of 16KB. The storage device has performance characteristics pretty similar to an AWS gp2 EBS volume of about 330 GB in size. I emulated these limits using the KVM iotune settings in my lab.

<iotune>
     <total_iops_sec>1000</total_iops_sec>
     <total_bytes_sec>16384000</total_bytes_sec> …

MySQL Community Advent Calendar 2022 - how to handle UUIDs with MySQL 8.0

Blip is a new open source MySQL metrics collector, or “MySQL monitor” for short. But isn’t collecting MySQL metrics easy? And don’t we already have some open source MySQL monitors? Let’s take a trip down memory lane…

Blip is a new open source MySQL metrics collector, or “MySQL monitor” for short. But isn’t collecting MySQL metrics easy? And don’t we already have some open source MySQL monitors? Let’s take a trip down memory lane…

Blip is a new open source MySQL metrics collector, or “MySQL monitor” for short. But isn’t collecting MySQL metrics easy? And don’t we already have some open source MySQL monitors? Let’s take a trip down memory lane…

MySQL Community Advent Calendar 2022 - Drupal is a popular open-source content management system (CMS) that is used by businesses, governments, and organizations around the world to build and manage websites. It is known for its flexibility, scalability, and security features.

With MySQL Cluster you can now from version 8.0.31 use transparent data encryption (TDE). Together with the encrypted backup feature it encrypts all data persisted on disk for tables that uses the Ndb storage engine in MySQL. This complements other already existing features that encrypts data at rest in MySQL.

The developer interviews I publish in the OpenLampTech publication always seem to be a big hit. I enjoy them and learn so much from other developers. This week, I’m reposting another recently published fantastic interview.

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 developer interview is with Shawna Brookes, a self-taught full-stack LAMP stack developer. Shawna is making a path all her own and working on a vision for a better web experience.

Don’t miss this interview. Head over to the OpenLampTech publication page and …

MySQL Community Advent Calendar 2022 - Day 20 : Dealing with dates and times can be a tricky task. In this post, we will explore the various ways in which you can store and manipulate date and time data in MySQL 8.0 Document Store.

MySQL HeatWave Database Service is available globally in 34 Oracle Cloud Infrastructure commercial regions. The most recent addition is Chicago in the United States.