In a previous series, we discussed how we can leverage the TypeScript/JavaScript SDK for Oracle Cloud Infrastructure (OCI) to manage MySQL HeatWave instances. This new series demonstrates how to use the OCI CLI to complete similar tasks. In this post, we will show how to create a MySQL HeatWave instance and retrieve reference information that can help create this new instance. Prerequisites […]

OSCs (Open Source Conferences) are local OS conferences taking place in several towns in Japan, MySQL is being part of every year. After April 2023, OSC returned as a physical event after 3 years as a virtual event. With this comeback, the MySQL team and MyNA(MySQL Nippon Association) were back with several technical sessions and […]

This blog was originally published in January 2023 and was updated in April 2024. MySQL index is a data structure used to optimize the performance of database queries at the expense of additional writes and storage space to keep the index data structure up to date. It is used to quickly locate data without having […]

This blog was originally published in January 2023 and was updated in April 2024. Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. We started looking into the stats of the performance schema. While working, the customer raised two interesting questions: […]

This blog was originally published in June of 2023 and updated in April of 2024.As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for […]

Oracle offers a variety of SDKs for interacting with Oracle Cloud Infrastructure resources. In this post we discuss how to update some propertied of a backup of a MySQL HeatWave instance.

Towards the end of the previous year, we shared the general availability of the Oracle Cloud Infrastructure Database Management for MySQL Heatwave Database Service on Oracle Cloud Infrastructure (OCI). The initial release focused on MySQL OLTP observability. Building upon the existing foundation, we are pleased to announce an extension of its monitoring capabilities encompassing MySQL […]

The initial release focused on MySQL OLTP observability. Building upon the existing foundation, we are pleased to announce an extension of its monitoring capabilities encompassing MySQL HeatWave clusters and Lakehouse-enabled DB Systems. With this enhancement, the Database Management service empowers data professionals with deeper insights and provides proactive monitoring opportunities, ensuring robust performance and informed decision-making.

ProxySQL recently released version 2.6.0, and going through the release notes, I focused on the following:Added support for caching_sha2_password!This is great news for the community! The caching_sha2_password authentication method for frontend connections is now available. This has been a long-awaited feature …Why?Because in MySQL 8, caching_sha2_password has been the default authentication method. Starting from MySQL […]

This post is the sixth in a series that will demonstrate how to view and manage MySQL HeatWave instances in Oracle Cloud Infrastructure (OCI). Oracle offers several SDKs that can be used to view and manage resources in OCI. In this post, we will discuss how to leverage the TypeScript/JavaScript SDK to programmatically update data of a backup of a MySQL HeatWave instance. […]