Episode #58 of MySQL Shorts in now available!

During the MySQL Belgian Days (formerly known as preFOSDEM MySQL Days) in Brussels on 1-2 February 2024, we, the MySQL community team, have for the second time awarded MySQL Rockstars to some members of the MySQL community. The MySQL Rockstars Award is given to those community members who have contributed their work, enthusiasm and energy […]

MySQL Rockstars 2023

The latest episode of MySQL Shorts is available!

The latest Episode of MySQL Shorts is now available! Check out Episode 57 on the MySQL YouTube Channel to learn how to restore a MySQL HeatWave instance to a specifci point in time.

The latest Episode of MySQL Shorts is now available! Check out Episode 58 on the MySQL YouTube Channel to learn how to create a High Availabiltiy MySQl HeatWave instance.

This post is the fifth in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to programmatically create a backup of a MySQL HeatWave instance and create […]

In the Python programming landscape, adopting asynchronous programming has led to a new way of efficiency and responsiveness. At its core is the Python asyncio library, which enables the writing of concurrent code. Asyncio in Python enables non-blocking I/O operations, empowering developers to create applications that seamlessly handle multiple tasks concurrently. This approach has become […]

Volume Expansion, a feature that became generally available since Kubernetes version 1.24, allows users to increase the capacity of their Persistent Volumes and underlying storage within Kubernetes. There is no need to use clouds’ UI or APIs to do that anymore. In our Operators, we use Stateful Sets – a Kubernetes resource that was designed for […]

Data loss or corruption can be daunting. With MySQL point-in-time recovery, you can restore your database to the moment before the problem occurs.

This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity.

Key Takeaways

• MySQL Point in Time Recovery (PITR) enables restoration to a specific point after a full backup. It relies heavily on binary log files to record the incremental changes needed for recovery.
• Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. Monitoring and managing binary log activities, such as file retention, are essential for effective recovery.
• Executing PITR requires …