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…
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…
The MySQL Ecosystem has been using InnoDB as the default transactional engine for many years now. If you are one of the few still using MyISAM, it is time you also converted and benefited from InnoDB. If you plan to upgrade…
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 8.0.26 has been released last week ! As usual, it’s highly advised to read the release notes to get informed about the changes and bug fixed. MySQL is Open Source and each release contains contributions from our great Community.…
Recently, a benchmark comparing MariaDB and MySQL performance of ORDER BY over text columns didn’t really compare the same things. It was like comparing apples and oranges. The results are interesting of course, but I would like to point that…
If like me you are using MySQL Shell on many different systems and new installations, there are some commands I often use to benefit from my environment. What I really want to enable is the history of course, a nicer…
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…
Recently I blogged about how to easily deploy a LAMP application to MDS. Using the Terraform module (OCI Resource Manager’s Stack) you also have the possibility to choose the PHP version to install: But as you should already know, not…
For performance, having a warm InnoDB Buffer Pool is very important. What does that mean ? A warm buffer pool means that the most used pages (working set) required by the production workload are already loaded in memory (in the…
If you decided to move your data from Amazon Aurora to the real MySQL Database Service on OCI you can use the nice MySQL Shell Dump & Load utility to dump the data or the full instance. This is the…
Recently, I wrote several articles about how to deploy popular Open Source applications on Oracle Cloud Infrastructure and MySQL Database Service. Today we will see how you can deploy your own LAMP stack application using the same technique where L…