Planet MySQL HA Blog
The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.
Using Cloud Shell with MySQL HeatWave Database Service in OCI
Last time we tried to connect to a MySQL DB instance in OCI with Cloud Shell, we needed to use the bastion service. See here. Now, we also have the possibility to bypass the bastion host as Cloud Shell offers the possibility to change network. As you know, in Oracle Cloud Infrastructure, a MySQL DB […]
WordPress with MySQL on OCI always Free
I already wrote on how to deploy WordPress on OCI using MySQL HeatWave, the MySQL Database Service in Oracle Cloud Infrastructure: Using MySQL Database Service for WordPress Deploying WordPress on OCI with MySQL Database Service: the easy way ! Deploy WordPress on OCI using MySQL Database Service Deploy WordPress on OCI with MySQL Database Service […]
How to modify Time Zone system variable for running MySQL database service(MDS) instance ?
There are some scenarios where application do require to show datetime with regional time zone(let’s say application user wanted to show data in India IST time zone). By default MySQL database service(MDS) has UTC time zone and in order to change the system variable of time_zone you can’t do at this moment by SQL commands […]
Where you can find MySQL during June – August 2023
Our pleasure to inform you about the events and conferences where you can find MySQL Community or MySQL during June to August 2023. Please join us at any of them below! We are looking forward to meeting and talking to you at any of the conferences above!
How to modify sql_mode system variable dynamically for running MDS Instance
One of frequently asked question from customer to modify sql_mode system variable while running MySQL database service(MDS) instance. As you know MySQL server can operate in different SQL modes and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. MySQL DBAs/Developer can set the global SQL mode to match […]
Explore the new MySQL Enterprise Data Masking and De-Identification Features
Overview Data privacy is an important issue and a core requirement for regulatory compliance. Its required by: Data masking and de-identification enable the delivery of useful information or assure proper data presentation without violating privacy. MySQL Enterprise Edition provides the following capabilities to deal with the problem: Masking parts of text by replacing meaningful characters […]
Multithreaded Data Dumps With MySQL Shell
MySQL Shell is a powerful command line interface for connecting to and managing MySQL instances. One feature of MySQL Shell’s Admin API is being able to dump specific tables (or a subset of data in a table), dump one or more complete schemas, or dump an entire database instance and then restore those dumps as needed. It has the added […]
MySQL at PerconaLive, DOAG-DB and OpenSource Nagoya in May 2023
We are happy to announce our attendance at following conferences by end of May 2023 which should not be missed. Please find our MySQL team at three physical shows and one virtual one as follows: DOAG-DB, May 24- 25, 2023, Dusseldorf, Germany Find MySQL & Oracle at the Oracle booth at the DOAG-DB as well […]
How to Migrate from MariaDB to MySQL HeatWave
We see an increase in the demand for database migration from MariaDB to MySQL. This is likely due to recent news about MariaDB. [1][2][3][4][5][6][7][8] In this article, we will show you how to migrate from MariaDB to MySQL HeatWave in Oracle Cloud Infrastructure (OCI). If you plan to migrate from MariaDB to MySQL on-premise, please […]
MySQL at FOSSASIA 2023 Report
In 2023, FOSSASIA returned as a physical event after 2 years of being virtual. With this comeback, the MySQL team was again part of the 2023 edition with MySQL keynote, several technical sessions and the MysQL booth. Despite the fact that only 200 participants turned out to be from the initially announced 1000 expected […]