If you need to know how your MySQL database is performing, or maybe you want to move your MySQL on-premise database to MySQL Heatwave on Oracle Cloud Infrastructure (OCI), this post will explain how to manually collect metrics on connections, resource usage, query performance and database characteristics.  This post doesn’t contain every single possible command you […]

HeatWave MySQL Database Audit brings powerful enterprise-grade auditing capabilities to the cloud, allowing organizations to monitor and track database activity for security, compliance, and performance optimization. With features like customizable filters, real-time monitoring, minimal overhead, and seamless integration with MySQL tools, it enables administrators to log critical operations, detect threats, and maintain detailed records for regulatory requirements. The audit system is easy to set up, supports granular activity tracking, and provides actionable insights directly through the SQL interface.

The post HeatWave MySQL Database Audit first appeared on dasini.net - Diary of a MySQL expert.

Choosing the correct shape for a MySQL HeatWave instance in Oracle Cloud Infrastructure (OCI) when migrating your on-premise MySQL database involves assessing your current workload requirements and matching them to the available MySQL HeatWave shapes. A “shape” in (OCI) defines the compute resources (CPUs, memory, maximum network bandwidth, etc.) allocated to your MySQL Database System […]

The MySQL Operator for Kubernetes supports the lifecycle of a MySQL InnoDB Cluster inside a Kubernetes Cluster. This goes from simplifying the deployment of MySQL Server and MySQL Router instances, including management of TLS certificates and replication setup, over ongoing management of those as well as support for backups, be it one-of backups or following […]

MySQL Operator for Kubernetes? The MySQL Operator for Kubernetes supports the lifecycle of a MySQL InnoDB Cluster inside a Kubernetes Cluster. This goes from simplifying the deployment of MySQL Server and MySQL Router instances, including management of TLS certificates and replication setup, over ongoing management of those as well as support for backups, be it […]

In today’s hyper-competitive landscape, organizations across industries—from Automotive, Aerospace, Heavy Machinery, Semiconductors, Oil and Gas to Consumer Electronics—continue to invest heavily in high-value software assets for Engineering, R&D, and Manufacturing. However, while these assets are indispensable to innovation and operations, one major challenge persists: understanding how effectively they’re being utilized. Bridging the Utilization Gap Nibana […]

In the rapidly evolving world of mobile finance, ensuring secure, reliable, and cost-effective solutions is paramount. Union Mobile Financial Technology Co., Ltd. (UMF), founded in 2003 by China Mobile and China UnionPay, has become a global leader in mobile financial solutions. With its innovative technology and professional services, UMF serves over 140 financial institutions, 3,600 […]

Introduction In today’s data-driven world, security and compliance have become top priorities for businesses, particularly in the financial sector. Parkson Credit, a leading provider of credit financing solutions and payment services, understands the critical importance of safeguarding sensitive information while maintaining regulatory compliance. By leveraging the powerful MySQL Enterprise Edition, Parkson Credit has successfully addressed […]

Your MySQL databases are the backbone of your operations, housing invaluable and often sensitive information. But with increasing cyber threats and evolving regulatory landscapes, securing them can feel like an overwhelming challenge. Can you build a security program that’s not just compliant, but truly resilient against the ever-present dangers of data breaches and cyberattacks? The […]

During the last MySQL & HeatWave Summit, Wim Coekaerts announced that a new optimizer is available and is already enabled in MySQL HeatWave. Let’s have a quick look at it and how to use it. The first step is to verify that Hypergraph is available: MySQL > SET SESSION optimizer_switch='hypergraph_optimizer=on'; ERROR: 3999 (42000): The hypergraph […]