Featured

Troubleshoot MySQL/LDAP Auth_pam error when apparmor is enforced

On By Mikael HOUNDEGNON GBAIIn UncategorizedLeave a comment

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

Featured

How to skip transaction on replica when GTID replication is broken

On By Mikael HOUNDEGNON GBAIIn High AvailabilityLeave a comment

What’s GTID A Global Transaction Identifier (GTID) is Unique ID created and associated with each transaction committed on the primary database. Format of GTID GTID=source_id:transaction_id Where: The source_id identifies the originating serverThe transaction_id is a sequence number determined by the order in which the transaction was executed Example: 4a7d0f2e-0985-11e9-a0f0-005056a474e3:1-40093708 Skipping Transaction When GTIDs Are Enabled …

Continue reading How to skip transaction on replica when GTID replication is broken

Featured

MySQL Trainings – Install and configure MySQL Server on AWS EC2

On By Mikael HOUNDEGNON GBAIIn Uncategorized1 Comment

https://www.youtube.com/embed/-7INU3L-MMk Create an AWS EC2 Instance  How to install Percona MySQL 5.7 sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpmyum list | grep perconayum install Percona-Server-server-57service mysqld startsudo grep "temporary password" /var/log/mysqld.log # copy the passwordmysql_secure_installationmysql -uroot -p How to install Oracle MySQL 5.7 Community Edition  sudo yum localinstall https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpmyum repolist all | grep mysqlsudo yum install mysql-community-serverservice mysqld startsudo …

Continue reading MySQL Trainings – Install and configure MySQL Server on AWS EC2

Featured

Alter large Production MySQL table without blocking reads or writes with pt-online-schema-change

On By Mikael HOUNDEGNON GBAIIn MySQL TIPSLeave a comment

pt-online-schema-change is a binary part of Percona-toolkit packages by Percona. It’s one of the most stable and efficient, tools for performing large MySQL table structure change in live production database, minimizing DB downtime without blocking reads and writes while performance your alter in back-end. pt-online-schema-change works by : creating an empty copy table test_table_new of the table test_table to alter, alter …

Continue reading Alter large Production MySQL table without blocking reads or writes with pt-online-schema-change

Featured

Setup a simple MySQL Master Slave Replication

On By Mikael HOUNDEGNON GBAIIn High AvailabilityLeave a comment

Requirements This topic assumes that you have user with sudo privileges and have MySQL installed on both server(Master & Slave). If you do not have MySQL server installed, you can install it with this topic .  My Master IP address is 192.168.147.12, and my slave is at 192.168.147.16. You must also make sure you have …

Continue reading Setup a simple MySQL Master Slave Replication

Training – MySQL Database Administrator

On By Mikael HOUNDEGNON GBAIIn MySQL TrainingsLeave a comment

Prerequisites Experience with relational database concepts; knowledge of basic SQL statements; understand how to execute Linux/Unix commands. Audience Cloud Administrators Database Administrators Database Designers Web Administrators Topics Install and configure MySQL Server on AWS EC2 Installation of MySQL 5.7 25 minutes Upgrade MySQL on Running servers Tips to Upgrade and what you should know before upgrade …

Continue reading Training – MySQL Database Administrator

Should i run MySQL server on Windows or linux

On By Mikael HOUNDEGNON GBAIIn UncategorizedLeave a comment

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

How to find unregistered user trying to login in MySQL

On By Mikael HOUNDEGNON GBAIIn MySQL TIPS, UncategorizedLeave a comment

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

Dolphie new open source monitoring tools for MySQL DBAs

On By Mikael HOUNDEGNON GBAIIn MySQL TIPSLeave a comment

Welcome to Dolphie, new open source CLI monitoring tool for MySQL DBAs. It's an alternative to innotop and very easy to use, more details on the #github repo https://lnkd.in/gyFVHxrx Installation Requires Python 3.8+ Using PyPi $ pip install dolphie Using Poetry $ curl -sSL https://install.python-poetry.org | python3 - $ poetry install Using Homebrew If you …

Continue reading Dolphie new open source monitoring tools for MySQL DBAs

MySQL Server 8.0.33 Crash when FIPS is enabled only on OS side

On By Mikael HOUNDEGNON GBAIIn MySQL TIPS, UncategorizedLeave a comment

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

Fix MySQL Async replication Error 1236 within GTID Replication

On By Mikael HOUNDEGNON GBAIIn High Availability, UncategorizedLeave a comment

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

How to fix Fatal error: mysql.user table is damaged. Please run mysql_upgrade.

On By Mikael HOUNDEGNON GBAIIn MySQL TIPSLeave a comment

If your error message is similar to the following in your mysql error log you can use the following tips to fix it 2022-06-21T12:44:27.206605Z 0 [ERROR] Fatal error: mysql.user table is damaged. Please run mysql_upgrade. 2022-06-21T12:44:27.206633Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files. 2022-06-21T12:44:27.206671Z 0 …

Continue reading How to fix Fatal error: mysql.user table is damaged. Please run mysql_upgrade.