https://wiki.itadmins.net/ 2026-05-23T11:05:10+00:00 https://wiki.itadmins.net/ https://wiki.itadmins.net/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2020-02-24T10:16:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.itadmins.net/doku.php?id=mysql_mariadb_galera:galera_autoxtrabackup&rev=1582539361&do=diff Bash based autoxtrabackup Back in 2014 Gregory Storme wrote a simple and effective innobackupex based Bash script for automated MySQL/MariaDB/Galera backups. The only other option I have found in a while was a Python script that carries the same name but is a MAJOR pain to install and configure when compared to the simplicity of a Bash script. text/html 2026-04-08T17:48:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.itadmins.net/doku.php?id=mysql_mariadb_galera:repair_and_optimization&rev=1775670482&do=diff Repair and Optimization Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server: mysqlcheck -u root -p --auto-repair --check --optimize --all-databases mysqlcheck is available in MySQL 3.23.38 and later. text/html 2020-02-24T10:16:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.itadmins.net/doku.php?id=mysql_mariadb_galera:utf8_mysqldump_and_restore&rev=1582539361&do=diff UTF-8 mysqldump and restore To help spread the load when doing a mysqldump backup to migrate to new hardware I make sure the production server is used only to read from the MySQL server and then send the data directly to the new server for writing into a dump file. To save a bit of bandwidth I gzip the stream on it's way to the new server as well. The problem with this approach is that mysqldump, by default, sends an