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

Oracle HeatWave is a fully managed cloud database service that integrates with MySQL, combining transactions, analytics, machine learning, and generative AI capabilities. It features an in-memory query accelerator for real-time analytics, eliminating the need for ETL processes to separate databases. Available on Oracle Cloud Infrastructure (OCI), AWS, and Azure, HeatWave automates tasks like backups and […]

HeatWave is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. It 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 Cloud Infrastructure (OCI), Amazon Web Services […]

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

HeatWave MySQL is the only fully managed MySQL database service that combines transactions, analytics, machine learning, and GenAI services, without ETL duplication. It 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 Cloud Infrastructure (OCI), Amazon Web Services (AWS), and Microsoft Azure. This […]

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

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