Announcing MySQL HeatWave Migration Assistant — the newest way to move MySQL workloads to Oracle Cloud Infrastructure (OCI) with ease! Migrating critical databases to the cloud is often viewed as complex. That changes with the launch of the MySQL HeatWave Migration Assistant. This new tool is purpose-built to help organizations move their on-premises MySQL databases […]

Welcome back, data explorer! You now know the basics of MySQL’s structure. But how do you actually step into this wonderland of tables and data? That’s where the MySQL Shell comes in—think of it as your trusty librarian, always ready to fetch books, organize sections, or gently shush unruly queries. What Is MySQL Shell? MySQL […]

Monitoring MySQL replication is key to maintaining data consistency, troubleshooting issues, and ensuring smooth failover across environments. It helps confirm that your replication topology is running as expected, assists in identifying delays or failures, and gives control to manage increasingly complex deployments. Understanding MySQL Replication types: Asynchronous replication can be configured to establish pathways for […]

Welcome to the final post in our MySQL Routing Guidelines series. In the first two posts (Smarter Query Routing with MySQL Routing Guidelines and MySQL Routing Guidelines: A Practical Guide to Management and Configuration), we introduced the concept of Routing Guidelines and showed how to configure and manage them in MySQL Shell. Now, we’re going […]

In the previous post, we explored how the MySQL Shell extension for Visual Studio Code brings database development directly into your editor. In this follow-up, we’ll walk through how to connect to a HeatWave MySQL database which is hosted in the cloud on Oracle Cloud Infrastructure (OCI) and how to browse schemas and run queries, […]

Modern development demands tools that minimize context switching and improve efficiency. The MySQL Shell extension for Visual Studio Code makes that possible by bringing powerful database interaction directly into the developer’s workspace. With seamless support for connecting, querying, and scripting in SQL, Javascript, and TypeScript – all inside the familiar VS Code environment – it […]

Database Management on Oracle Cloud Infrastructure (OCI) continues to evolve, enabling MySQL users to gain deeper visibility and manage their HeatWave and on-premises (External) MySQL DB systems. In our previous blogs, we introduced how Database Management supports monitoring for both HeatWave and External MySQL DB systems.  We’re now expanding its capabilities with a new set of […]

We’re thrilled to announce the general availability of the HeatWave REST Service – a powerful, fully managed cloud service that lets you instantly create RESTful API endpoints directly from your HeatWave MySQL databases, without writing a single line of backend code. HeatWave REST Service Highlights     Why We Built the HeatWave REST Service Modern development stacks are […]

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

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