Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
WordPress in OCI with MySQL HeatWave Read Replicas and MySQL Router R/W Splitting
Some time ago, we saw how we could deploy WordPress on OCI using MySQL HeatWave Database Service with Read Replicas. We had to modify WordPress to use a specific plugin that configures the Read/Write Splitting on the application (WordPress): LudicrousDB. Today, we will not modify WordPress to split the Read and Write operations, but we […]
Where can you find MySQL during December – February 2024 – Update No.2
As a follow up to the previous blog from Aug 15, we are happy to announce a list of events and conferences where you can find MySQL Community and/or MySQL Team at. Please see the updated list below, with past events at the end of the report below: Past Events:
Migrate from GCP Cloud SQL for MySQL to MySQL HeatWave on Oracle Cloud Infrastructure (OCI) using MySQL Shell
What is MySQL Shell Utility: MySQL Shell’s instance dump utility, schema dump utility, and table dump utility provide Oracle Cloud Infrastructure Object Storage streaming, MySQL HeatWave Service compatibility checks and modifications, parallel dumping with multiple threads, and file compression, which are not provided by mysqldump. Progress information is displayed during the dump. You can carry out […]
Parameterizing MySQL Queries in Node
There are very few absolutes in software development. One of these would be “NEVER trust user input”. You should never run a database query involving user input without validating, sanitizing, and parameterizing the user-provided values. If you neglect to handle user input correctly, specifically parameterizing the data, your application will be vulnerable to attack from nefarious […]
MySQL Shorts – Episode #48 Released
The latest Episode of MySQL Shorts is now available! Check out Episode 048 on the MySQL YouTube Channel. In this video we talk about how to install the lastest MySQL 8.0 & MySQL Innovation Release on Oracle Linux 8 and compatible (Rocky Linux 8, CentOS 8, RHEL 8).
MySQL Shorts – Top 5 Countdown – #3
For the last year, we have been producing a series of short-form videos titled “MySQL Shorts”. Each video focusses on a specific topic and are typically less than 5 minutes long. For our Advent Calendar of Content for 2024, we will be counting down the top 5 MySQL Shorts videos based on views as of […]
Capturing GPS Data on a Raspberry Pi and Storing It Using MySQL Document Store
In a previous post, I showed how you can install MySQL on a Raspberry Pi. In this post, I will show how to capture GPS data and store that data as JSON in MySQL Document Store. The Hardware I am using a Vilros starter kit that includes a Raspberry Pi 4 Model B 8Gb board, a case, and other accessories. I also ordered […]
MySQL data archiving: another use for HeatWave Lakehouse
MySQL HeatWave enables users to process and query hundreds of terabytes of data in the object store—in a variety of file formats, such as CSV, Parquet, and Aurora/Redshift export files. This ability to store data on Object Storage and retrieve it dynamically when necessary is a notable advantage of Lakehouse when managing MySQL historical data […]
Installing MySQL Innovation Release on a Raspberry Pi
A while back, I wondered if it was possible to run MySQL on a Raspberry Pi. Not only is it possible, but it is not as complicated as I expected. Read on to find out how. The Hardware The first thing I needed to do to get MySQL running on a Raspberry Pi was procure a Raspberry Pi. […]
Is MySQL HeatWave really faster ?
You may have come across numerous presentations showcasing MySQL HeatWave as a Query Accelerator for MySQL. However, if you have not yet had the opportunity to test it yourself (if you have, you already know the answer), allow us to conduct a test using actual data to determine the potential benefits of utilizing a MySQL […]