Moodle is an open-source learning management system (LMS) that provides a platform for educators and learners to create, manage, and participate in online courses and educational activities. Moodle is widely used in schools, universities, and other educational institutions to facilitate online learning, course management, and collaboration. Moodle and MySQL have always been a very powerful […]

Starting with MySQL Shell 8.0.33, it’s possible to fully enable SSL/TLS certificate-based authentication seamlessly across an InnoDB Cluster, ClusterSet or, ReplicaSet setup. Let’s dive into the details of the new features with complete examples of how to set up the strongest encryption configuration possible. Certificate Based Authentication For Intra-node Communication To secure and validate users for the […]

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 […]

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 […]

Some times it’s important to know the size of a transaction, especially when you plan to migrate to a HA solution where by default transactions have a limited size to guarantee an optimal behavior of the cluster. Today we will see the different possibilities to have an idea of the size of transactions. First we […]

When you connect to a server (or cluster) using a TCP proxy level 7, also referred to as an application-level or Layer 7 proxy (highest level of the OSI model), the application doesn’t connect directly to the back-end server(s). The proxy usually understands the protocol used and can eventually take some decisions or even change […]

On April 18 2023, MySQL Server 8.0.33 was released. It is the latest release of our MySQL 8.0 General Availability Release. The new release introduces a few new features alongside with some deprecations, as well as bugfixes and security fixes. New MySQL Enterprise Edition Data Masking Component MySQL Enterprise Edition now provides data masking and de-identification capabilities […]

The latest MySQL release has been published on April 18th, 2023. This new version of MySQL brings a new service that I’m excited to play with: Performance Schema Server Telemetry Traces Service. MySQL 8.0.33 contains bug fixes and contributions from our great MySQL community. I would like to thank all contributors on behalf of the […]

MySQL Shell 8.0.33 was released last week. Apart from several bugfixes, there are some new, important, and long-desired features related to security, concurrency control, and performance settings. Passwordless authentication (certificate-based authentication) The AdminAPI enables an easy set-up and maintenance of MySQL deployments, either for High Availability or Disaster Recovery. Security is crucial and InnoDB Cluster has support for […]

Today, I would like to present this new book from Rick Silva: MySQL Crash Course – A Hands-on Introduction to Database Development, No Starch Press, 2023. I participated in this project as technical reviewer and I really enjoyed reading the chapters Rick was writing as soon as they were ready… and thank you Rick for […]