Percona XtraBackup (PXB) version 8.0.28 supports taking backups for the encrypted tables in your MySQL database using the AWS Key Management Service. For setting up data-at-rest encryption using AWS key management service, please see Configuring Keyring for Encryption Using AWS Key Management Service in Percona Server for MySQL.In this blog post, we will discuss how […]
Leading industry analysts react to MySQL HeatWave’s latest vector store and generative AI new capabilities (private preview), including support for a new VECTOR data type, integration with MySQL Shell and MySQL Shell for VS Code, an automated pipeline to ingest documents into the vector store, several options to use LLMs with MySQL HeatWave, the ability to combine Gen AI with machine learning, and more.
Generative AI is arguably the most important technology trend right now. This fast-moving disruption represents tremendous opportunities for developers to play a critical role in the evolution of almost every new and existing application. MySQL HeatWave makes it easy to build upon your existing skills to become an AI developer with in-database machine learning and support for generative AI and vector store.
Oracle offers a variety of SDKs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to configure and initiate an back up of a MySQL HeatWave instance.
Unleashing Asynchronous MySQL Connectivity with MySQL Connector/Python
Episode #58 of MySQL Shorts in now available!
MySQL Rockstars 2023
The latest episode of MySQL Shorts is available!
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 …