lefred's blog


There Are 10 Types of People in the World....

From MySQL Group Replication to MySQL InnoDB Cluster

I wanted to be brave and I installed MySQL Group Replication manually…. it was painful ! Then I realized that managing those servers and especially deal with MySQL Routers was even more painful ! What are my options now ? Is there a solution or do I need to restart from scratch ? Asking the answer is already answering it… … Read More


MySQL 8.0 – Who stopped mysqld and how long did it take ?

In MySQL 8.0.21, we can see who and how mysqld was stopped and when the process ended. Let’s have a look at different scenarios in this article. SHUTDOWN SQL statement The first test is to initiate the shutdown of MySQL from a SQL client: mysql> shutdown; In the error log (log_error_verbosity is set to 2, the default), we can see: … Read More


Today is a good day…

Today is a good day for me. Today I tweeted that MySQL after 25 years is still GPL and same for all important components: the server, the shell, the router, the clone plugin, workbench ! To be honest, Oracle has been a very good steward for MySQL so far, PZ and Kaj admitted it too. This exactly what I was … Read More


HA for our website’s database in OCI with MySQL InnoDB Cluster

In the previous post, we setup a Drupal website with MySQL as backend on a different compute instance in a different subnet. Today we will increase the High Availability of our Database by transforming this single MySQL instance into a MySQL InnoDB Cluster!


Using OCI to install Drupal and MySQL 8.0

My previous post related on how to install WordPress on Oracle Cloud seemed to be very popular. To continue the exploration of OCI, today we will install Drupal. This time, even if it’s possible to use the Free Trier like in the WordPress post, I will use a pay account to have the possibility to split the Web Server and … Read More


I deeply value the diversity of MySQL developers, users, community and my blog readers. I cannot agree the suffering, oppression, and systemic racism the Black community faces every day. Black lives matter.
recent
categories