When it comes to backups, there are several options for saving backup files. You can choose to save them locally on the same server, stream them to different servers, or store them in object storage. Percona XtraBackup facilitates streaming through the use of an auxiliary tool called xbcloud.

STDOUT Datasink

This diagram displays the process of streaming a backup to object storage utilizing the current STDOUT datasink:

• XtraBackup spawns multiple copy threads. Each one will be reading a chunk of data from a specific file.
• Each copy thread will write the chunk of data to a pipe (aka STDOUT).
• Xbcloud will have a red thread that will be responsible for reading each chunk of data from STDIN. This chunk will be uploaded to object storage utilizing an async request, and a callback will be added to an …

I was attempting to download the MySQL slow query logs to perform a slow query review. In this blog we will explore the issue I faced while downloading the slow…

The post How to overcome Throttling and Rate Exceeded Errors in DownloadDBLogFilePortion first appeared on Change Is Inevitable.

The MySQL Server 8.1.0 release was published on July 18th, 2023 and it introduces the new MySQL Configurator tool for MySQL Server 8.1 and higher on Windows. The MySQL Configurator application for Windows configures a MySQL Server installation in a series of basic steps. It can both configure and reconfigure the corresponding MySQL Server installation. […]

This blog post introduces the new MySQL Configurator tool, available starting with MySQL Server 8.1.0.

Today, we announced the general availability of MySQL HeatWave Lakehouse and new capabilities in MySQL Autopilot that enable organizations to efficiently query data from object store using standard SQL syntax and without requiring database tuning expertise. Data in object store can be in a variety of file formats like CSV, Parquet or export from databases […]

MySQL HeatWave Lakehouse is a fully managed database service, powered by a highly parallel in-memory query accelerator. It is the only cloud database service that combines transactions, analytics, automatic machine learning and now querying object store into one MySQL database, delivering real-time, and secure analytics without the complexity, latency, and cost of ETL duplication.

This blog post shows how to get started with MySQL HeatWave Lakehouse, create a cluster, run Autopilot to infer your schema and estimate capacity, and finally load and query data.

MySQL HeatWave Lakehouse Makes Waves among Leading Industry Analysts   Have you heard the news? MySQL HeatWave Lakehouse is now generally available. The announcement of lakehouse capabilities continues to cement MySQL HeatWave’s position as the only cloud service that provides transaction processing, machine learning, machine learning-based automation,  real-time analytics, —and now data lake querying — […]

Making waves as an industry first, MySQL HeatWave Lakehouse enables querying data in object storage at speeds as fast as querying data inside the database while delivering record-setting performance and price-performance on a 500TB workload.  

Thank you for your time and for reading OpenLampTech. Let me know what you want to see more of in the weekly publication. Enjoy issue #87.

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.

In OpenLampTech issue #87, there are great reads covering:

• MySQL datetimes versus timestamps
…