Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
How to use MySQL FEDERATED engine ?
For a long time, I never encountered any system using FEDERATED tables. But recently, there seems to be more interest for FEDERATED tables. Is this related to the increase of microservices? In a microservices architecture, services are typically designed to be small, loosely coupled, and independently deployable. Each service may have its own database, which […]
MySQL 8.0 INSTANT ADD and DROP Column(s)
Background In databases, rows are persisted on disk and for every row, columns’ value are stored on disk. Now, if a new column is to be added or an old column is to be dropped from a table, the contents of existing rows should be changed to reflect the correct values of columns present in […]
What’s in it for you? Attend Free MySQL Summit on March 23rd
MySQL Summit 2023 is right around the corner. If you consider yourself a *true* fan of the Dolphin, but haven’t made plans to attend this free event either in-person (Redwood Shores, CA) or online, you’ll be missing out on a critical chance to hone your MySQL skills by learning best practices directly from MySQL engineers. […]
Still using MyISAM ? It is time to switch to InnoDB !
InnoDB has been the default storage engine for MySQL since version 5.5 (July 2010!). If you are still using MyISAM as the storage engine for your tables, it might be time to consider migrating to InnoDB. InnoDB offers several advantages over MyISAM: <!– wp:list {"className":"","epStylingOptions":{"columnsResponsiveEnabled":false,"columnsHoverEnabled":false,"itemsSpacingResponsiveEnabled":false,"itemsSpacingHoverEnabled":false,"listStyleResponsiveEnabled":false,"listStyleHoverEnabled":false,"listIconResponsiveEnabled":false,"listIconHoverEnabled":false,"columns":{"target":"","responsive":…
SCALE 20x & OpenSource Online Spring 2023 with MySQL
We are happy to announce our presence at those two conferences this week. Please find details about SCALE 20x & OSC Online Spring MySQL Community and MySQL teams are attending: MySQL is a Silver sponsor of SCALE 20x with a MySQL booth. Do not miss following MySQL accepted talks: March 10 – 11, […]
MySQL Books: The MySQL Workshop
This is the first in a new series of articles about MySQL books that might be included in the library of a MySQL DBA or developer interested in MySQL. Let’s start with MySQL Workshop, a practical guide to working with data and managing databases with MySQL written by Thomas Pettit and Scott Cosentino. The editor […]
How to build MySQL 8.0 C API (libmysqlclient)
If you write C applications that need to connect to MySQL, you can use the MySQL C API aka libmysqlclient. The MySQL C API replaces the outdated MySQL-Connector-C. If you want to use MySQL 8.0 as a Document Store with the X Protocol, you need then to use MySQL Connector/C++ 8.0. Some have asked how […]
New MySQL HeatWave capabilities released in 8.0.32-u1
New MySQL HeatWave capabilities released in 8.0.32-u1 MySQL HeatWave has added new capabilities on both OCI and AWS platforms. Here is the list of features introduced in 8.0.32-u1. Deployment Configurations OCI MySQL High Availability support is now available in Limited Availability (OCI only) OCI MySQL high availability consists of three MySQL instances: a primary […]
How to Migrate from MariaDB to MySQL 8.0
We are seeing increasing requests for migrations from MariaDB to MySQL. MariaDB has significantly diverged, and is no longer drop-in compatible with MySQL. To migrate from MariaDB to MySQL, an in-place upgrade is not possible. A logical dump and load will be necessary. In this post I explain the process of such migration and the […]
Migrating from a Live On-premises MySQL 8.0 Database to MySQL Database Service Using GTIDs
MySQL Database Service supports migrations from a live on-premises MySQL 8.0 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. MySQL Database Service is a fully-managed service, powered by the integrated […]