Running MySQL on a Windows server is not necessarily "not recommended," but there are several factors that might make it less ideal compared to running it on a Linux server in certain scenarios. Here are a few reasons: Performance: Historically, MySQL has been optimized for Linux/Unix environments, which may result in better performance compared to …
Continue reading Should i run MySQL server on Windows or linux
Unregistered user that is trying to login to MySQL can generate below error is MySQL error log 2023-10-25T15:13:38.913862Z 1716 [Warning] [MY-013360] [Server] Plugin sha256_password reported: ''sha256_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead' as you can see none of my user is using sha256_password mysql> select user, host …
Continue reading How to find unregistered user trying to login in MySQL
FIPS is Federal Information Processing Standards 140-2 (FIPS 140-2) describes a security standard that can be required by Federal (US Government) agencies for cryptographic modules used to protect sensitive or valuable information. When FIPS is enabled on the Operating System and not enabled in MySQL it crashed with the following error 2023-07-24T14:32:44.925574Z 4 [System] [MY-013381] …
Continue reading MySQL Server 8.0.33 Crash when FIPS is enabled only on OS side
This error is related to the Replication IO_Thread being stopped with Error Number 1236. The error Message 1236 can be triggered by many reason i will try my best to cover the most common reasons. Please keep in mind i'm using GTID replication, in case you're using Binary log file/position replication some solution to fix …
Continue reading Fix MySQL Async replication Error 1236 within GTID Replication
Reposting Frederic Descamps article about MySQL SSL Connection using self certificate https://blogs.oracle.com/mysql/post/howto-connect-to-mysql-using-a-client-certificate
First let setup MySQL to use auth_pam authentication and trigger the issue we want to troubleshoot Check if PAM authentication is setup root@db-test3:/usr/lib64/mysql/plugin# cat /etc/pam.d/mysql #%PAM-1.0 auth required pam_sss.so account required pam_sss.so Create a user with auth_pam plugin mysql> INSTALL PLUGIN auth_pam SONAME 'auth_pam.so'; mysql> CREATE USER mgbai@'127.0.0.1' IDENTIFIED WITH auth_pam AS 'mysql'; mysql> GRANT …
Continue reading Troubleshoot MySQL/LDAP Auth_pam error when apparmor is enforced
Suivre la formation en Anglais Lieu: TBD Date: TBD Quel est le But: Un system de base de données disponible 24H/24 tolérant au panne et au maintenance 90% => 36,5 jours/an || 99,9999% => 31 sec/anBase de données géographiquement répartie (Benin, Togo, Ghana, Paris, ....., etc)Répartition des charges de lecture sur les bases de données …
Continue reading Formation sur les Architectures de Haute Disponibilité avec MySQL
Sometime ssh-copy-id package is not available most likely in Windows OS or it's blocked in your environment. If that's your case you can use following trick to copy over your SSH public key to allow password-less authentication. Replace [user]@[host] with your own username and host. ssh [user]@[host] 'mkdir -m 700 ~/.ssh; echo ' $(< ~/.ssh/id_rsa.pub) ' >> …
Continue reading How to Copy your SSH Public Key without ssh-copy-id
Sometimes when Oracle MySQL is already installed and you want to install percona xtrabackup after you can have the following conflict yum install percona-xtrabackup Transaction check error: file /etc/my.cnf from install of Percona-Server-shared-56-5.6.30-rel76.3.el7.x86_64 conflicts with file from package mysql-community-server-5.7.13-1.el7.x86_64 Below 3 steps will help you to resolve the issue : 1) Download mysql-community-libs-compat from …
Continue reading Fix Percona Xtrabackup Installation conflicts with mysql-community-server
Optimize MySQL table_open_cache The number of open tables for all threads. Increasing this value increases the number of file descriptors that mysqld requires. You can check whether you need to increase the table cache by checking the Opened_tables status variable. If the value of Opened_tables is large and you do not use FLUSH TABLES often …
Continue reading Easy Way to optimize MySQL Table Open_cache variable
Mikael HOUNDEGNON MySQL Wall 