Quick fix / fallback for an error returned by #Mysql8 .
It's fine enough for local installs, when a client doesn't support `caching_sha2_password` #authentication plugin.

"SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client"

1. Add to `my.cnf`

[mysqld]
default_authentication_plugin=mysql_native_password

2.

ALTER USER 'root'@'localhost'
IDENTIFIED WITH mysql_native_password
BY 'password';

Sources:

https://dev.mysql.com/blog-archive/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password-compatible-connectors

Query and Transaction size in MySQL
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 need to split the t
https://lefred.be/content/query-and-transaction-size-in-mysql/
#8.0 #MySQL #MySQL8.0 #MySQLShell #Performance_Schema

How to get client’s IP address when using MySQL Router ?
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 p
https://lefred.be/content/how-to-get-clients-ip-address-when-using-mysql-router/
#8.0 #HA #InnoDBCluster #InnoDBReplicaSet #MySQL #MySQL8.0 #Performance_Schema #Router

MySQL 8.0.33: thank you for the contributions
The latest MySQL release has been published on April 18th, 2023 (my eldest daughter's birthday).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
https://lefred.be/content/mysql-8-0-33-thank-you-for-the-contributions/
#8.0 #Contributions #MySQL #MySQL8.0

Book Review: MySQL Crash Course
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 the kind words to me in the book ;-)

About the
https://lefred.be/content/book-review-mysql-crash-course/
#8.0 #Books #MySQL #MySQL8.0

MySQL Database Service – find the info: part 4 – connections
As a MySQL DBA, you like to know who is connected on the system you manage. You also like to know who is trying to connect.

In this article, we will discover how we can retrieve the information and control who is using the MySQL DB instance we launched in OCI.

https://lefred.be/content/mysql-database-service-find-the-info-part-4-connections/
#8.0 #Cloud #Information_Schema #MDS #MySQL #MySQL8.0 #OCI #Performance_Schema

MySQL Database Service – find the info: part 2 – disk space utilization
This article is the second of the new series dedicated on how a DBA can find the info he needs with MySQL Database Service in Oracle Cloud Infrastructure.

The first article was dedicated on Backups, this one is about Disk Space Utilization.

This
https://lefred.be/content/mysql-database-service-find-the-info-part-2-disk-space-utilization/
#8.0 #Cloud #HeatWave #MDS #MySQL #MySQL8.0 #OCI #Performance_Schema

MySQL Database Service – find the info: part 1 – backups
In this new series of articles we will explore the different sources of information available when using MySQL Database Service on OCI to effectively perform your daily DBA job.

Of course there is way less things to take care of, like backups, upgrades, operating system and hard
https://lefred.be/content/mysql-database-service-find-the-info-part-1-backups/
#8.0 #Cloud #HeatWave #MDS #MySQL #MySQL8.0 #OCI #Performance_Schema

Still using MyISAM ? It is time to switch to InnoDB !
InnoDB has been the default storage engine for MySQL since version 5.5 (July 2010!).

If you are still using MyISAM as the storage engine for your tables, it might be time to consider migrating to InnoDB. InnoDB offers several advantages over MyISAM:

MVCC,

support for ACID transactions,

row-lev
https://lefred.be/content/still-using-myisam-it-is-time-to-switch-to-innodb/
#8.0 #General #InnoDB #MyISAM #MySQL #MySQL8.0 #rss

MySQL Rockstars 2022
After having cancelled 2 editions of the preFOSDEM MySQL Days because of the pandemic, we were finally back last week in Brussels for 2 wonderful days dedicated to the Dolphin database developed by Oracle.

During this event and for the first time, we, the MySQL Team, decided to reward some members of the MySQL Community that wit
https://lefred.be/content/mysql-rockstars-2022/
#Conference #Contributions #Fosdem #General #MySQL #MySQL8.0 #MySQLAwards #MySQLDay #rss

preFOSDEM MySQL Day 2023 Recap
In 2023, FOSDEM returned as an in-person conference after being virtual for 2 years. With this comeback, the MySQL Team once again hosted the very popular preFOSDEM MySQL Days, a side event we have been doing since 2018.

It was a blast ! It was great to see so many friends of MySQL in person. For two days, we learned from each others, we sha
https://lefred.be/content/prefosdem-mysql-day-2023-recap/
#Conference #Fosdem #MySQL #MySQL8.0 #MySQLDay #rss

MySQL 8.0.32: thank you for the contributions
The latest MySQL release has been published on January 17th, 2023. MySQL 8.0.32 contains some new features and bug fixes. As usual, it also contains contributions from our great MySQL Community.

I would like to thank all contributors on behalf of the entire Oracle MySQL team !

MySQL 8.0.32 contains patches from Facebook/Meta, Al
https://lefred.be/content/mysql-8-0-32-thank-you-for-the-contributions/
#8.0 #Contributions #MySQL #MySQL8.0

Sysbench 1.1.0 for Oracle Linux 9
Recently Jack asked me for a Sysbench package for OL9.

In this post, you can find the RPM packages of Sysbench 1.1.0 build for Oracle Linux 9, RedHat Enterprise 9 and any RPM compatible system.

Sysbench's binary is linked with libmysqlclient.so.21 and libssl.so.3.

Here are the two files, one for x86_64 and one for aarch64 (ARM):

sysbench-1.1.0-2
https://lefred.be/content/sysbench-1-1-0-for-oracle-linux-9/
#8.0 #MySQL #MySQL8.0 #rpm #sysbench

MySQL Connection Control
As a MySQL database administrator, have you ever faced a brute force attack on your database server or been the target of a DDOS-like connection flow on port 3306? If so, you will quickly understand why this plugin distributed with MySQL can be very useful in such situations.

Indeed, the connection-control plugin allows the administrator of a MySQL server to introduce an
https://lefred.be/content/mysql-connection-control/
#5.7 #8.0 #MySQL #MySQL8.0 #rss

Successful RDS to OCI MySQL HeatWave Migration with Replication Channel Filters
If you tried to migrate live from Amazon RDS/Aurora or any other Cloud to OCI MySQL HeatWave before December 6, 2022, you may have encountered issues with Amazon to OCI asynchronous replication.

See: Live Migration from Azure Database f
https://lefred.be/content/successful-rds-to-oci-mysql-heatwave-migration-with-replication-channel-filters/
#8.0 #Cloud #HeatWave #MDS #Migration #MySQL #MySQL8.0 #OCI #rss

Deploying Zabbix with MySQL HeatWave Database Service in OCI
In this article, I will guide you through the process of setting up a fully functional Zabbix monitoring system on Oracle Cloud Infrastructure.

The deployment and configuration of the Zabbix server and web frontend, as well as the integration with MySQL HeatWave Dat
https://lefred.be/content/deploying-zabbix-with-mysql-heatwave-database-service-in-oci/
#8.0 #Cloud #HeatWave #MDS #MySQL #MySQL8.0 #OCI #rss #Stacks #Terraform

Welcome Drupal 10 ! – How to easily deploy Drupal 10 on OCI with MySQL HeatWave
Drupal is a popular open-source content management system (CMS) that is used by businesses, governments, and organizations around the world to build and manage websites. It is known for its flexibility, scalability, and security features.

https://lefred.be/content/welcome-drupal-10-how-to-easily-deploy-drupal-10-on-oci-with-mysql-heatwave/
#8.0 #Cloud #Drupal #HeatWave #MDS #MySQL #MySQL8.0 #OCI #PHP #rss

Deploy WordPress on OCI with MySQL Database Service using Read Replicas
Oracle recently released Read Replica for MySQL Database Service (also known as MySQL HeatWave, with or without the use of HeatWave accelerator for OLTP and OLAP).

Read Replicas are read-only copies of the MySQL DB system in the same region. When you add Read Replica
https://lefred.be/content/deploy-wordpress-on-oci-with-mysql-database-service-using-read-replicas/
#8.0 #Cloud #MDS #MySQL #MySQL8.0 #OCI #wordpress

Howto connect to MySQL using a client certificate
More and more people are requesting how they could connect to MySQL without using a password but using a SSL certificate. Known as X509.

CA Certificate

A CA certificate is a digital certificate issued by a certificate authority (CA). It's used by clients to verify the SSL certificates sign by this CA.

Such certificates is usually p
https://lefred.be/content/howto-connect-to-mysql-using-a-client-certificate/
#8.0 #MySQL #MySQL8.0

pre-FOSDEM MySQL Days 2023
Hello dear MySQL Community !

As you may already know FOSDEM 2023 is again going to be held in-person. FOSDEM will take place February 4th and 5th 2023.

We have also decided to put our pre-FOSDEM MySQL Day on track for a fifth edition.

As for the last edition, the event will be spread over 2 days.

These 2 extra days related to the world’s most po
https://lefred.be/content/pre-fosdem-mysql-days-2023/
#Conference #Fosdem #MySQL #MySQL8.0 #MySQLDay