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 8.0 INSTANT ADD and DROP Column(s) – 2
In my earlier blog (here) I gave a high level introduction of INSTANT ADD/DROP COLUMNS feature which was introduced in 8.0.29. Now in this blog I will go into low level details of design and its working. Before we go into more details, let’s talk about the on-disk row in InnoDB as it is very […]
Cut & Paste a User Creation Statement with MySQL 8 to MySQL HeatWave
Sometimes it’s convenient to retrieve the user creation statement and to copy it to another server. However, with the new authentication method used as default since MySQL 8.0, caching_sha2_password, this can become a nightmare as the output is binary and some bytes can be hidden or decoded differently depending of the terminal and font used. […]
Where to find official MySQL container images ?
If you are deploying MySQL on containers, one of the first tasks is to find the right image. There’s a certain amount of confusion, especially when we’re trying to help someone who’s having problems with their deployment. For example, when people say I’m using the official docker image… what does that really mean? Docker Hub, […]
Integrating DB Migrations Into Your MySQL Tests
In previous posts, I discussed how we can use Testcontainers to more easily test code that interacts with a MySQL Database and code that interacts with MySQL Document Store. In yet another post, I demonstrated how to manage database migrations using Knex. This post will show how we can leverage Knex to incorporate database migrations into our testing workflow. The Issues Writing tests […]
Automated Workload-Aware Data Loading and Unloading for MySQL HeatWave
Overview MySQL HeatWave is the perfect database service for organizations looking to analyze their data stored in MySQL. It provides a single MySQL database platform for analytic and mixed workloads, accelerates complex and analytic queries on real-time data without the complex and time-consuming ETL process. A MySQL HeatWave instance is a cluster composed of […]
Accelerating JSON Query Processing using MySQL HeatWave
Overview MySQL offers an efficient and easy to use JSON query processing natively within the relational database framework. The same capability is available in MySQL HeatWave. Developers have flexibility to either employ the conventional SQL interface or opt for the document-centric CRUD APIs. Applications written in high level programming languages such as Java, or .Net […]
Industry Analyst views on MySQL HeatWave’s Vector Store, Generative AI innovations
To mark the 3rd day of Oracle CloudWorld 2023, Oracle announced significant enhancements to MySQL HeatWave. These include support for vector store, generative AI, new AutoML capabilities for training, inference, and explanations on data in object storage as well as an enhanced recommender system, MySQL Autopilot enhancements, support for JavaScript, acceleration of JSON queries, and […]
Introducing Vector Store and Generative AI in MySQL HeatWave
MySQL HeatWave is a fully managed database service that provides an online transaction processing (OLTP) database, a real-time in-memory data warehouse, in-database automated machine learning, lakehouse, and Generative AI (in private preview) capabilities in a single cloud database service—without the complexity, latency, and cost of ETL duplication. It provides the best performance and price performance […]
New client option –no-login-paths: Turn off login path file processing
Background Most MySQL programs can read startup options from option files (sometimes called configuration files). Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time we run a program. One of the option files (clients only) is login path file. Login […]
Focus on Lakehouse at Oracle CloudWorld
Interested in data lakehouse platforms? Oracle CloudWorld offers you plenty of opportunities to learn about MySQL HeatWave Lakehouse and discover its new capabilities. MySQL HeatWave Lakehouse enables users to query half a petabyte of data in object storage in a variety of file formats. The query processing is done entirely in the HeatWave engine, enabling […]