MySQL slave after upgrade from 5.6.x to 5.7.x may throw the following error: The best solution for this error is to: Master server – mysqldump…
MySQL
Using xtrabackup to make fast MySQL backups – backup and restore
Percona provides a really interesting tool for MySQL backups! It works on a live running MySQL server by copying the MySQL binary files from the…
edit mysql options in docker (or docker-compose) mysql
Modifying the default options for the docker (podman) MySQL server is essential. The default MySQL options are too conservative and even for simple (automation?) tests…
docker mysql – Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root!
Pulling the official MySQL image from the docker registry https://hub.docker.com/r/mysql/mysql-server to start a MySQL instance with your configuration file (and MySQL binary files). Adding the…
MariaDB/MySQL replication error – Error during XID COMMIT: failed to update GTID state in mysql.gtid_slave_pos
When in aggressive parallel mode MariaDB/MySQL replication could fail with: This table is used for tracking the replication process and you might probably just do:…
The impact of enabling MySQL sync_binlog – really high disk IO
If you enable this feature in your MySQL you could increase your disk IO time and write by 8-10x times. Generally, this feature could save…
Upgrade MySQL 5.6 to 5.7 what problems to expect with old my.cnf configuration file
Finally, we do not have any more MySQL 5.6 servers. We upgraded our last part of the system with MySQL 5.6 to 5.7. In our…
mysql – Error ‘Your password does not satisfy the current policy requirements’ or zero length mysql password
We got this error when granting permissions for one of our new slave server (it could be for an ordinary MySQL server, too): It appeared…
mysql – Error ‘Column count of mysql.user is wrong. Expected 45, found 43. The table is probably corrupted’ on query.
If you upgraded your MySQL server (from 5.6 to 5.7 or above) or imported a MySQL dump SQL file from older version than your current…
Replication hangs with Relay_Master_Log_File mysql-bin.999999 -wrong variables in mariadb (MySQL) show slave status
Several days after another .999999 hang out – mariadb (MySQL) stopped flushing relay-bin log after mysqld-relay-bin.999999, the monitoring of one of the slaves got critical…