Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Use OCI GenAI, and MySQL HeatWave to interact with your WordPress content
MySQL HeatWave 9.0 was released under the banner of artificial intelligence. It includes a VECTOR datatype and can easily process and analyze vast amounts of proprietary unstructured documents in object storage, using HeatWave GenAI and Lakehouse. Oracle Cloud Infrastructure also provides a wonderful GenAI Service, and in this post, we will see how to use […]
MySQL Shell CLI Integration
Over the last few years, I have become quite smitten with MySQL Shell. For those who may not be familiar with MySQL Shell, it is a new(ish) command line interface (CLI) for connecting to and managing MySQL instances. During a recent episode of Inside MySQL: Sakila Speaks, Fred and I talked to Miguel Araujo about many of the helpful […]
PHP and MySQL 9
As you can read in my previous post related to MySQL 9 and authentication, the old mysql_native_password plugin has been removed. In that post, I showed an example using PHP 7.2, the default version in OL8. If you are using PHP and you want to use MySQL 9, you must be using a more recent […]
MySQL 9.0 – it’s time to abandon the weak authentication method
With the latest MySQL Innovation Release, we decided that it was time to remove the remaining weak authentication plugin: mysql_native_password. We previously deprecated it and made it not default loaded in MySQL 8.4 LTS and, now, in 9.0 it’s gone! Reasons Oracle places significant attention on the security of all its products, and MySQL is […]
Advanced Data Load with MySQL Shell
Over the last few years, I have become quite smitten with MySQL Shell. For those who may not be familiar with MySQL Shell, it is a new(ish) command line interface (CLI) for connecting to and managing MySQL instances. During a recent episode of Inside MySQL: Sakila Speaks, Fred and I talked to Miguel Araujo about many of the helpful […]
MySQL 9.0 is out! Thank you for your contributions!
On July 1st, 3 new releases of MySQL came out. Indeed, we released the next 8.0 (8.0.38), the first update of the 8.4 LTS (8.4.1), and the very first 9.0 as Innovation Release. We now support 3 versions of the most popular Open Source database. With these releases, we also want to thank all the […]
Effortlessly Build AI-Powered Q/A Apps Using HeatWave GenAI
Introduction Generative AI (GenAI) and Retrieval-Augmented Generation (RAG) are transforming industries by enabling advanced, context-aware automation and intelligent information retrieval. HeatWave, a fully managed database service, further enhances this landscape by offering real-time analytics, machine learning, and transactional processing within a single platform. Together, these technologies empower businesses to leverage data-driven insights and streamline complex […]
Advanced Data Dump with MySQL Shell
Over the last few years, I have become quite smitten with MySQL Shell. For those who may not be familiar with MySQL Shell, it is a new(ish) command line interface (CLI) for connecting to and managing MySQL instances. During a recent episode of Inside MySQL: Sakila Speaks, Fred and I talked to Miguel Araujo about many of the helpful […]
How to setup FastAPI with MySQL HeatWave and Post the Data into MySQL
Introduction: In this blog, we will walk through the process of inserting data into a MySQL table using FastAPI. FastAPI is a modern, fast (high-performance), web framework for building APIs with Python based on standard Python type hints. MySQL HeatWave is a fully managed database service, powered by the HeatWave in-memory query accelerator. It’s the […]
Generative AI in HeatWave: Introduction
Generative AI (GenAI) is advancing rapidly, emerging as one of the most exciting and transformative technologies. Just imagine the power of instantly getting actionable insights from vast amounts of unstructured data without needing expertise in AI or having to move data out of the database. Consider a semiconductor manufacturer sorting through extensive and complex manufacturing […]