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 the MySQL REST Service

MySQL REST Service The MySQL REST Service (MRS) enables fast and secure HTTPS access for your MySQL data. Implemented as a MySQL Router feature, MRS provides the ability to publish RESTful Web Services for interacting with the data stored in MySQL solutions. MySQL Shell for VS Code offers an intuitive way to configure MRS and create RESTful […]

Learn More »

preFOSDEM MySQL Days 2023 Recap

In 2023, FOSDEM returned as an in-person conference after being virtual for 2 years. With this comeback, the MySQL Team once again hosted the very popular preFOSDEM MySQL Days, a side event we have been doing since 2018. It was a blast ! It was great to see so many friends of MySQL in person. […]

Learn More »

MySQL HeatWave Best Practices Series: Data load to HeatWave with MySQL Autopilot

MySQL HeatWave Best Practices Series: Data load to HeatWave with MySQL Autopilot   In the first blog of the best practices series, we discussed the best practices for schema design. In this blog, we go into details of best practices of loading data to HeatWave. This is the first criteria of running queries in HeatWave […]

Learn More »

MySQL Rockstars 2022

After having cancelled 2 editions of the preFOSDEM MySQL Days because of the pandemic, we were finally back last week in Brussels for 2 wonderful days dedicated to the Dolphin database developed by Oracle. During this event and for the first time, we, the MySQL Team, decided to reward some members of the MySQL Community […]

Learn More »

Connecting to a MySQL HeatWave Database Instance Using an OCI Network Load Balancer

MySQL HeatWave Database is a fully managed service on Oracle Cloud Infrastructure (OCI) that is developed, managed, and supported by the MySQL team at Oracle. When you provision a new MySQL instance under OCI, you can only connect to the database from inside the OCI network. While this is a great security feature for production services hosted in […]

Learn More »

MySQL Document Store – Peeking Under the Covers

MySQL Document Store is a ‘NoSQL’ solution built on top of MySQL. Last month, I gave a talk at THAT Conference about using MySQL Document Store with Node.js. During that talk, one of the attendees asked if it was possible to see the underlying queries executed when we use the CRUD API in Document Store. I did some poking around, […]

Learn More »

Outgrowing your data platform? Successful startups turn to MySQL HeatWave

Startups and scale-ups often reach a point where they need to reconsider their applications’ data platform to effectively scale. These organizations’ initial platform typically allows them to rapidly get going and cope with unpredictable user base growth and volatile demand. However, once the product-market fit has been established and growth has reached a tipping point, it may no […]

Learn More »

Introducing Point-in-Time Recovery for MySQL Heatwave Database Systems

The MySQL Heatwave Database Service in the Oracle Cloud Infrastructure (OCI) permits users to take automatic, periodic backups of their MySQL database systems (DB Systems). However, if the backup were configured to occur in the middle of the night and the data-altering event occurs during the middle of the day, there could be hours of […]

Learn More »

Migrating from a Live On-premises MySQL 5.7 Database to MySQL Database Service Using GTIDs

MySQL Database Service supports migrations from a live on-premises MySQL 5.7 database to a MySQL DB system on Oracle Cloud Infrastructure (OCI) in almost real-time using replication. Migrating the data in real time helps you achieve minimal downtime and verify that your live production data is all good. If you have not migrated to MySQL Database Service, it is high […]

Learn More »

Announcing MySQL Shell 8.0.32

MySQL Shell 8.0.32 was released last week and includes several bugfixes as well as some new features. Let's look into what was added in this new release. New Features $ cat ~/.my.cnf [client] user=root host=lefred password=lefreptwasswort $ mysqlsh MySQL Shell 8.0.32-commercial Copyright (c) 2016, 2023, Oracle and/or its affiliates. Oracle is a registered trademark of […]

Learn More »