This is the second post in a series dedicated to showing how to use the OCI CLI to manage MySQL HeatWave resources. In this post we will discuss how to list MySQL HeatWaves instances in a compartment and how to update some of the information pertaining to the instance. Prerequisites Before you can run any of the examples below, […]

Learn more about basic single-channel replication setup as well as the high-end active-active circular or merge replication setups. In this series we will describe how it works both on high level as well as the detailed technical level.

We are happy to announce a couple of MySQL Meetups happening in Germany and Czech Republic in April and May 2024! Please find the details below and feel free to register for those free of charge MySQL Meetups!  MySQL Meetup Prague, Czech Republic: MySQL Document Store & Helidon Together MySQL Meetup in Berlin & Frankfurt, […]

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