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 import data from PostgreSQL to MySQL Database Service
MySQL Database Service (aka MDS) is very popular and many users wants to benefit from the managed MySQL service and from MySQL HeatWave. We see many users migrating their data from MySQL on-premise or from another cloud vendor to MDS… we also see people migrating from other data-stores like PostgreSQL. In this article we will […]
MySQL Autopilot – Machine Learning Automation for MySQL HeatWave
Introduction MySQL is the world most popular open source database because of its reliability, high-performance, and ease of use. MySQL has been designed and optimized for transaction processing and enterprises around the world rely on it. With the introduction of HeatWave in MySQL Database Service, customers now have a single database which is efficient for both […]
MySQL Database Service: administrator user
On MySQL Database Service (aka MDS) on Oracle Cloud Infrastructure (aka OCI), when you create a new instance, you also need to set the credentials for the administrator: Let’s focus on that account… Please don’t forget the password, it cannot be recovered !! First of all that account’s username has some limitations. Indeed, some names […]
MySQL 8.0: all you need to know about SDI
We recently saw that .frm files have been somewhat of replaced for MyISAM tables in MySQL 8.0 (see this post). However, what are those files ? Can they be used for something else than MyISAM tables ? … Let’s try to answer those questions and get more familiar with the .sdi files. What does SDI […]
MySQL Database Service: Snapshot your data – restore
On Oracle Cloud Infrastructure, aka OCI, MySQL Database Service, aka MDS uses the snapshot technology to backup your data. This article is the second part of multiple part blog series. In part 1, we dealt with taking snapshots as backup. In this part, we deal with restoring the data. Managed Snapshots We saw in the […]
MySQL Database Service: Snapshot your data – backups
On Oracle Cloud Infrastructure, aka OCI, MySQL Database Service, aka MDS uses the snapshot technology to backup your data. I will explain how it works in the multiple part blog series. In part 1, we will deal with taking snapshots as backup. In part 2, we will see how to restore data and for which […]
Using OCI Cloud Shell & Bastion with MySQL Database Service
Recently, Oracle added a Bastion Service to OCI. And you may also have noticed that the OCI Dashboard offers you the possibility to use a browser based terminal: Cloud Shell. Today, we will see how we can use these two components to connect from the browser to a MDS DB System. We need the MySQL […]
MySQL Shell Dump & Load and Compression
MySQL Shell is the popular tool to work with MySQL and it integrates perfectly everything for MySQL Database Service (MDS) in Oracle Cloud Infrastructure (OCI). For any logical dump and load of data and especially to dump data to MDS, MySQL Shell Utility is the recommended solution. MySQL Shell Dump & Load is faster, is […]
MySQL: Character Sets, Unicode, and UCA compliant collations
With MySQL 8.0, the version of MySQL Database Service aka MDS, the default character set has changed from latin1 to ut8mb4. The default collation is utf8mb4_0900_ai_ci but what does that mean ? and why are the utf8mb4_0900_* the recommended ones ? Collations like utf8mb4_unicode_520_ci and utf8mb4_0900_ai_ci are based on Unicode Collation Algorithm (UCA). The number […]
Migrate Ownership of your stored routines, views and triggers for MySQL in 2021
Yesterday my friend and ex-colleague Sveta published a blog post on how to migrate ownership of stored routines, views and triggers in MySQL. I usually agree a lot with her and even if I agree with what she wrote, there is one single point I would like to comment: use MySQL Shell ! In the […]