Sharing an example of how to do audit log archiving to table and thereafter to dump the archived table to Object Storage using MySQL Shell utility

The 'Always Free' tier of Oracle Cloud has a new offering - HeatWave MySQL. In this post, we will discuss how to spin up a new always-free HeatWave MySQL instance and connect to it via an alway-free compute instance.

Auditing is one of the key concerns with Security & Compliance for many organizations.   

This article is written to share a tutorial how to do audit log archiving by reading the audit log.  The audit archiving process is to read the audit log using audit_log_read function provided to access to the audit.   The data once is archived to Table "audit_archive.audit_data" and the table is renamed to "audit_data_<timestamp>" accordingly.  The table is dumped to OCI Object Storage bucket using mysql shell utility.  The tutorial is for demo purpose only.   

MySQL Enterprise Audit is the feature allowing audit to be implemented.   For managed service of "MySQL", namely HeatWave Service on Oracle Cloud Infrastructure,  Enterprise Audit is installed.   If running MySQL Enterprise Edition on your compute VM, please refer to the documentation on how to install MySQL …

On the cusp of Oracle Cloud World 2024, we’d like to call attention to some recent enhancements that are now available for Heatwave MySQL. These enhancements deliver improvements in availability, disaster recovery, performance, manageability and operability, and developer productivity.

This long article aims to provide you with the instructions and tools to migrate your production database from your current environment to a solution based on Percona Everest (MySQL). Nice. You decided to test Percona Everest and found that it is the tool you were looking for to manage your private DBaaS. The easiest part […]

HeatWave MySQL – new capabilities for OLTP workloads HeatWave MySQL is a robust and time-tested ACID compliant database which is ideal for transactional processing, mixed workloads, real-time analytics, and machine learning where the data is stored inside MySQL database. On the cusp of Oracle Cloud World 2024, we’d like to call attention to some recent […]

This new AI tech, called generative AI (or GenAI), can dive deep into what people are saying and tell us if they’re feeling positive, negative, or neutral.
Let’s see how HeatWave GenAI, can help you to enhance your understanding of customer sentiment, improve decision-making, and drive business success.

The post HeatWave GenAI: Sentiment Analysis Made Easy-Peasy first appeared on dasini.net - Diary of a MySQL expert.

Oracle HeatWave provides automated, integrated, and secure generative AI and machine learning in one fully managed cloud service for transactions and lakehouse-scale analytics. Its scale-out architecture is designed to very effectively process and query data in various formats in object storage and MySQL Database. With solutions for different workloads, HeatWave enables customers to: Simplify secure […]

Oracle HeatWave provides automated, integrated, and secure generative AI and machine learning in one fully managed cloud service for transactions and lakehouse-scale analytics. New features are available across the HeatWave portfolio—on both OCI and AWS.

Some users, myself included, have noticed that their MySQL error log contains many lines like this one: Where does that error come from? The error MY-010914 is part of the Server Network issues like: Those are usually more problematic than the ones we are covering today. The list is not exhaustive and in the source […]