Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Introducing new MySQL HeatWave features for lower cost and better performance
Introducing new MySQL HeatWave features for lower cost and better performance Customers with various sizes of workloads want to use MySQL HeatWave for query acceleration. MySQL HeatWave is addressing the wide spectrum of MySQL workloads with the following new features: HeatWave can now address workloads from less than 50GB to 64TB with the best […]
MySQL HeatWave on AWS – New and upcoming capabilities in March and April 2023
MySQL HeatWave on AWS – New and upcoming capabilities in March and April 2023 HeatWave Scale Out Data Management MySQL HeatWave on AWS now provides an optimized storage layer built on S3 to store the HeatWave in-memory hybrid columnar representation of the data. This allows data to be reloaded to each HeatWave node independently […]
Time Series Forecasting with MySQL HeatWave
Time series forecasting is a technique for predicting future values of key metrics based on past events. It involves using time ordered events from past as well as other variables to predict future values. Multivariate time series forecasting can predict multiple time ordered variables, where each variable is dependent on its past value as well […]
Interactive console for machine learning in MySQL HeatWave
Machine learning has become pervasive, and businesses are scrambling to introduce machine learning and AI based functionality in their products. The biggest challenge is shortage of people with technical knowledge to deliver a machine learning based project. Now, with the interactive console for machine learning in MySQL HeatWave (aka MySQL HeatWave AutoML), even business analysts […]
New MySQL HeatWave capabilities for machine learning and multicloud
At the MySQL Summit Day in Redwood Shores, California, we’re announcing new MySQL HeatWave AutoML capabilities, expanding the machine learning use cases for MySQL HeatWave, as well as new capabilities for MySQL HeatWave on AWS, and price-performance improvements for MySQL HeatWave on OCI. New MySQL HeatWave AutoML capabilities MySQL HeatWave provides native, in-database machine learning. […]
MySQL Database Service – find the info: part 2 – disk space utilization
This article is the second of the new series dedicated on how a DBA can find the info he needs with MySQL Database Service in Oracle Cloud Infrastructure. The first article was dedicated on Backups, this one is about Disk Space Utilization. This time we have two options to retrieve useful information related to disk […]
MySQL Database Service – find the info: part 1 – backups
In this new series of articles we will explore the different sources of information available when using MySQL Database Service on OCI to effectively perform your daily DBA job. Of course there is way less things to take care of, like backups, upgrades, operating system and hardware maintenance, … But as a serious DBA, you […]
MySQL Books: SQL Antipatterns, Volume 1
I recently had the chance to read in preview Bill Karwin‘s new book: SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming. This book is a rework of Bill’s best seller from 2010. The new book can be considered as the second edition and is updated with Bill’s latest observations about common mistakes. The […]
Using OCI Alarms to Detect When a MySQL Instance Is Unavailable
MySQL Database Service (MDS) is a fully-managed Oracle Cloud Infrastructure (OCI) service that allows you to harness the ease and power of MySQL in the cloud. Since MDS is deployed to OCI, we can use OCI Alarms to send notifications when a MySQL instance enters a state that is, shall we say, less than favorable. In this post, we will […]
MySQL Books: Efficient MySQL Performance
Today, the book I would like to recommend is Efficient MySQL Performance – Best Practices and Techniques, Daniel Nichter, O’Reilly, 2021. Best Practices and Techniques is a comprehensive guide to optimizing the performance of MySQL databases. Whether you’re a developer, database administrator, or system administrator, this book can provide valuable insights and techniques to help […]