It’s incredibly useful to know which tables in your MySQL databases are seeing active changes versus those tables that are less frequently updated or entirely static. To do this, we need to examine DML (Data Manipulation Language) activity—specifically, updates, inserts, and deletes. MySQL offers various mechanisms to gather this information. This blog will explore two primary […]

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 […]

Security is a foundational principle for cloud deployments, especially when dealing with mission-critical workloads like those managed by HeatWave MySQL. As applications and environments scale, fine-grained network control becomes critical not just for protecting sensitive data, but also for isolating systems, enforcing boundaries, and minimizing lateral movement within a Virtual Cloud Network (VCN). Network Security […]

In today’s fast-paced digital landscape, uninterrupted availability of IT infrastructure isn’t just a luxury—it’s a fundamental necessity for businesses to thrive. Downtime, whether planned or unplanned, carries a hefty price tag, impacting everything from customer relationships to competitive edge. This is where the MySQL Reference Architectures for High Availability steps in, offering a robust framework […]

HeatWave is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. HeatWave also includes HeatWave Lakehouse, allowing users to query data stored in object storage, MySQL databases, or a combination of both. Users can deploy HeatWave MySQL–powered apps on a choice of public clouds: Oracle […]

MySQL Group Replication is a powerful feature that allows you to create a fault-tolerant and redundant database system, ensuring high availability and data consistency across multiple servers. The primary goal of this technology is to provide automatic failover and improve the overall system’s reliability. If one of the servers in the group fails, the others […]

In previous posts, I discussed how to use MySQL Shell to dump and load data using a multithreaded process. When using util.dumpInstance(), we create a dump of all the data and schema changes, even those that have already been dumped previously. But what if we only want to dump the data and schema changes that have occurred since the last dump? In […]