Hey friends over the weekend (Friday actually) I’ve published another issue of my weekly newsletter, OpenLamp.tech. Continue reading for more information…

This issue is full of great curated reads as well as a specific question I’ve asked readers and the community. Looking for some suggestions on planned migrations for upgrades to my WordPress site.

The Newsletter for PHP and MySQL Developers

In this weeks newsletter, there’s information on:

Here’s the full issue for you to read. You can always subscribe (it’s free) and have the weekly issue of OpenLamp.tech delivered directly to your inbox. Just think, no more waiting for me to post it here each Monday.

Visit the sign-up form below to …

In this post I’d like to explain a big optimization in CRC-32C computation, inspired by a paper by Gopal, V., et al.: “Fast CRC computation for iSCSI Polynomial using CRC32 instruction” from Intel, which landed in MySQL 8.0.27 and hugely increases the processing speed (the improvement for ARM64 architectures is more pronounced for reasons explained […]

In this post I'd like to explain a big optimization in CRC-32C computation, inspired by a paper by Gopal, V., et al.: "Fast CRC computation for iSCSI Polynomial using CRC32 instruction" from Intel, which landed in MySQL 8.0.27 and hugely increases the processing speed (the improvement for ARM64 architectures is more pronounced for reasons explained later in the post).

The power of PlanetScale within a beautiful GUI — now you can connect to development branches switch between them and even create deploy requests in Arctype.

The power of PlanetScale within a beautiful GUI — now you can connect to development branches switch between them and even create deploy requests in Arctype.

In a serverless world, traditional databases scale differently. They need a rock solid foundation that Vitess and PlanetScale can provide.

Read the full story

Overview Identity is a critical component of security. The OCI MySQL Database Service (MDS) enables DBAs to leverage existing OCI User Identites and Group Memberships for authentication into MySQL Database Service Instances, providing increased security, centralized management, and ease of use.  Using this feature, an MDS instance can validate a connecting user via the users OCI IAM API Key.   This enables DBAs to centrally manage MDS […]

Identity is a critical component of security. In the latest release of the Oracle Cloud Infrastructure (OCI) MySQL Database Service (MDS) users can be authenticated using OCI IAM (IAM and New! IAM Identity Domains), providing increased security, centralized management, and ease of use. MDS DBAs can leverage an individual user's identity in OCI IAM as well as map to groups of users within OCI IAM and IAM Identity Domains.

Create a PlanetScale database on the Prisma Data Platform; immediately store and query data from the browser

Read the full story

While exporting the table with MySQL native utility, we don’t have any control on the process, and also there will be no progress update as well on the process completion. So when exporting the larger table will consume high resource utilization and also the disk space usage will also be high.

MySQL shell utility will make the process easier. It will export the table and we can import the data back with a parallel thread and also will provide the current progress status on export/import progress.

util.exportTable() utility was introduced in Shell – 8.0.22 version, will export the data in a controlled manner. We can store the data in either local or Cloud Infrastructure Object Storage bucket as well.

We will see about the compression ratio along with the time taken for native MySQL vs Shell utility

Feature :

• Compression
• Progress status
• Supported output …