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…
Matomo is a Google Analytics alternative for your websites. If you follow my blog, you know how easy it’s to deploy popular Open Source web solutions like WordPress, Joomla!, Drupal, Moodle, Magento on OCI. If this is not yet your…
Yesterday, Oracle announced a new range of Arm compute instances based on Ampere’s ARM processors This is a very nice announcement ![1], [2] and something also very cool is that you are eligible for an Always Free instance up to…
Yesterday, we saw how to easily deploy Moodle to OCI with MDS. Today we will see how to enable https to that new created Web site. In this post we use Moodle but it is exactly the same process for…
Moodle is the world’s most popular learning management system. Moodle is Open Source and of course it’s compatible with the most popular Open Source Database : MySQL ! I’ve already posted an article on how to install Moodle on OCI…
Magento is an Open-Source e-commerce platform written in PHP using multiple other PHP frameworks such as Laminas and Symphony. Magento source code is distributed under Open Software License v3.0. Deploying Magento is not always easy as it often requires registration.…
The easiest way to deploy Joomla! on Oracle Cloud Infrastructure and MySQL Database Service, is to use OCI Resource Manager’s stack. Let’s see how easy it’s to deploy such solution. If you don’t have already an OCI account, you can…
From MySQL Shell 8.0.24, it’s possible to log all the SQL statements issued in MySQL Shell. Everything is well documented in the dedicated manual section: System Logging for SQL Statements. Let’s see it in action. We will first start MySQL…
Recently I posted an article on how to deal with arrays when trying to use MySQL Shell Dump Utility in command line. Of course, this proposed solution was a workaround for MySQL Shell <= 8.0.23. The new version of MySQL…
MySQL 8.0.24 has been released today \o/ 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. Let…