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, all without leaving VS Code. Here is an architecture diagram that gives an idea of how VS Code connects to the HeatWave MySQL DB system.

Fintech (financial technology) companies continue to disrupt the financial services industry. The technology they rely on is paramount; it often determines their ability to deliver an innovative solution exhibiting the performance, scalability, security, reliability, and cost-efficiency that will sway customers. Let’s consider in this blog why 3 fintech startups migrated to HeatWave MySQL, and the results they achieved.

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 helps developers stay focused and productive.

It's incredibly useful to know which tables in your MySQL databases are seeing active changes versus those tables that are more 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.

At Percona, we’ve always been dedicated to providing robust, open source solutions that meet our users’ evolving needs. Percona XtraDB Cluster (PXC) stands as a testament to this commitment, offering a highly available and scalable solution for your MySQL and Percona Server for MySQL deployments. We understand that database high availability is critical for your […]

Efficiently loading CSV data into your MySQL environment is a crucial step for many analytical workloads, especially when dealing with the substantial datasets common in today's data-driven world. Both MySQL Shell's parallel import utility and HeatWave's Auto Parallel Load feature offer robust and effective solutions, each catering to slightly different needs and environments.

MySQL Shell's util.importTable provides a flexible and powerful way to import data from various sources, including local disks and OCI Object Storage, into your standard MySQL tables. It's a developer-friendly tool that offers granular control over the import process.

For those leveraging the analytical power of MySQL HeatWave, the sys.heatwave_load stored procedure, particularly with its Auto Parallel Load capabilities, simplifies the often complex task of getting data into the in-memory columnar store.

The post …

Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.42-26.23 (release notes, download), with Galera replication library 4.23 (release notes, download) implementing wsrep API version 26. It also includes Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.5-26.23 (release notes, …

meetups&events with 30Y ann.celebration

Managing farms of MySQL servers under a replication environment is very efficient with the help of a MySQL orchestrator tool. This ensures a smooth transition happens when there is any ad hoc failover or a planned/graceful switchover comes into action. Several configuration parameters play a crucial role in controlling and influencing failover behavior. In this […]

HeatWave MySQL continues to evolve, bringing powerful enhancements that bolster security, improve backup retention, and streamline partition management. Over the last two quarters (March–June 2025), several notable updates have been introduced, enhancing security controls, optimizing data management, and delivering greater flexibility for developers and businesses alike.