Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
MySQL cloud services cost comparison: who provides the best value?
According to the Flexera 2023 State of the Cloud Report, 82% of respondents indicated that their top cloud challenge is managing cloud spend, edging out security, which had been the #1 challenge for years. The report states “Seeking to control stubbornly high cloud costs, many organizations have or plan to create a cloud center of […]
Using Aggregate Functions With MySQL Document Store
MySQL Document Store is a JSON document storage solution built on MySQL. One of the advantages of using MySQL Document Store for JSON document storage is when we need to run complex queries for analytics or reporting we can use raw SQL to retrieve data from our JSON documents. But what if we want to view […]
MySQL at FOSSASIA 2023
We are happy to announce our attendance at FOSSASIA 2023, FOSSASIA is hold in Singapore from Thu, Apr 13, 8:30am (SGT) until Saturday, Apr 15, 6:30pm (SGT). You can find our team at the MySQL booth in the expo area and also attend any of the MySQL talks, including a MySQL Keynote as follows: Please […]
New MySQL HeatWave Developer Resources Available
MySQL HeatWave is experiencing great momentum among customers, for example to achieve real-time marketing analytics, or scaling startups while reducing costs. MySQL HeatWave is a fully managed database service, powered by the integrated HeatWave in-memory query accelerator. It’s the only cloud database service that combines transactions, analytics, and machine learning services into one MySQL Database, […]
Book Review: MySQL Crash Course
Today, I would like to present this new book from Rick Silva: MySQL Crash Course – A Hands-on Introduction to Database Development, No Starch Press, 2023. I participated in this project as technical reviewer and I really enjoyed reading the chapters Rick was writing as soon as they were ready… and thank you Rick for […]
MySQL Database Service – find the info: part 5 – HeatWave
In this new article about how to find the info when using MySQL Database Service on Oracle Cloud Infrastructure, we will learn about the query accelerator: HeatWave. With HeatWave, you can boost the performance of your MySQL queries, providing your applications with faster, more reliable, and cost-effective access to data. HeatWave is a high-performance in-memory […]
Viewing MySQL Document Store Queries in MySQL Database Services
In a previous post, we talked about how you can view the underlying queries that are run when we make calls to the MySQL Document Store API. While this solution works well on a local or other on-premise instance of MySQL, it is not a viable option for viewing those same queries on a MySQL Database Service (MDS) instance running […]
MySQL Database Service – find the info: part 4 – connections
As a MySQL DBA, you like to know who is connected on the system you manage. You also like to know who is trying to connect. In this article, we will discover how we can retrieve the information and control who is using the MySQL DB instance we launched in OCI. Secure Connections The first […]
MySQL Database Service – find the info: part 3 – error log
For this third article of the series dedicated on how a DBA can find the info he needs with MySQL Database Service in Oracle Cloud Infrastructure, we will see how we can find the error log. When using MySQL DBAAS, the DBA doesn’t have direct access to the files on the filesystem. Hopefully, with MySQL […]
MySQL Books: MySQL Cookbook 4th Edition
The fourth edition of the MySQL Cookbook, solutions for database developers and administrators, Sveta Smirnova, Alkin Tezuysal, O’Reilly, 2022, is a huge book: 938 pages ! And the least we can say is that you get what you pay for ! This book is an excellent resource for anyone working with MySQL, whether you’re a […]